473,231 Members | 1,581 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

SQL Server 2000 and 2005 co-existence problems

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

May 10 '06 #1
2 3120
I wonder if it would help to install SQL 2005 SP1.

Jim

May 10 '06 #2
th***********@standardandpoors.com (th***********@standardandpoors.com)
writes:
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


Very strange. I have both the SQL 2000 and SQL 2005 tools on my machine,
and they co-exist very well.

I also find it difficult that QA or EM would wreak something havoc for
Mgmt Studio, as QA and EM are native code, and Mgmt Studio is a .Net
application.

I think Jim's suggestion of installing SP1 SQL 2005 is a good idea.
Not because that SP1 may have a fix as such to the problem, but there
is a good chance that it will repair whatever that is broken.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 10 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: Danieltbt05 | last post by:
just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level...
1
by: John | last post by:
Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the...
7
by: Alice Wong | last post by:
I am setting up my Web ASP.net application to connect to Sql server using windows authentication. I set up IIS to have integrated windows authenication and sql to allow Windows authentication....
8
by: nick | last post by:
I have only SQL Server 2005 installed on my PC. And I tried to add the following rows in web.config to use SQL Server 2005 instead of Express: <connectionStrings> <clear /> <add...
5
by: Mitya Mitriev | last post by:
Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine. Then I installed application on production...
14
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can...
2
by: sangu_rao | last post by:
Hi, I have to prepare an ER diagram for the objects in my SQL Server database. I have used the option "DIAGRAMS" in EnterPrise Manager of SQL Server 2000. It is creating the diagram for the...
6
by: John | last post by:
Hi My app is running on a windows 2000 server with isa 2000 installed. How can it access an external sql server (using its ip) from within the isa 2000 firewall/proxy via code? Thanks ...
8
by: John | last post by:
Hi We had an sbs 2003 with isa 2000 server. We wre able to access a remote sql server (hosted at our web host) just fine. We replaced the server with a new sbs 2003 r2 with isa 2004 server and...
4
by: kellygreer1 | last post by:
Sometimes at the end of a project you'll end up with unused Tables, Stored Procs, Functions, and Views. Since there is not something like a 'SELECT' trigger ... what is the best way for telling...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.