June 5, 2003 at 12:34 pm
I am a senior DBA in the process of testing SP3a on SQL2000. Our environment will require us to maintain 1 server running Sp3a and a 2nd server running sp2. Our users will have to run distributed queries from the sp3a server to the sp2 server.
I set up the linked server on the sp3a server mapping my network logon to a SQL logon on the SP2 box. Impersonation is not used. When I try to run a query from the SP3a query analyzer accessing the SP2 box, I receive the following error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Invalid authorization specification]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005: ].
My logon has SYSADMIN rights on both servers and the SQl logon has read rights for the database I am accessing. Everything is done in a single domain. Can anyone help?
"I hope you enjoy your retirement as much as I will."
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
June 5, 2003 at 3:02 pm
Found the Problem! My SYSADMIN rights were bundled in a group on the sp3 server and listed separately based on my network logon on the sp2 server. When I listed my rights separately on the sp3 server, that solved it.
Lesson: When setting up a linked server, make sure the userid's listed there are included in the security tab. Don't mix users and groups.
"I hope you enjoy your retirement as much as I will."
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply