SQL Server named instance change port for publish subscription

Original: SQL Server named instance change port for publish subscription

Two database servers, none joined the domain, all installed multiple instances, the port is not the same. Now using a named instance for replication, tossing a long time, only to find a solution.


Server A:myservera
MSSQL named instance: Mymssql
MSSQL Port: 14433

Server B:myserverb
MSSQL named instance: Mymssql
MSSQL Port: 14433

Normal Connection Database method: myservera\mymssql,14433

However, when you create a publication subscription, you cannot connect to both database errors!

Try some of the methods are unsuccessful:

Bind IP and computer;

Change the port to the default 1433;

Create an instance alias for the computer name;

(Other minor changes .....) ）

Final Workaround:

Create a database alias in Configuration Manager! Requirements are as follows:

1, create the other's database alias in the current server;

2, the database alias needs to add the instance name, such as Myserverb\mymssql;

3, when creating a publication subscription, connect to SSMS as the server name \ instance name ;

For example, creating a database alias on the myservera server, similarly creating an alias on the myserverb server.

SQL Server named instance change port for publish subscription