Problem with a linked server query

• Ganeshkumar005

  Ten Centuries

  Points: 1140

  More actions

  February 23, 2012 at 10:15 pm

  #257271

  "Could not find server 'xx.xx.xxx.xxx\MOBILETEST' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.".

  Linked server connection is fine.

  Query working fine if I execute on the destination server itself.

  Exec '[xx.xx.xxx.xxx\MOBILETEST].MobileBankingUAT.dbo.sprocname (parameters).

  Any idea why this issue?

  Regards,

  Ganesh.

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  February 23, 2012 at 11:49 pm

  #1451186

  Try replacing the IP with the server name. Are you able to access other procs within the server ?

  Jayanth Kurup[/url]