Rename a SQL Server

• Rushdi Basir

  Mr or Mrs. 500

  Points: 593

  More actions

  October 2, 2004 at 12:50 pm

  #86431

  Hi,

  We renamed our NT4.0 (SP6a) server in which SQL Server 2000 is residing (sp3).

  The SQL Server recognized the new name immediately but it was recognizing the old name also.

  We ran the following command in the QA:

  sp_dropserver 'old server name'

  sp_addserver 'new server name', 'local'

  Still old and new registration to the server exists.

  We are having replication issues (transactional replication) where the record modifications are not synchronized from subscriber to the publisher (subscriber is the renamed server)

  Thanks in advance,

  Rushdi

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  October 2, 2004 at 1:31 pm

  #525121

  Check DNS would be my first thing to say.