hi all...
I have a little problem.
"18483 - could not connect to server 'Newname' because distributor_admin is
not defined as a remote login at the server."
Mehmet,
Try (using 'Newname')
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
If this is not the solution, please let me know if you are using IP
addresses for registered servers in Enterprise Manager.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
No comments:
Post a Comment