error when querying linked server

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

error when querying linked server

Author

Topic

chedderslam
Posting Yak Master

223 Posts

Posted - 2009-11-03 : 10:16:22

First time using a linked server, which our dba has set up.

select top 10 * from linked_server_name...table

I get this:
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'linked_server_user'.
OLE DB provider "SQLNCLI" for linked server "linked_server_name" returned message "Invalid connection string attribute".

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-03 : 11:06:17

correct syntax is:

select top 10 * from linked_server_name.database_name.schema_name.table

if still can't connect have DBA fix permissions

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources