If you run SQL Server 2005, the new name is recognized during the SQL service startup. There is no need to run Setup again or to reset the server name.
If there are any remote logins to the SQL Server, sp_dropserver may generate an error. To resolve the error, you may need to drop remote logins and rerun the procedure.
Note: In order to see the new SQL server in the Enterprise Manager, you need to delete an old server registration, and register the new name.
|
Copyright © 2015 Arcserve.
All rights reserved.
|
|