Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

asked on

How to install SQL 2000 in a Windows Server 2008

How to install SQL 2000 in a Windows Server 2008?

We need to run a series of application in a Widows 2008 server.  the site has MS SQL 2000 with latest service pack.  When installing, it gave a series of error.

ASKER CERTIFIED SOLUTION
Avatar of sporgg
sporgg
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Please explain the second option with more detail.
Avatar of Racim BOUDJAKDJI
Do you have to do that?  Keep in mind that you *can* run SQL2000 compatible databases on SQL2008 engine...
HTH
Avatar of jana

ASKER

Hi Racimo...we know we can run SQL2000 DBs on SQL2008 engine.  The problem is that the site has SQL2000 license and they didn't budget a purchase of SQL licenses when buying 2008 server.  So we are trying to go around this problem temporary.

Is there a way to around thi?
<<The problem is that the site has SQL2000 license and they didn't budget a purchase of SQL licenses when buying 2008 server.>>
I am sorry but I am afraid there is no temporary solution or magical trick to the problem you are describing.

If I understand this is a *non technical* problem.  I would say that attempting to find a way around that may expose you to further incompatibility and unstability problems. I'd rather suggest finding a *non technical* answer (such as asking the smart budget planner why he forgot to include the cost of a SQL license).
Avatar of jana

ASKER

...they were just not advised.

Hi Ramante

The hyper-v option technicaly may sole your problem but you would need more licenses to do it. Best bet is to sort out the licensing issues.
<<...they were just not advised.>>
Hey this kind of thing happen all the time (I mean a forgotten license to be bought)...what's the big deal?..It is not like you are asking for a personal license...
Avatar of jana

ASKER

that is true...happens every time.  Unfortunately we're not talking about one user, its over 15; so they made a big mistake in not getting proper advice and now have to face the consequences.

Nevertherless, the conclusion here is that there is no way to work around this problem and the only option is to purchase SQL 2008.  Would that be correct?
<<Would that be correct?>>
Yep.
Avatar of jana

ASKER

Ok wait....I just reread this page and may help us out temporarly.  The option of virtual machine.  Have you guys done something like this with SQL?

Thanx
<<The option of virtual machine.  Have you guys done something like this with SQL?>>
Yep.  I'd have proposed it if I thought it'd have helped you.  IN short...

Ccost of license for virtualization software + cost of maintainance + cost of unreliability running SQL on virtual platform > Cost of SQL Licence

Avatar of jana

ASKER

But the client has already the 15+ licenses for SQL 2000.  

If VM is viable, what do you think about Micsoroft VM?

I see that you have installed SQL in VM and used it, how was your experience in performance, etc.

To give you a bit of environment, the DB will be running is for 15+ people that only do querying and 3 people doing data entry (and thats done 3 time a week).

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Hi Racimo...it's not that I want to learn the hard way; we're against the clock and wanted real-life experience in this matter.  We'll proceed recommendation for SQL upgrade purchase licenes, etc.  Nevertheless, thanx to all.

Avatar of jana

ASKER

Thanx