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 |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2010-03-09 : 15:04:29
|
| I connected to Management studio. Created Linked server of server B on server A. I tried to select all the rows from a table, but i got this error. I'm sysadmin on both the servers.OLE DB provider "SQLNCLI" for linked server "server B" returned message "Invalid authorization specification".Msg 7399, Level 16, State 1, Line 1The OLE DB provider "SQLNCLI" for linked server "server B" reported an error. Authentication failed.Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "server B". |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-09 : 17:06:04
|
right click on linked server and look for correct credentials
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-11 : 04:02:19
|
quote:
Originally posted by prodigy2006
I connected to Management studio. Created Linked server of server B on server A. I tried to select all the rows from a table, but i got this error. I'm sysadmin on both the servers.OLE DB provider "SQLNCLI" for linked server "server B" returned message "Invalid authorization specification".Msg 7399, Level 16, State 1, Line 1The OLE DB provider "SQLNCLI" for linked server "server B" reported an error. Authentication failed.Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "server B".
script the linked server and post it here. It has something to do with the permissions. |
|
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-03-11 : 17:21:14
|
| I created a sql authenticated login on server B and went to the linked server properties and selected "Be made using this security context" and gave the login and password. This way I'm able to connect to server B from A.Earlier I used "Be made using login's currect security context" as I'm sysadmin on both the servers. But I'm getting the error"Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-12 : 00:02:57
|
quote:
Originally posted by prodigy2006
I created a sql authenticated login on server B and went to the linked server properties and selected "Be made using this security context" and gave the login and password. This way I'm able to connect to server B from A.Earlier I used "Be made using login's currect security context" as I'm sysadmin on both the servers. But I'm getting the error"Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
does this login 'NT AUTHORITY\ANONYMOUS LOGON' has appropriate permissions on both servers. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-03-12 : 08:08:49
|
| Read about Security Account Delegations. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-03-12 : 08:08:51
|
| Read about Security Account Delegations. |
|
|
|
|
|
|
|
|
Linked server