May 24, 2008 at 7:08 am
This is probably a very basic question and hopefully very easy to fix once I am advised how to do it! I am getting a message as windows XP starts up saying" SQL Server corrupt or tampered with ( unknown package id) rerun setup" How might I do that?
thanks , Trevor
May 24, 2008 at 7:28 am
This error message appears if you have renamed the Windows computer on which you installed SQL Server. SQL Server uses the Windows computer name internally; if you change the Windows computer name, SQL Server detects a different name and generates the error message.
NOTE: Your data has not been corrupted or damaged in any way.
To resolve this error and start SQL Server again, do either of the following:
• Run SQL Server Setup from the original product CD. Doing so will not reinstall SQL Server or any components; however, it will update SQL Server internally to reflect the new Windows computer name. You also need to update SQL Server's internal servername by running the following two stored procedures:
sp_dropserver
go
sp_addserver , local
go
• Change the Windows computer name back to the original name it had when you first installed SQL Server.
Courtesy Microsoft 🙂
May 25, 2008 at 4:47 am
Many thanks for your response and two methods of solving the problem.
However I am beaten on both counts.
Firstly, despite several attempts of changing back to the original computer name I do not seem to remember the actual name used.
The second option of using the original CD is flawed in that the computer is saying that my current XP version is newer than the one on CD and it will not let me rerun setup. I am assuming this is because of the major updates to SP2 some time ago.
Can you help further?
Regards,
Trevor
May 25, 2008 at 9:31 am
The third solution is to format the m/c (O/S drive only) and reinstall the OS. In this case you have to re-install SQL Server. Where is your databases? Are they on the same drive or separate drive? If it is separate then I believe you can retrieve all your data.
If formatting is not possible then I also have to check for other solution which at this point is not comming in my head. 🙂
May 25, 2008 at 10:17 am
Unfortunately I have only one drive. Is it possible to obtain a cd with windows XP plus SP2 loaded on it or download it so i could use it to repair the problem?
thanks for all your help,
trevor
May 25, 2008 at 10:02 pm
SP2 can be downloaded free from microsoft site......
May 26, 2008 at 3:51 am
Forgive my lack of knowlege but is SP2 a complete updated version of XP? I always thought it was an 'add on' to XP.
If it is a complete OS then I assume I can download it to CD and use it to reload the SQL server?
Trevor
May 26, 2008 at 7:02 am
It is an addon. U can download only SP2, which is required to install after installation of XP. Your XP CD is valid.
May 27, 2008 at 11:33 am
tjt649 (5/25/2008)
Many thanks for your response and two methods of solving the problem.However I am beaten on both counts.
Firstly, despite several attempts of changing back to the original computer name I do not seem to remember the actual name used.
The second option of using the original CD is flawed in that the computer is saying that my current XP version is newer than the one on CD and it will not let me rerun setup. I am assuming this is because of the major updates to SP2 some time ago.
Can you help further?
Regards,
Trevor
WRONG CD! You are running setup for the Windows XP installation. The setup mentioned here is the setup on the SQL Server CD!
Stop now before you corrupt your system.
May 28, 2008 at 12:59 am
Thanks for that info. however I do not have a SQL server CD. I assumed the SQL server was included in the XP disc. What I have done so far is to remove SP2 and run the repair facility of the XP disc. The error message still remains! Could the SQL server CD possibly be included with the utilities disc supplied originally from Dell?
Thanks
Trevor
May 28, 2008 at 4:46 am
At this point, I suspect that you have already corrupted your system. Removal of the SP2 was probably not a good idea.
You can download the SS Express Edition from their web site, and that should get you what you need, but no SS is not something that ships XP. It is a server product, and a lot more expensive than XP.
June 4, 2008 at 10:04 am
\c$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
if the directories are still there go into the log directory and open a log
in the top of the log is will have the name of computer
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply