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?



    Tuesday, June 19, 2007 8:49 PM


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