Unable to create 'New Publication'

• pankaj.baluni

  Ten Centuries

  Points: 1014

  More actions

  January 8, 2010 at 3:50 am

  #215468

  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

• AJ@SQL

  SSC Eights!

  Points: 811

  More actions

  January 8, 2010 at 4:42 am

  #1100784

  Did you get the chance to read the article http://msdn.microsoft.com/en-us/library/ms143799.aspx that talks about changing the server.

  Can you please try that and see if that helps.