Can't use replication after renaming server. Please help!

Hello all,
I have a server that was named "AlienDB" running SQL Server. I renamed the
server to "StagingAlienDB1" and now I am having problems configuring
replication.
When I try to do anything such as create a new Publication, SQL Server
immediately shows me a message box containing the following:
"SQL Server is unable to connect to the server 'StagingAlienDB1'.
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, 'ALIENDDB'. (Replication.Utilities)"
I tried looking for a way to perhaps change an old reference from ALIENDB to
StagingAlienDB1 but I couldnt find anything. What can I do?
Johnny
Try to disable replication, un register the server, re-register it with its
new name, recreate replication and then rebuild your publications and
subscriptions.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:93919DD0-5A3E-4018-9D25-41883944366D@.microsoft.com...
> Hello all,
> I have a server that was named "AlienDB" running SQL Server. I renamed the
> server to "StagingAlienDB1" and now I am having problems configuring
> replication.
> When I try to do anything such as create a new Publication, SQL Server
> immediately shows me a message box containing the following:
> "SQL Server is unable to connect to the server 'StagingAlienDB1'.
> 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, 'ALIENDDB'. (Replication.Utilities)"
> I tried looking for a way to perhaps change an old reference from ALIENDB
to
> StagingAlienDB1 but I couldnt find anything. What can I do?
> Johnny
|||If you are using sql 2000 try this. I'm not sure if it works for 7.0.
Run Select @.@.Servername
if this name is not the actual name of the server use the following to
fix:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
|||Thanks. This worked!
"seanbell68@.gmail.com" wrote:

> If you are using sql 2000 try this. I'm not sure if it works for 7.0.
> Run Select @.@.Servername
> if this name is not the actual name of the server use the following to
> fix:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
>
|||Have just tried this to resolve the same problem on SQL 2005 and it worked
perfectly. Thanks!
USE MASTER
GO
SP_DROPSERVER 'OLDNAME'
GO
USE MASTER
GO
SP_ADDSERVER 'NEWNAME', 'LOCAL'
GO
url:http://www.ureader.com/msg/11561162.aspx