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 |
|
fralo
Posting Yak Master
161 Posts |
 Posted - 2010-12-07 : 11:30:49
|
| Hi all,I have set up a linked server and am running a query. The error returned is 'Login failed for user 'NT AUTHORITY/ANONYMOUS LOGON'.Any direction you could provide would be helpful. I'm kind of new to this so excuse my ignorance.I would assume that this problem would lie on the destination end (i.e. the queried server)? I'm using Management STudio 2005. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-07 : 11:42:19
|
| When you set up the linked server there is a security tab.Try it with using the current users credentials (or something like that)Then if you use a windows login to the current server it wil use that to login to the linked server.Otherwise easiest to map to a sql server login.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
fralo
Posting Yak Master
161 Posts |
Posted - 2010-12-07 : 11:51:44
|
| I see several users on the destination server under Security>Logins but don't know what their passwords are in order to hardcode the login for when I set up the linked server.Hope I'm making sense. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-07 : 12:08:33
|
| You need a login to connect to the remote server - that can be your windows login that you connect to the local serverwith or another login - but you will need the password (no point in having passwords otherwise you could just access any server from a linked server)==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-07 : 12:18:55
|
| For linked servers, you should:1. Make sure SQL Service Account is a domain account (on both servers)2. Make sure SPN for that account is registered for SQL Service3. Change security context of linked server to "Be made using logons current security context" |
|
|
|
|
|
|
Linked Server login failed problem