I found this on Microsoft support site: http://support.microsoft.com/kb/195759
Q. When I try to start SQL Server 7.0 on Windows NT or from a Windows 9x Command prompt, I receive the following error:
Your SQL Server installation is either corrupt or had been tampered with (unknown package id) Please rerun setup.
When I attempt to start SQL Server 7.0 on Windows 9x using the SQL Server Service Manager, nothing happens. What causes this and how can I resolve it?
A. This error message appears if you have renamed the Windows computer on which you installed SQL Server 7.0. SQL Server 7.0 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 7.0 Setup from the original product CD. Doing so will not reinstall SQL Server or any components; however, it will update SQL Server 7.0 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
If SQL Server is configured to listen on either the Multiprotocol or NWLink IPX/SPX network libraries, you'll need to remove them, and then add them back using the SQL Server Network Utility. • Change the Windows computer name back to the original name it had when you first installed SQL Server 7.0
Thank you so much for your reply. The server was on this computer when I bought it, installed by dell. I haven't renamed the windows computer. I tried to find it on the CDs that came with my computer but couldn't. Any other ideas?
Thank you so much for trying to help me. Just spent lots of money and time with dell rep. controlling my computer to fix it. Very Complicated. Again, thank you for trying.
vhall
319 Posts
0
March 29th, 2008 12:00
I found this on Microsoft support site: http://support.microsoft.com/kb/195759
Q. When I try to start SQL Server 7.0 on Windows NT or from a Windows 9x Command prompt, I receive the following error:
When I attempt to start SQL Server 7.0 on Windows 9x using the SQL Server Service Manager, nothing happens. What causes this and how can I resolve it?
• Run SQL Server 7.0 Setup from the original product CD. Doing so will not reinstall SQL Server or any components; however, it will update SQL Server 7.0 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:A. This error message appears if you have renamed the Windows computer on which you installed SQL Server 7.0. SQL Server 7.0 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:
If SQL Server is configured to listen on either the Multiprotocol or NWLink IPX/SPX network libraries, you'll need to remove them, and then add them back using the SQL Server Network Utility. • Change the Windows computer name back to the original name it had when you first installed SQL Server 7.0
ravenjada
17 Posts
0
March 29th, 2008 13:00
Thank you so much for your reply. The server was on this computer when I bought it, installed by dell. I haven't renamed the windows computer. I tried to find it on the CDs that came with my computer but couldn't. Any other ideas?
vhall
319 Posts
0
March 29th, 2008 16:00
I wish I could help more but I have no server knowledge.Perhaps post on the
server forum.
Check this on another forum: http://www.pcreview.co.uk/forums/thread-674169.php
ravenjada
17 Posts
0
March 29th, 2008 17:00
Thank you so much for trying to help me. Just spent lots of money and time with dell rep. controlling my computer to fix it. Very Complicated. Again, thank you for trying.