Linked Server Blues
-
Trying to link two sql2000 servers running win2003 server.
Both have sp3a installed.
After setting up the link using sql and NT authentication on the first server and SQl authentication on the back, I get the following error.
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.].
This is greek to me. I confirmed the query runs unlinked and the security for all of the accounts looks correct. Can anybody help?
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.
-
Hi,
Have you set
DBCC traceon(7300)
to get some trace info from SQL Server. It may produce some useful results, showing u at least one property that you did not set or provide. Then correct the problem and see if it happens again
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me -
This error was caused by an accidental space at the end of the database name. When I backed up the database and restored it without the space, the problem was solved. Everything worked with the error except distributed queries.
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply