Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Unable to create 'New Publication' Expand / Collapse
Posted Friday, January 8, 2010 3:50 AM



Group: General Forum Members
Last Login: Wednesday, November 23, 2011 10:43 AM
Points: 126, Visits: 124
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:


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)



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

select @@servername - output was 'Z2T3ITRMLM01'
sp_helpserver - Output was 'Z2T3ITRMLM01'
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.

Post #844189
Posted Friday, January 8, 2010 4:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 28, 2013 10:20 PM
Points: 45, Visits: 309
Did you get the chance to read the article that talks about changing the server.
Can you please try that and see if that helps.
Post #844205
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse