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 Thursday, March 10, 2011 7:01 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 6:24 AM
Points: 60, Visits: 375

Assuming you haven't renamed machines (which brought me great pain ! even after sp_dropserver / sp_addserver etc)

I had to enable SQL browser on my SQL express (subscriber) instance, which then mediated nicely so that I could use the <hostname>\sqlexpress target - now this works.

Previously I had a default config of express, which did allow connection via SSMS from the publisher machine to the <hostname> (ie: no \sqlexpress) ...but would throw the '...actual server name to make a connection to the server..' error when I tried to setup replication.
Post #1076214
Posted Thursday, October 17, 2013 5:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 31, 2014 9:34 AM
Points: 2, Visits: 23
Thanks, Mark. This worked after I was able to create a sysadmin login.
Post #1505948
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse