Installed sql server 2005, then changed servername

• natedawgs

  SSC Rookie

  Points: 35

  More actions

  September 22, 2008 at 1:49 pm

  #213001

  Hi,

  I changed the name of my server after sql2005 was installed, now replication will not work and ideas? if gives me an error staying (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 alternative name ar not supported.

• GMan-447962

  Mr or Mrs. 500

  Points: 509

  More actions

  September 22, 2008 at 4:09 pm

  #875311

  If you enter:

  select *

  from master.sys.sysservers

  where srvname = 'repl_distributor'

  ...does it reference the correct server's name or the old server's name?