April 8, 2014 at 8:05 am
Hi Experts,
We are getting below error when tried to execute a procedure..
Msg 18483, Level 14, State 1, Line 1
Could not connect to server 'ABC\SQL4' because '' is not defined as a remote login at the server. Verify that you have specified the correct login name. .
Getting the same error when tried to run as job using SA account
April 8, 2014 at 8:15 am
Check if you are using linked server (or synonym that uses linked server). If this is the case, then you need to modify the linked server's login's configuration.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 8, 2014 at 8:57 am
Does sp_AddRemoteLogin '<Server>','<user>' solve the problem?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply