DelphiFAQ Home Search:

Renaming a machine running Microsoft SQL Server?

 

comments6 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'
GO

EXEC sp_addserver 'Your_NEW_Computer_Name', 'local'
GO

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

SELECT @@SERVERNAME
GO

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

Comments:

2006-08-17, 08:45:18
anonymous from United States  
rating
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  
rating
Work fine! (on MSSQL 2005) !
2015-01-30, 01:50:37
anonymous  
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
2015-01-30, 11:07:47
anonymous  
we like to honor a lot of other world-wide-web web-sites around the web, even if they aren?t <a href=' http://zlwpupp.com'..</a> to us, by linking to them. Under are some webpages worth checking out
2015-01-30, 11:07:57
anonymous  
we like to honor a lot of other world-wide-web web-sites around the web, even if they aren?t <a href=' http://zlwpupp.com'..</a> to us, by linking to them. Under are some webpages worth checking out
2015-01-30, 14:32:46
anonymous from United Arab Emirates  
The Ships's Voyages I feel technological know-how just csaues it to be even worse. Now there is a channel to never ever care, now there wouldn't be considered a likelihood for them to find . http://domuqu.com [url= http://crocpvxq.com..pvxq[/url] [link= http://dsjcjuinmh.c..nmh[/link]

 

 

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: