-
SQL2005 change server name issue...
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
-
-
You shouldn't modify system tables even in sql2k.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|