By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,290 Members | 1,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,290 IT Pros & Developers. It's quick & easy.

HOWTO: Installing SQL 6.5 on Windows 2000 Server

P: n/a
You may have a requirement that you cannot change where you have old
apps, such as Delphi 3 apps (in my case), that must hobble along until
the BIG migration money comes into migrate to something better. And
those old apps may require that you keep SQL 6.5 on the backend. In my
case, that's the case, unfortunately. And Microsoft has completely
dried up support for it.

You may find that you can't install SQL 6.5 Enterprise Edition on
Windows 2000 Server -- it may say that it needs to be NT 4 Enterprise
Edition. I did some testing and have come up with the hook around this
problem:

1. Copy the contents of the SQL 6.5 Ent Edition CD to your hard drive.
You're going to need a lot of space.

2. Edit the i386\setup.inf file (once you have made it not read-only)
and find the lines that refer to an if/then statement about "EntOnly"
(note no space before Only). When you find this if/then statement,
comment that block (about 5 lines, if not mistaken) out by putting
semicolons as the first character on each line.

3. Now run the install by doing something like E:\i386\msetup.exe, if
E: is your hard drive where you have installed the files copied from
CD. It will run without complaining about the NT 4.

Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
(go********@hotpop.com) writes:
You may have a requirement that you cannot change where you have old
apps, such as Delphi 3 apps (in my case), that must hobble along until
the BIG migration money comes into migrate to something better. And
those old apps may require that you keep SQL 6.5 on the backend. In my
case, that's the case, unfortunately. And Microsoft has completely
dried up support for it.

You may find that you can't install SQL 6.5 Enterprise Edition on
Windows 2000 Server -- it may say that it needs to be NT 4 Enterprise
Edition. I did some testing and have come up with the hook around this
problem:

1. Copy the contents of the SQL 6.5 Ent Edition CD to your hard drive.
You're going to need a lot of space.

2. Edit the i386\setup.inf file (once you have made it not read-only)
and find the lines that refer to an if/then statement about "EntOnly"
(note no space before Only). When you find this if/then statement,
comment that block (about 5 lines, if not mistaken) out by putting
semicolons as the first character on each line.

3. Now run the install by doing something like E:\i386\msetup.exe, if
E: is your hard drive where you have installed the files copied from
CD. It will run without complaining about the NT 4.


SQL 6.5 SP5a is indeed supported on SQL 2000. Or was, if you like.

I recall that I tried to install it once, but failed. No complaints
about NT4 Server, then again I was Win 2000 Pro. But there was some
problem with tempdb later on in the install. Since it was only for a
nice-to-have reference at home, I abandoned the project. (These days I
have virtual machine on my box with 6.5 on. That runs NT4.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

P: n/a
Erland Sommarskog wrote:
But there was some problem with tempdb later on in the install.


Yeah, we had this problem too after the initial install. We had to do a
Master Repair by rerunning 6.5 setup again and telling it to just do
the Master Repair. We then rebooted and voila, problem solved. We then
service packed it all the way and then ran the dtcsetup.exe patch
(along with some small registry editing for the DTC service) in order
to get it working properly -- see the MS KB on the dtcsetup.exe for
what I'm talking about.

Jul 23 '05 #3

P: n/a
(go********@hotpop.com) writes:
Yeah, we had this problem too after the initial install. We had to do a
Master Repair by rerunning 6.5 setup again and telling it to just do
the Master Repair. We then rebooted and voila, problem solved. We then
service packed it all the way and then ran the dtcsetup.exe patch
(along with some small registry editing for the DTC service) in order
to get it working properly -- see the MS KB on the dtcsetup.exe for
what I'm talking about.


Thanks for the tips! My initial reaction was that I have my SQL 6.5 on a
NT virtual machine, but I have some connections problems to it, so maybe
I should try a virtual SQL 2000 machine instead.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.