配置分发服务器的时候出现"distributor_admin"未在该服务器上定义为远程登录.

[fklovejm]

配置分发服务器的时候出现"distributor_admin"未在该服务器上定义为远程登录.
请求支持!!!!!

[duanduan1122]

CAUSE
When you deploy SQL Server 2000 from a hard disk image of another computer where SQL Server 2000 is installed, the network name of the imaged computer is retained in the new installation. The incorrect network name causes the configuration of the replication distributor to fail. The same problem occurs if you rename the computer after SQL Server is installed.

[duanduan1122]

You deploy SQL Server 2000 by using the hard disk image of another computer where SQL Server 2000 is installed. If you use SQL Server Enterprise Manager to configure a replication distributor, the configuration of the distributor may not be successful, and you receive the following error message:
SQL Server Enterprise Manager could not configure '<Server>\<Instance>' as the Distributor for '<Server>\<Instance>' .
Error 18483: Could not connect to server '<Server>\<Instance>' because 'distributor_admin' is not defined as a remote login at the server.

[duanduan1122]

解决方案：
1。
USE master
GO
2。
EXEC sp_dropserver 你当前的服务器名称
用select @@servername 可以查看你当前的服务器的名称。
EXEC sp_addserver 新的服务器名称, 'local'
3。
然后重新启动你的sql server服务器，就可以了