The server cannot be found in SYS. servers. Execute the storage procedure sp_addmediaserver to add the server to SYS. servers.

Error: Microsoft ole db provider for SQL Server Error '20140901' the server 'sunmay2008/sqlexpress 'cannot be found in SYS. servers '. Verify that the specified server name is correct. If necessary, execute the Stored Procedure sp_addmediaserver to add the server to SYS. servers. /Admin/admin_templateproject.asp, row 1003 solution: this error occurs because the computer name of the server is changed. therefore, the server name cannot be found. if this error occurs, you can add a new server name. run the following statement in the query Analyzer:

 

Select * From SYS. servers (view the system table and check the original server name)

Sp_dropserver 'original server name' (delete original server name)
Sp_addserver 'current server name' (add current server name)
Sp_serveroption 'current server name', 'Data access', 'true' (set the SQL server option to allow it to join the linked server)