Post reply

Unable to configure Logshipping

  • January 8, 2010 at 1:30 am

    #229005

    Error message which I get when I click on 'New Publicaiton'

    TITLE: New Publication Wizard

    ------------------------------

    SQL Server is unable to connect to server 'Z2T3ITRMPLM01'.

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Management+Studio&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantConnect&LinkId=20476

    ------------------------------

    ADDITIONAL INFORMATION:

    SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'Z2T3ITRMLM01'. (Replication.Utilities)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    I ran the below commands to check the name of the server and it gave 2 different names

    select @@servername - output was 'Z2T3ITRMLM01'

    go

    sp_helpserver - Output was 'Z2T3ITRMLM01'

    go

    select serverproperty('servername') - Output was 'Z2T3ITRMPLM01'

    So, if you see the output of the last command it has an extra 'P'.

    Please suggest how to correct this.

    Rgds,
    Pankaj

  • January 11, 2010 at 2:14 pm

    #1102053

    Have you recently renamed the server using the sp_addserver command? If so, did you restart the service after the rename?

    I just had that happen to me with this scenario.

    I used sp_dropserver to drop the old server name, followed by sp_addserver to assign the new server name.

    I was getting similar output to what you are seeing. @@server & sp_helpserver gave me the new servername, but serverproperty('servername') gave me the old server name.

    All I had to do was restart the service. Once the service was restarted, all three (@@server, sp_helpserver, serverproperty('servername')) listed the same name.

Viewing 2 posts - 1 through 1 (of 1 total)

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