Solving errors running the Configuration Utility (Offline Reporting - Replication SQL)

Document created by schri27 Employee on May 16, 2016Last modified by schri27 Employee on May 16, 2016
Version 2Show Document
  • View in full screen mode

When we make a replication to offline reporting, we can use a .bat file to help:

Run the Configuration Utility - CA Service Management - 14.1 - CA Technologies Documentation


But, sometimes we found some errors:

1 - ODBC Driver for SQL Server : Login Failed for user...



How to fix:

Check your connection SQL config: Maybe your login/password are correct, and the connection are good, but in my case was a port problem.

Open SQL Server Configuration > SQL Server Network Configuration > (Your Server/Instance)/Protocols > TCP/IP


You have to use that TCP Port in your CSV or .bat:





2 - You are getting error "Could not connect to server <servername> because '' is not defined as remote login at the server"

How to fix:

Check your linked servers, you have to create one. (Right click in Linked Servers > New ...)


Check RPC and RPC Out as true and define your role (Publisher, Subscriber, Distributor)



Also, set user/password (that you will use in Utility):





Tks EduardoDiersmann for help.

1 person found this helpful