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...

ODBC_Driver11-LoginFailed.PNG

 

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

checkPorts.PNG

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

port.PNG

 

 

 

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_linkedServers.PNG

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

linked_properties.PNG

 

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

 

define_login.PNG

 

 

Tks EduardoDiersmann for help.

1 person found this helpful

Attachments

    Outcomes