471,893 Members | 1,943 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

Configure Replication using alias?

WIN2000 sp4, SQL2000 sp3

I created an alias on the local server for the SQL 2000 server installed
there, I can view and modify most sql server properties using this alias,
but when I attempt to configure the local sql server for replication, as
both a distributor and publisher, I receive the following message - "Error
18483: Could not connect to server 'servername' because 'distributor_admin'
is not defined as a remote login at the server'.

Can you configure a sql server for replication using the alias?

My main issue is that I have 10 sql servers which need to replicate data to
the main server, the 10 servers do not have descriptive names, and would
like to assign descriptive names to servers to make management easier and to
avoid confusion. Each server is behind a NAT enabled router with 1433
pointing to the local address, each server is on a separate local domain.
Several of the server have the same name, although they belong to different

Jul 20 '05 #1
0 2692

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Cherrish Vaidiyan | last post: by
3 posts views Thread by dlesandrini | last post: by
9 posts views Thread by David W. Fenton | last post: by
1 post views Thread by jan.gezels | last post: by
8 posts views Thread by sat | last post: by
4 posts views Thread by Andrew Chalk | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.