Hello,
I am trying to setup merge publication and receive the following
error:
SQL Server Enterprise Manager could not configure 'DEV' as the
Distributor for 'DEV'.
Error 18483: Could not connect to server 'DEV' because
'distributor_admin' is not defined as a remote login at the server.
Im stumped on this one.
Todd
Are you using an IP address to set up replication across domains? If so then
you'll need to use an alias instead.
Does SELECT@.@.Servername return a different name to your server select
SERVERPROPERTY('ServerName').
If so then you need to run:
Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services
Regards,
Paul Ibison
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment