Hridaya Thikey (7/28/2009)

---

Found the solution:

Go to SQL Server Configuration Manager of your client computer (In my case one in the corporate network)

Select SQL Native Client Configuration

Select Aliases

Add a new alias:

Alias Name: mydbname\mssqlserver01 (this is remote server and instance name)

Port Number: 1433 (which is default port)

ProtocolL TCP/IP

Alias Server: IP address of the server

Save it. There is no need to restart any thing.

Try now creating subscription and add mydbname\mssqlserver01 as server name. Magic.