1

I have this setup:

  • A publisher SQL Server Standard 2014 instance named GMSSERVER\SQLSTANDARD on Server A

  • A subscriber SQL Server 2014 Express instance named CLAUDIOGMS\SQLEXPRESS2014 on Server B

When I try to add a new subscription from CLAUDIOGMS\SQLEXPRESS2014 I have a problem. I try to connect to server A using Server name GMSSERVER but I got the following error:

Cannot connect to GMSSERVER.

SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, 'GMSSERVER\SQLSTANDARD'.
(Replication.Utilities)

Program Location:
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.CheckServerAlias(ServerConnection conn)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.ValidateConnection (UIConnectionInfo connInfo, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

If I try to connect using server name GMSSERVER\SQLSTANDARD instead, then I got a network related error.

The strange thing for me is that I can connect to GMSSERVER\SQLSTANDARD from server B using Server name GMSSERVER with no problems in SQL Server Management Studio but not in the subscription wizard

Improve this question
4
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.