The distributor system throws a 18483 error and fails to connect to the server because "distributor_admin" does not define remote login.

The system throws a 18483 error and fails to connect to the server, because 'stributor _ admin' does not define remote login.

The following error occurs at the end of the snapshot copy setting on the distribution server:
Error 18483: failed to connect to the server because 'stributor _ admin' does not define remote logon on the server.

Why? How can this problem be solved ?? Thank you for your advice!

Solution:

I just fixed this problem. When you register a server in Em, it must be your SQL server startup name! If it is an IP address registered server, this situation will occur!
Another 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.

Meaning:
Run select @ servername in the query analyzer to view the computer name. If the computer name is different from the current one, perform the following operations.

Step 1: Delete the current service name oldservername as the name returned by the preceding select @ servername.
Sp_dropserver 'oldservername'

Step 2: add the name of the in-person computer. In fact, the name of sqlserver is the same as that of the computer. Actualservername is the computer name.
Sp_addserver 'actualservername', 'local'

Step 3: restart sqlserver.

How to view the computer name: Right-click my computer Properties