DelphiFAQ Home Search:
Databases
    InterBase (28)
    MS-SQL (5)
    mysql (35)
    Oracle (1)

 
Exchange Links
 
About this site

Links to us


Tell a friend
Friend's name
Friend's email
My name
My email
Short note
 
Bookmark this
Add to del.icio.us Digg! Add to Reddit Add to Yahoo MyWeb Add to Windows Live Add to Google Bookmarks Share via Facebook

Renaming a machine running Microsoft SQL Server?

 

comments1 comments. Current rating: 5 stars (1 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.


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

 

 

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.
 
It seems that you are
from Washington, US .

Info/ Feedback on this

Show city and country
Show country only
Hide my location
Leave your comment here:
Please type in the code:
photo Add a picture:

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.