Keep getting error when trying to set up publicati

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Keep getting error when trying to set up publicati

Author

Topic

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-05-05 : 06:26:31

Keep getting error when trying to set up publication:

TITLE: New Publication Wizard
------------------------------

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Management+Studio&ProdVer=9.00.4053.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, 'JAY-TOSH'. (Replication.Utilities)

------------------------------
BUTTONS:

OK
------------------------------

Its asking for 'JAY-TOSH' which was my computer name before i changed it to jay (which i did about 5 months ago).

I dont understand why its asking for the old name.(which i did try but then it doesent connect (because it dont exist no more)).

What should i do?... Thanks

apodemus
Starting Member

30 Posts

Posted - 2010-05-05 : 06:49:44

Hi,
you have to change you SQL Server name always, when you change system server name. You can do this using procedures below :

EXEC sp_dropserver 'old_name'
GO

EXEC sp_addserver 'new_name', 'local'
GO

Old server name you can find by select * from sys.servers

apodemus

apodemus
Starting Member

30 Posts

Posted - 2010-05-05 : 06:51:02

quote:
Originally posted by apodemus

Hi,
you have to change you SQL Server name always, when you change system server name. You can do this using procedures below :

EXEC sp_dropserver 'old_name'
GO

EXEC sp_addserver 'new_name', 'local'
GO

Old server name you can find by select * from sys.servers

apodemus

....and of course you have to restart SQL Server after that :)

apodemus

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-05-05 : 06:59:32

Thanks, Exactly what i needed... :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources