Peer to Peer Data Replication
-
Dienstag, 12. Februar 2013 15:41
Hi everyone
I am facing some problem in Peer to peer Data Replication. overall when i connect to MSSQL 2008r2 server remotely its connect fine. when i am right click on Replication folder and choose configure Distribution i got his error..
TITLE: Configure Distribution Wizard
------------------------------
SQL Server is unable to connect to server '100.4.139.321,1433'.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1&EvtSrc=Microsoft.SqlServer.Management.UI.ConfigureWizardErrorSR&EvtID=CantConnect&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
SQL 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, 'OWNEROR-DG7FUA4'. (Replication.Utilities)
------------------------------
BUTTONS:
OK
------------------------------
Alle Antworten
-
Dienstag, 12. Februar 2013 16:47Moderator
Your publication SQL Server Name is not the same as your machine hostname.
Do this query select @@ServerName
and then at the command prompt do this
echo %computerName%
both of these have to be identical.
you can fix this by doing this
EXEC sp_dropserver @@ServerName
GO
EXEC sp_addserver 'OWNEROR-DG7FUA4', 'local'
GOThen you need to stop and start SQL Server Service.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Als Antwort markiert Allen Li - MSFTModerator Freitag, 22. Februar 2013 02:29
.png)
.png)
