Error 18483 is always reported during Database Release and distribution configuration today.
Error 18483: failed to connect to the server "XXX" because 'stributor _ admin' is not defined as far .
My publishing and distribution are the same server. "XXX" is the name of my machine, and the distribution database is the default name. Is normal.
I checked on the Internet and explained a lot in this regard:
1: Reproduced http://blog.csdn.net/zdmilan /Archive/2005/06/24/401705 . Aspx
1. Set the shared copy directory:
\ Computer_machine \ C $ ...\. . If the server cancels the default share ($), it will fail. At this time, a new directory is created. And grant permissions to the directory \ computer_machine \ Shared directory name
2. Create a Windows account for publishing an application
3. An error occurred while configuring the distributor. The error 18483 is prompted because distributor_admin is not defined on this server.Unable to create
Solution: run the followingProgram)
Use master
Go
-- Set two variables
Declare @ serverproperty_servername varchar (100 ),
@ Servername varchar (100)
-- Obtain information about the Windows NT server and the instance associated with the specified SQL server instance
-- For details, refer to the online series "serverproperty"
Select @ serverproperty_servername = convert (varchar (100), serverproperty ('servername '))
-- Return the name of the local server running Microsoft & reg; SQL Server & #8482;
-- For more information, see books online @ servername.
Select @ servername = convert (varchar (100), @ servername)
-- If @ serverproperty_servernameDifferent from @ servername (because you changed the computer name)And then run the following
-- Delete the wrong server name
Exec sp_dropserver @ Server = @ servername
-- Add the correct server name
Exec sp_addserver @ Server = @ serverproperty_ Servername, @ local = 'local'
2: ZOU Jian replied:
/* -- Error 18483: failed to connect to the server 'xx' because 'stributor _ Admin'Remote logon is not defined on this server. --*/
-- This problem occurs because you have changed the computer name.
-- Execute the following statement and restart the SQL service.
If serverproperty ('servername') <> @ servername
Begin
Declare @ server sysname
Set @ server =servername
Exec sp_dropserver @ Server = @ Server
Set @ Server = cast (serverproperty ('servernamE ') as sysname)
Exec sp_addserver @ Server = @ server, @ local = 'local'
End
However, after executing the preceding SQL statement and restarting the service, I still reported the same error. Finally, I tried to manually change the registration name to be the same as the computer name, and the result was OK.