在SQL 2000建立發行集時,發生以下錯誤:
Could not connect to server [ServerName] because 'distributor_admin' is not defined as a remote login at the server.
可能是安裝完SQL Server後又變更Windows Server的Server Name所導致,請執行以下指令確認一下:
SELECT @@Servername
GO
SELECT SERVERPROPERTY('ServerName')
如果兩個結果出來的不一樣,代表問題的原因就如我所說的,執行以下指令將Server Name改過來
Use Mastergo
Sp_DropServer 'OldServerName'
GO
Use Master
GO
Sp_Addserver 'YourServerNameNow', 'local'
GO
再去設定一次Replication應該就可以了...
1 則留言:
Get any Desired College Degree, In less then 2 weeks.
Call this number now 24 hours a day 7 days a week (413) 208-3069
Get these Degrees NOW!!!
"BA", "BSc", "MA", "MSc", "MBA", "PHD",
Get everything within 2 weeks.
100% verifiable, this is a real deal
Act now you owe it to your future.
(413) 208-3069 call now 24 hours a day, 7 days a week.
張貼留言