OPENROWSET statement fails

• Thomas George-390542

  Old Hand

  Points: 318

  More actions

  February 4, 2008 at 1:53 am

  #183676

  Hi all,

  I am using OPENROWSET statement to access data from a remote server.

  [font="Courier New"]select * from openrowset('SQLOLEDB','192.186.4.11';'sa';'',

  'SELECT * From TestPOS.dbo.invoice_header')[/font]

  It used to work fine. But all at a sudden, it stopped working.

  Now the statement takes too much time and gives the message -

  SQL Server does not exist or access denied.-

  eventhough there is no such problems visible.

  what could have gone wrong?

  can anybony help.?

  thanks in advance.

  Thomas george

• Adam Haines

  SSC-Insane

  Points: 23217

  More actions

  February 4, 2008 at 6:50 am

  #774725

  Can you connect to this server via SSMS using the IP and same credentials?

  ---

  
  My blog: http://jahaines.blogspot.com