locked
Error Message "Could not find server 'FLDB1' in sysservers.... RRS feed

  • Question

  • I'm getting the following message from a VB6 program running ADO...

     

    It will process a job then I get the message.... [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'FLDB1' in syssservers. Execute sp_addlinkedserver to add the server to sysservers...

     

    This started to happen after I moved the db from SS2000 to SS2005...

     

    Our db server and sql server instance on that server are both named 'FLDB1'... Do I need to run the above execute sp_addlinkedserver command on the new 2005 server?

     

    Thanks-Dave

    Tuesday, June 19, 2007 8:49 PM

Answers

  • Yes, that would be necessary since you most likely didn't migrate the list of linked servers.
    Tuesday, June 19, 2007 9:02 PM