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