March 18, 2004 at 8:52 am
I am new to this forum, so I apologize in advance if this is not the place to post this.
I have a client that has inadvertently installed an application that uses MSDE 2000 onto a server that acts as a SQL 7 server. When we attempt to start SQL 7, we get an error message referring to a corruption in SQLBOOT.DLL and the application fails.
Has anyone dealt with this sort of problem before and is it recoverable. We have tape backups of the SQL 7 tables and can do a restore to a new installation, but I would prefer to not have to do this, so any ideas are welcome.
Jim Isbell
Director, Information Services
NorthStar EMS
March 22, 2004 at 8:00 am
This was removed by the editor as SPAM
March 22, 2004 at 10:31 am
I don't know if the following is a possibility or not.
Could it be that SQL Server 7 was installed on the server as the default instance.
Maybe MSDE is expecting to run as the default instance.
Short answer - maybe there is effectively an install conflict?
GaryA
March 22, 2004 at 7:13 pm
You are correct that both installations are acting as though they are the default instance. The problem is that the 2000 instance has corrupted the 7 instance and is now inoperable.
I expect that this will turn into a PSS call, but we have at least two vendors that need to answer some questions before we get to that point.
Thanks for the help,
Jim
March 22, 2004 at 11:55 pm
Do you need to keep running both MSDE and SQL 7 on same box ? As per BOL,
You cannot version switch between an installation of SQL Server version 7.0 and a default instance of SQL Server 2000.
You can have any number of named instances of SQL Server 2000 in addition to the default instance. You are not required to run a default instance on a computer before you can run named instances. You can run named instances on a computer that has no default instance. SQL Server version 6.5 and SQL Server 7.0 cannot operate as named instances, only as default instances.
Or
Can you uninstall MSDE and revert back to SQL 7.0 ?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply