I was hoping this “feature” would have been change with SQL Server 2008 but it’s not. When using any of the Management Studio wizards I get a message box with the following error:
SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'XXXXXXXXXXXX\XXXXXXXXXXXX'. (Replication.Utilities).
This only occurs when connecting using the tools installed on my workstation. When using the tools on the server the problem doesn’t occur.
Problem background, when I connect from my workstation, I must manually provide the TCP/IP port. We don’t use the default port of 1433 and we also disable the SQL Browsers service since we don’t want SQL to respond to “noise” neighbors. Thus when I connect to SQL from my workstation I must either create a server alias or provide the port. Something in the tool doesn’t like this. Please correct the problem as it make both setting up replication and replication monitoring very difficult.