Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-07-15 : 05:28:41
|
| I have just configured a linked server. On both the local server and remote server my Windows login has sysadmin access.Under the security tab of the linked server I have added my Local Login and ticked the Impersonate box.However when I try to run a stored procedure on the linked server I get the following error message:Could not connect to server 'POCSQL\POCSQL' because '' is not defined as a remote login at the server. Verify that you have specified the correct login name |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2011-07-16 : 11:09:54
|
| I know if you use domain\user name on linked servers it don't connect if you have not configured kerbos. Try a sql login and see if that works. To get linked servers with windows authentication you need kerbos setup |
 |
|
|
|
|
|
Linked Server problem