Post reply

Linked Server

  • November 17, 2009 at 7:30 am

    #136918

    I moved a database to another server now one of my report queries is breaking on this error:

    (1 row(s) affected)

    OLE DB provider "SQLNCLI" for linked server "VSWHATSUP01\WHATSUP" returned message "Login timeout expired".

    OLE DB provider "SQLNCLI" for linked server "VSWHATSUP01\WHATSUP" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

    Guessing it's becouse the new server is not a 'linked' server. So I added a linked server to the new Db server, still get the error..I'm missing something..

  • November 17, 2009 at 7:53 am

    #1080263

    Are you issuing a linked server query from the old server that's causing the error message?

  • November 17, 2009 at 9:14 am

    #1080338

    Yes thats' what I'm doing...

  • November 17, 2009 at 9:16 am

    #1080339

    are you linking from a SQL 2000 server to a SQL 2005 server?

  • November 17, 2009 at 9:22 am

    #1080350

    I got it

    thanks Crosan!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply