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

changed server name caused replication setup issue Expand / Collapse
Author
Message
Posted Friday, September 11, 2009 7:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 23, 2013 10:41 PM
Points: 310, Visits: 649
Some days back I changed my server name. Now when I try to create the new publication then I get following error information:

"Sql server replition requires the actual server name to make a connection to the server. Connections through a server alias. IP address, or any other altername name are not supported. Specify actual server name. "

But the issue is that I am passing correct sql server name only. The correct sql server name is found from
SELECT SERVERPROPERTY('SERVERNAME')

I have also verified the server name as follows:

1. select * from sys.servers
2. sp_helpserver
3. Checked computer name in start-->right click 'MY COMPUTER'-->Properties and then computer name.

-lk
Post #786350
Posted Friday, September 11, 2009 7:47 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 23, 2013 10:41 PM
Points: 310, Visits: 649
I have also verified that this information is not captured in the sql server errorlog.

-LK
Post #786366
Posted Friday, September 11, 2009 9:36 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 23, 2013 10:41 PM
Points: 310, Visits: 649
this is resolved. Thanks
Post #786499
Posted Tuesday, August 31, 2010 4:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 07, 2011 8:37 AM
Points: 10, Visits: 64
hi

this is jayapal

could u plz tell me how u resolve u r server name prob ?


i got the same issue

thanks in advance
Post #977814
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse