Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dilip.aim11
Starting Member
4 Posts |
 Posted - 2012-04-12 : 03:59:51
|
| hi,i am using replication between to sql server in my lan..and its working fine...But when i try that my local sql server work as Publicationand my live sql server work as Subscriptionso when i am creating new subscription i am getting this errorSQL 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, 'WDB1004'. (Replication.Utilities)Please Help Me To solve this Problem..dilip |
|
|
xDil
Starting Member
2 Posts |
Posted - 2012-04-12 : 05:29:02
|
| You need to specify ServerName while making the connection to the server in you SQL client. .. You must have specified the IP. In case the server is not in your local network, you need to add an alias in SQL Configuration Manager. Add a new alias .. provide the IP and servername of the external server. You can test the alias by connecting the the external server thru ur sql client.Adil Azeez |
 |
|
|
|
|
|
make remote sql server as subscription