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.