Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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: 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
Post #844189
Posted Friday, January 08, 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 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.
Post #844205
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse