Feeds:
Posts
Comments

Posts Tagged ‘SQL Server Agent Job: Could not find server in sysservers’

This is quite a simple one for the DBAs. If you get stumped with a SQL agent error for your machine name, details are listed as follows:

Error: Could not find server in sysservers. Execute sp_addlinkedserver to add the server to sysservers. The statement has been terminated.

Solution:

  1. Open SSMS and verify that SQL Server name is correct
    use master
    Select @@Servername
    
  2. Run the following command
    Use Master
    GO
    Sp_DropServer 'myServer123'
    GO
    Use Master
    GO
    Sp_Addserver 'myServer786', 'local'
    GO
    
  3. Restart SQL Server service
  4. Re-run command on step#1. This should return back the correct machine name

Happy coding 🙂

Read Full Post »