Unix Technical Forum

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

This is a discussion on SQL Server 2005: Unable to add SQL2000 subscriptor using non-standard port! within the SQL Server forums, part of the Microsoft SQL Server category; --> I am trying to add a SQL2000 subscriptor to a SQL2005 publisher and distributor using the Management Studio. I'm ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-01-2008, 12:16 PM
basuritta
 
Posts: n/a
Default 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!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:04 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com