[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Install a sql 2000 instance on a sql 2005 server

Posted on 2007-07-24
5
Medium Priority
?
125 Views
Last Modified: 2010-03-19
Install a sql 2000 instance on a sql 2005 server.  I just did an upgrade to sql 2000 to sql 2005 and everything migrated over relatively smoothly.  We just got a new software package that requires sql 2000(the vendor told me after the fact, I even told him I was upgrading).  Can I use the sql 2000 disk to install a named instance on the same server as 2005 without disrupting my sql 2005 server?

Thanks
0
Comment
Question by:mkurtzhals
  • 3
  • 2
5 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 19560448
are you sure you need sql 2000, or would it be enough to keep the database in sql 2000 compatibility level (level=80, sql 2005 -> level=90)?
0
 
LVL 2

Author Comment

by:mkurtzhals
ID: 19565904
So if I create a new database for this sofware package in 2005 and then change the compatibility level it may work?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 19568463
it has, of course, to be tested, but should at least be worth a try.
0
 
LVL 2

Author Comment

by:mkurtzhals
ID: 19568492
I talked to our vendor and this will not work for this application.  Getting back to my original question, can I install a SQL 2000 instance on the SQL 2005 server.

Thanks
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 19568600
yes, you can. just ensure you select an instance name NOT yet installed.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question