changed server name caused replication setup issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » changed server name caused replication setup...

changed server name caused replication setup issue

Rate Topic

Display Mode

Topic Options

Author

Message

luckysql.kinda

Posted Friday, September 11, 2009 7:30 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 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

luckysql.kinda

Posted Friday, September 11, 2009 7:47 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 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

luckysql.kinda

Posted Friday, September 11, 2009 9:36 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 10:41 PM
Points: 310, Visits: 649

this is resolved. Thanks

Post #786499

kjplreddy

Posted Tuesday, August 31, 2010 4:16 AM

Grasshopper

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 »

Permissions