Posted by thomas_vicker@standardandpoors.com on 05/09/06 18:56

Hi,

I need to maintain both SQL Server 2000 and 2005 on my PC for support
purposes. I am using the developer additions. After I install
everything (with no install errors) I can use SQL 2005 Mgt Studio fine
until I bring up SQL 2000 Query Analyzer or Enterprise Mgr. After that,
I cannot bring up SQL 2005 Mgt Studio. It get this message:

Package 'Microsoft SQL Management Studio package' failed to load

I click OK, the message comes up again, I click OK again and then Mgt
Studio disappears.

My default instance is under SQL 2000 and I created a named instance
under SQL 2005 on my PC both with Local System Account.

My order of installs was:

1) SQL Server 2000 (Server tools)
2) SQL Server 2000 SP4
3) SQL Server 2005 (DB Engine, Integration Services, and Workstation
components)

I also have .NET 2005 Professional installed.

The frustrating thing is I can find no log information anywhere --
event log, under my Documents and Settings, or in the SQL Server 2005
directories where it was installed.

My guess is that when I used Query Analyzer it changed a setting
somewhere or prevented me from using Mgt Studio somehow, but I just
can't figure out what it did. I'd like to avoid a complete re-install
where it may just happen again.

Any help would be appreciated. Thanks much.

Tom Vicker

• Next in forum: Re: Running SQL and Oracle on the same server
• Prev in forum: JDBC - varchar or nvarchar fields?
• Thread view: SQL Server 2000 and 2005 co-existence problems

[Reply to this message]