changed server name caused replication setup issue

  • 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

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

    -LK

  • this is resolved. Thanks

  • 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