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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:93919DD0-5A3E-4018-9D25-41883944366D@xxxxxxxxxxxxxxxx
> 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


.

Relevant Pages

  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I just promoted the remote DC last week, so I still have time to solve the replication issues. ... Domain Controller Diagnosis ... Connecting to directory service on server alpha. ... Performing upstream analysis. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... alpha server as soon as you can to get things going. ... A simple DNS replication test is to create a host record in the SBS server ... Domain Controller Diagnosis ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I did make the changes that you suggested on the DNS of my alpha server and rebooted. ... I did run the simple DNS test that you suggested by adding a host record to my SBS server. ... A simple DNS replication test is to create a host record in the SBS server and wait till it shows up in the remote server. ...
    (microsoft.public.windows.server.sbs)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)