SQL2005 change server name issue...

[DLu]

Hi:

Due to certain reason, the SQL2005 Ent installed with name of "ServerA" and later the server is changed name to "ServerB".
Now, it needs to be a publisher for replication.
But SQL2005 needs the same name either serverA or serverB for Repl. In sql2000, I could easily sp_configure 'allow updates', 1 to change the sysserver table. Now in SQL2005, direct access/update is no longer an option.

Thus, I tried to use -m to single user mode to start from:
Startup Parameter: "-dC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf;...."

I change it to "-mC:\......" it failed.
Then I use cmd to the \Bin folder, \sqlservr.exe -m

It brings me to the single user mode but the screen hang there.

Any idea? And even if I get into it, need to use something about hidden resource database, the same sysservers table to update?

thanks
-D

[alzdba]

check out http://www.sqlservercentral.com/foru...ssageid=274929

or

http://msdn2.microsoft.com/en-us/ms143799.aspx

[rmiao]

You shouldn't modify system tables even in sql2k.

[DLu]

Though we had to swap the machine to get the right name sync due to production dead-line, the following 2 proc really helps in the case of solving name un-sync issue without swapping.

EXEC sp_dropserver '<old_name>'
EXEC sp_addserver '<new_name>', 'local'

Thanks for the tip.
-D