Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL replication requires the actual server name to make a connection Expand / Collapse
Author
Message
Posted Wednesday, February 7, 2007 3:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 1, 2012 2:33 AM
Points: 312, Visits: 179

Hi all

 

We want to replicate our server to a suppliers' server.

Teh error we recieve is : SQL Server replication requires the actual 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 , ''X' (Replication.Utilities)

 

I have added the alias within SQL Server Configuration Manager, SQL Native client configuration, Aliases.

 

Anyone any idea ??




JV
Post #343045
Posted Wednesday, February 7, 2007 3:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 20, 2012 7:21 AM
Points: 143, Visits: 68

Have you thought of adding a name to the host file that will point to the ip address of the server that you are trying to connect to.




Post #343270
Posted Wednesday, February 7, 2007 5:04 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:05 PM
Points: 1,190, Visits: 595

I don't think that is the case...

Try creating the linked server before configuring replication..

 



MohammedU
Microsoft SQL Server MVP
Post #343302
Posted Wednesday, February 7, 2007 11:48 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 15, 2012 3:09 PM
Points: 58, Visits: 104
Check if in your MMS ditsributor/publisher server is registered as local.  If that the case try re-registering it with the server name


Post #343335
Posted Tuesday, October 21, 2008 11:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 19, 2009 7:18 AM
Points: 1, Visits: 31
Try use T-sql script instead of Enterprise Manager to add the subscription.

SQL Server Replication requires the actual server name to make a connection to the server.
Connects through a server alias, IP addres, or any other alternate name are not supported.

If you script a publication, will find sp_addsubscriber at the end of the script.
Post #589356
Posted Saturday, March 7, 2009 11:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 7, 2009 10:58 AM
Points: 1, Visits: 0
I had a similar problem and got around it creating an alias on the publisher machine with the same same name as the subscriber machine. For instance if the subscriber server is called SERVER_A, create an alias with the same name then connect to the subscriber in the New Subscribtion Wizard using this name.
Post #670948
Posted Wednesday, July 29, 2009 1:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 23, 2010 8:38 AM
Points: 11, Visits: 50
If your destination server is named instance e.g. destservername\mssqlserver01, the solution for this can be found at:

http://www.sqlservercentral.com/Forums/Topic759989-291-1.aspx
Post #761311
Posted Wednesday, July 29, 2009 8:08 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:52 PM
Points: 530, Visits: 1,134
Hi,

markwnorsoft solution should work fine. Previously when I had configured replication for the first time over internet I too faced the same problem and adding entry to host file had resolved the problem.


Thanks
Chandra Mohan
Post #761588
Posted Wednesday, July 29, 2009 8:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 23, 2010 8:38 AM
Points: 11, Visits: 50
Yes, adding server on hosts works fine but only for the default instance.

For the databases on the named instance you must set and use the alias.
Post #761618
Posted Thursday, August 13, 2009 12:11 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 5, 2013 12:31 PM
Points: 82, Visits: 567
This link explains in detail how it can be done both for named as well as default instance.

http://social.msdn.microsoft.com/forums/en-US/sqlreplication/thread/9a8cf6b1-a449-4748-b3c2-1c13e2bfcc5b/
Post #770397
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse