April 7, 2011 at 2:04 pm
I am getting the following error when doing a cross server query and i found many thereads for the same which were poiting to link server issue but this is NOT a link server issue for sure because i have no problem querying other databases on the same server.
Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server "OBBEAVER".
April 7, 2011 at 2:14 pm
Are you using proper 4 part name ?
select * from Server1.Database.dbo.table
April 7, 2011 at 3:54 pm
Tara-1044200 (4/7/2011)
...i have no problem querying other databases on the same server.
Sure the linked server credentials have access to the db in question?
_____________________________________________________________________
- Nate
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply