Sqlserver Replication Requires Actual Server Name

Question

Post reply

Sqlserver Replication Requires Actual Server Name

jolan.mahinay

Ten Centuries

Points: 1111
More actions
May 6, 2012 at 9:59 pm

#273582

hello to all,
i would like to ask help from this error i've encountered " SQLSERVER REPLICATION REQUIRES ACTUAL SERVER NAME TO MAKE CONNECTION TO THE SERVER." this was happen when i tried to create a subscriber, my subscriber was in the cloud server that is why i'm using the the IP address to connect to that server but i've got that error..but when i've tried to connect that IP address using my management studio 2008 R2 its successfully connected..is there any solution on this problem? hope to hear you guys asap..
thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

Replication definitely does not like IP addresses. Not sure what you need to a cloud based server

jolan.mahinay Ten Centuries Points: 1111 More actions · Answer 2

thanks for the reply actually the subscriber was in the cloud so i need that server to be added to my server publication..any idea

thanks

Colleen M. Morrow SSCrazy Points: 2457 More actions · Answer 3

You're going to have to use the cloud server's name when you specify the subscriber. If necessary, use Configuration Manager to create an alias on your publisher using the subscriber's hostname as the alias name and the IP address as the Server.

Colleen

Colleen M. Morrow
Cleveland DBA

jolan.mahinay Ten Centuries Points: 1111 More actions · Answer 4

hi collen thanks for the info. actually i created an alias on the cloud sqlserver as my subscriber, here's what i have done to create on the sqlserver config. manager..on the SQL NATIVE CLIENT10.0 CONFIGURATION(32BIT) i created new aliases with the name mysql2008r2 and the server is the IP address and the protocol is tcp then click ok, then i tried to connect to through my pc and the error is cannot connect to mysql2008r2 a network related or instance-specific error occured while establishing a connection to Sqlserver the server was not found or was not accessible..is there any missing piece during this set up on aliases please help..

thanks

Colleen M. Morrow SSCrazy Points: 2457 More actions · Answer 5

You're on the right track, but you're not quite there yet. You're correct about using the IP address as the alias's server and using TCP for the protocol.

Your subscriber has a hostname, right? Create an alias with that name on your publisher. Again, the server should be your subscriber's IP and the protocol should be TCP. This should do 2 things: it will allow your publisher to reference the subscriber using its hostname (rather than IP address), which is what replication requires; it will also tell SQL Server how to resolve that hostname to a physical server.

The keys are:

1. the alias needs to exist on the Publisher, not on the subscriber. (You can also create the same alias on your desktop to test connectivity there.)

2. the alias needs to have the same name as the subscriber's hostname. SQL Server will verify this at the subscriber.

Colleen M. Morrow
Cleveland DBA

jolan.mahinay Ten Centuries Points: 1111 More actions · Answer 6

thanks sir collen it works, but again when i check my status on the view snapshot agent status and the error message give is:

Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER2008\MSSQL\ReplData\unc\JOLANMAHINAY$SQLSERVER2008_MYOH_POS_CLOUDPUBLICATION\20120510145055\' is denied.

how can i configured to have an access or read and write access to this path?..please help i'm stock with this error..

thanks

Colleen M. Morrow SSCrazy Points: 2457 More actions · Answer 7

Does the account the snapshot agent is running under have full rights to this directory?

Colleen M. Morrow
Cleveland DBA