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

fklovejm 2005-07-11 03:25:56
配置分发服务器的时候出现"distributor_admin"未在该服务器上定义为远程登录.
请求支持!!!!!
...全文
141 点赞 收藏 3
写回复
3 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
duanduan1122 2005-07-11
解决方案:
1。
USE master
GO
2。
EXEC sp_dropserver 你当前的服务器名称
用select @@servername 可以查看你当前的服务器的名称。
EXEC sp_addserver 新的服务器名称, 'local'
3。
然后重新启动你的sql server服务器,就可以了
回复
duanduan1122 2005-07-11
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 2005-07-11
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.
回复
相关推荐
发帖
应用实例
创建于2007-09-28

2.7w+

社区成员

MS-SQL Server 应用实例
申请成为版主
帖子事件
创建了帖子
2005-07-11 03:25
社区公告
暂无公告