468,290 Members | 1,964 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

SQL Server 2005: Unable to add SQL2000 subscriptor using non-standard port!

I am trying to add a SQL2000 subscriptor to a SQL2005 publisher and
distributor using the Management Studio.

I'm using a non-standard port in both ends, but I have set the port
for the TCP/IP protocol to the non-standard port in both the server
and client network configuration.

I can add the SQL2000 server to the Management Studio console without
problems, and even without haveing to specify the port I'm using (as
expected)

But when I try to add the SQL2000 server as a subscriptor I get an
error of "Unable to connect to server".

I have use external tools to check the network traffic between both
servers and I see that the SQL2005 server is trying to connect to the
SQL2000 server using the standard port (1433), not the one I put in
the network configurator.
Moreover, if I use the naming convention of "SERVERNAME, Port" in the
server name field when doing this, I get an error saying the only the
servername is expected. No aliases or IP addresses.

SQL Server 2000 is SP4 and running in Win 2000 Server SP4
SQL Server 2005 is SP1 and running in Win 2003 Server R2 SP1

Is this a known bug? How can I solve this problem? Why the management
studio is using the standard port for this? Any suggestion/idea out
there?

Thanks in advance for your help!

Feb 7 '07 #1
0 1544

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Daniel Walzenbach | last post: by
4 posts views Thread by Ludovic Lemarinel | last post: by
2 posts views Thread by =?Utf-8?B?SmVmZnJleQ==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.