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

Source: Internet
Author: User

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.