The Distributor system has thrown 18483 errors and failed to connect to the server because the ' distributor_admin ' does not have a remote login defined _mssql

The system has thrown 18483 errors and failed to connect to the server because the ' distributor_admin ' does not define remote login


When I was doing the distributor, I had the following error at the end of the snapshot replication settings:
Error 18483 failed to connect to the server because ' distributor_admin ' does not have remote logins defined on the server.

Why is that? How to solve Ah?? Hurry Ah, also ask you to teach!

Workaround:

I have just solved this situation when you register the server in EM, you must be the name of your SQL Server server startup! If this is the registered server for the IP address, this will happen!
The other solution is as follows:
Try SELECT @ @servername. If different from the actual server name, then use
Sp_dropserver ' Oldservername ' and after that sp_addserver ' actualservername ', ' local '
followed by a restart of the SQL service.

Chinese meaning:
Running SELECT @ @servername in Query Analyzer to see the computer name, if not the same as the current computer name, you need to do the following.

The first step: Remove the current service name Oldservername the name returned by the SELECT @ @servername above.
Sp_dropserver ' Oldservername '

Step two: Add face-to-face computer name in fact, the name of SQL Server is the same as the computer name. Actualservername is the computer name.
sp_addserver ' actualservername ', ' local '

Step three: Restart SQL Server.

How to view computer name: My Computer Right key property