469,280 Members | 2,094 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,280 developers. It's quick & easy.

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
domains.

Thanks
Steve
Jul 20 '05 #1
0 2626

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.