DelphiFAQ Home Search:

Renaming a machine running Microsoft SQL Server?


comments3 comments. Current rating: 5 stars (2 votes). Leave comments and/ or rate it.

If you are running SQL Server 7.0, after renaming the SQL Server machine, the SQL Server service will fail to start, with an error message

"Your installation was corrupted or had been tampered with"
To get around this problem, you have to rerun the SQL Server setup. Setup will prompt you to upgrade. After doing so, the necessary SQL Server registry entries will be reset with the new computer name. Now you will be able to start SQL Server. After restarting, use Query Analyzer to run the following commands:

EXEC sp_dropserver 'Your_OLD_Computer_Name'

EXEC sp_addserver 'Your_NEW_Computer_Name', 'local'

Restart your SQL Server service. Connect using Query Analyzer and run the following command (It should output the new server name):


If you are running SQL Server 2000, the new name is recognized, the next time SQL Server service starts. You don't have to rerun the setup. However, you have to run the sp_dropserver and sp_addserver stored procedure as shown above.

Content-type: text/html


2006-08-17, 08:45:18
anonymous from United States  
This has been of a great help to me. I was really desperate to find a solution for changing the host name. Thank you very much
2008-08-15, 07:57:41
anonymous from Switzerland  
Work fine! (on MSSQL 2005) !
2015-01-30, 01:50:37
Wonderful story, reckoned we could cbmione a couple of unrelated data, nevertheless genuinely worth taking a search, whoa did one particular understand about Mid East has got much more problerms as well



NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: