SQL server replication requires an actual server name problem

When you are finished configuring mirroring, right-click Database----database mirroring Manager----Server connection when you find a linked mirror fails with the prompt message: replication requires an actual server name this error message online query can get many answers, First of all, the operation of their own steps to organize the following.

---------Step1:-----------------------

Use master

Go

SELECT @ @servername;

Select SERVERPROPERTY (' servername ')

-----result one is win-jmqpu0jcull, one for DB101 this is because the computer name has been modified to cause

Sp_dropserver ' win-jmqpu0jcull ', null

Go

sp_addserver ' DB101 ', ' local ', null

Go

------Restart the Msserver service--------

------through the Step1 script query results, the same, through the right click on the database--------database--------the task of managing the server connection and logging in with DB101, login successful

This article is from the "Oracle_lover" blog, make sure to keep this source http://oraclelover21.blog.51cto.com/2805838/1744343

SQL server replication requires an actual server name problem