Renaming a server with a default SQL Server instance installed
One of the server in my company is going to be renamed. This server has a default SQL Server instance installed on it. After the server is renames and made available, apart from the below steps, what else do I need to check to make sure this is all good? BTW, it only has one database on it apart from the system database. --Change the server name and reboot SQL Server --Connect to the new server name in Query Analyzer and run the following command: sp_dropserver 'old server name' sp_addserver 'new server name', 'local' --Delete the entry in Enterprise Manager for the old server name. Stop and start the SQL Server service to complete the process. Another thing, in case this server had a lot of databases installed and was renamed, how do we get all DB's back. Will the databases still be attached to the old instance which is now not existing ?
Hi, The databases will remain attached to your instance. **sp_dropserver, sp_addserver, restart** should do the trick for you. And then you'll obviously need to change connection strings in your applications. BTW - you mention Enterprise Manager. Does that mean you're running SQL Server 2000? If so, the above will be enough. If you run SQL Server 7.0, I ***think*** you'll also have to run the setup program again.