sql server replication: Error Creating a New Publication -- sql server replication

RE: Error Creating a New Publication

Lance
2/4/2006 6:43:20 AM

sql server replication: gopal,
Also, the server was renamed to SPI-SVR6. It looks like it may still have
the old server name stored somewhere. Any ideas where I may look?

[quoted text, click to view]

RE: Error Creating a New Publication

gopal
2/4/2006 7:30:03 AM

you need to run sp_dropserver and sp_addserver and then recycle SQL Server
for the change to take effect,

sp_dropserver 'old server name'
sp_addserver 'new name', 'local'

BOL has more info on these procs

[quoted text, click to view]

RE: Error Creating a New Publication

gopal
2/4/2006 8:57:43 AM

Yes please see this link for the actual steps
http://msdn2.microsoft.com/en-us/library/ms143799.aspx

[quoted text, click to view]

RE: Error Creating a New Publication

Lance
2/4/2006 10:01:18 AM

gopal,
Thanks for the help. How do i identify the isa registration info?

[quoted text, click to view]

RE: Error Creating a New Publication

gopal
2/4/2006 10:01:40 AM

Make sure the name with which the server isa registered is the same as the
local server
name. It looks like your server is registered using 'spi-svr6'. Alias is not
supported when
configuring replication

[quoted text, click to view]

Error Creating a New Publication

Lance
2/4/2006 10:10:25 AM

When Attempting to set up replication on my SQL server 2005 server, I right
click and select new publication and imediately get the following error
message:

SQL Server is unable to connect to server 'spi-svr6'. (New Publication Wizard)

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

===================================

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,
'SPI-SVR203'. (Replication.Utilities)

------------------------------
Program Location:

at
Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.CheckServerAlias(ServerConnection conn)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.Open()
at
Microsoft.SqlServer.Management.UI.CreatePublicationWizard.PrepareToShow()

The help link provides nothing on this and I have been unable to locate any
info on other user sites. I am at a loss on what the communication problem
may be as the replication wizzard does not even begin.

RE: Error Creating a New Publication

gopal
2/4/2006 10:25:06 AM

[quoted text, click to view]

RE: Error Creating a New Publication

gopal
2/4/2006 10:41:42 AM

If you look at management studio and check the name of the server at the top
of the tree
that is the name under which the server is registered...

Also do a sp_helpserver query to determine the name corresponding to id 0
the registered name should be the same as that for id 0 (which normally is the
name of the server where SQL is installed.

[quoted text, click to view]

RE: Error Creating a New Publication

Lance
2/4/2006 11:59:09 AM

Thanks for great help gopal!

[quoted text, click to view]

RE: Error Creating a New Publication

Lance
2/4/2006 12:08:34 PM

gopal,
You are right on target. The helpserver SP returns the old server name.
Will the drop/add sp's fix this?

[quoted text, click to view]

Re: Error Creating a New Publication

Paul Ibison
2/6/2006 12:00:00 AM

You can use the @@SERVERNAME global variable or the
SERVERPROPERTY('ServerName') function in SQL Server to find the network name
of the computer running SQL Server. The ServerName property of the
SERVERPROPERTY function automatically reports the change in the network name
of the computer when you restart the computer and the SQL Server service.
The @@SERVERNAME global variable retains the original SQL Server computer
name until the SQL Server name is manually reset.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.