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 |
|
saglamtimur
Yak Posting Veteran
91 Posts |
 Posted - 2007-03-26 : 11:31:05
|
| Hi,I am trying to configure a linked server from 2005 to 2000. I have created a new user on 2000, and gave db access where needed. I created new user on 2005 with same credentials (username / password)which I created on 2000.Then, I tried to configure Linked server from 2005 to 2000. When I am trying to configure login mappings, I select the user from local login and check impersonate checkbox, and hit ok. But it gives me The OLE DB provider "SQLNCLI" for linked server "2kservername" reported an error. Authentication failed.Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "2kservername".OLE DB provider "SQLNCLI" for linked server "2kservername" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)error message.Ok, I remove impersonate checkbox and write remote user and password fileds. And again it gives me same error message.But when I select "Be mabe with this security context" from "For a login not defined int he list above, connections will:" section and fill same user name and password, it accepts and everthing works fine.What am I doing wrong?Any help will be appreciated. |
|
|
|
|
|
Linked server problem to SQL2K