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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Connection problem

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.asp
http://www.mssqlcity.com/FAQ/Admin/ChangeName.htm

from books online
quote:

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>
Go to Top of Page

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.

Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2002-07-03 : 03:59:50
Try the following steps
1>Start the enterprise manager
2>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 .

Go to Top of Page

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....

Peace

Rick

Go to Top of Page
   

- Advertisement -