Linked server issue

• ranvir_2k

  SSC-Addicted

  Points: 462

  More actions

  July 15, 2011 at 4:44 am

  #241504

  Hi all,

  I've created a linked server and am trying to run a query against it, however I'm getting the below error:

  select * from [Server\UAT3].master..syslogins

  Msg 7313, Level 16, State 1, Line 1

  An invalid schema or catalog was specified for the provider "SQLNCLI10" for linked server "Server\UAT3".

  Is there any way to fix this?

  Thanks

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  July 15, 2011 at 5:01 am

  #1353308

  This works:

  select * from [Server\UAT3].master.dbo.syslogins

  This also works:

  select * from [Server\UAT3].master.sys.syslogins