Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2002-07-02 : 11:02:26
|
| Sanjeev writes "Dear SQL Team,I have changed the computer name from 'Bishal' to 'Sanjeev'and when I try to connect local SQL Server I got the following error message ..."Your SQL Server installation is either corrupt or has been tampered with (unknown package id). Please rerun Setup."So I can't connect my SQL Server. I am in big trouble . Pls help me................Sanjeev" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-02 : 13:44:14
|
http://www.swynk.com/friends/knight/renameserver.asphttp://www.mssqlcity.com/FAQ/Admin/ChangeName.htmfrom books onlinequote: I renamed the computer that runs SQL Server. When I restarted SQL Server, I received an error message warning that my installation was corrupted or had been tampered with. What should I do?If you change the computer name of the server, you will not be able to start SQL Server until you rerun SQL Server Setup. You will be prompted to upgrade, and the necessary SQL Server options will be reset with the new computer name. After you have upgraded, exit the Setup program. Your databases will not be affected by this procedure.
<O> |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-07-02 : 15:41:08
|
| Popular question "Why doesn't MS just TELL us what the error is, or give us the fix in the error message?"Answer, Sometimes we do, and people still ask "What do I do?". It says right there in the error message to rerun setup. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2002-07-03 : 03:59:50
|
| Try the following steps1>Start the enterprise manager2>Right click the SQL server and "delete the sql server registration"4>Right click SQL server group and use "new sql server registration"5>Give the new sql server name (or local) follow the steps . |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-07-03 : 05:22:49
|
| Ravilobo....His machine is his SQL Server... This will not work if you change the name of the server, you have to Re-Run Setup, as it tells you to do....PeaceRick |
 |
|
|
|
|
|