Post reply

changed server name caused replication setup issue

  • September 11, 2009 at 7:30 am

    #209852

    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

  • September 11, 2009 at 7:47 am

    #1052270

    I have also verified that this information is not captured in the sql server errorlog.

    -LK

  • September 11, 2009 at 9:36 am

    #1052386

    this is resolved. Thanks

  • August 31, 2010 at 4:16 am

    #1214132

    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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply