473,836 Members | 2,210 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

HOWTO: Installing SQL 6.5 on Windows 2000 Server

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
3 4151
(go********@hot pop.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****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
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
(go********@hot pop.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****@sommarsk og.se

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

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

Similar topics

4
3856
by: Logan | last post by:
Several people asked me for the following HOWTO, so I decided to post it here (though it is still very 'alpha' and might contain many (?) mistakes; didn't test what I wrote, but wrote it - more or less - during my own installation of Python 2.3 on Fedora Core 1 Linux for a friend of mine). Anyway, HTH, L.
3
2910
by: Mike Moum | last post by:
Hi, I'm a civil engineer who also doubles as chief programmer for technical applications at my company. Most of our software is written in Visual Basic because our VP in charge of I.T. likes to have "consistency", and at the moment we're a Microsoft shop. He has assigned me the task of developing an new application, the exact nature of which is not important for my question. I told him that, in my opinion, that Visual Basic was not the...
2
15236
by: Ken Lindner | last post by:
I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000 Personal disk from the SQL Server 2000 Enterprise kit as this is reported here on the MSDN web site to be the version that is supported on Windows XP. In fact so many of you kind people confess to having succeeded in doing it. I have tried...
0
2825
by: Chris Halcrow | last post by:
Hi I've spent ALL DAY trying to re-install SQL Server 2000 on Windows XP. I continually get the error 'cannot configure server' just at the end of the installation. I've tried the following: - Removing SQL server from 'Program Files' folder following an unsuccessful attempt to re-install, and entirely removing the registry entry 'HKEY_CURRENT_USER > SOFTWARE > Microsoft > MSSQLServer', as well as the corresponding entry under...
0
4135
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed : 500 Mhz RAM : 192 MB Hard Disk : 6 GB
16
48894
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use a commercial program such as Adobe Acrobat and its associated API. The technique uses Ghostscript and Redirection Port Monitor - two free programs for creating PDF documents provided free by Russell Lang. The actual automation requires VBA...
7
2926
by: Adam | last post by:
Im trying to add an httphandler for all *.sgf file extensions. I have developed the handler, 1. installed it into the gac 2. added it to the machine.config: <httpHandlers> <add verb="*" path="*.sgf" type="CustomExtensionHandler, Extenders.CustomExtensionHandler, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d831d925597c1031" validate="True"/> </httpHandlers>
5
2296
by: JR | last post by:
Here's the scenerio: HAD: Entire Windows 2000 domain multiple servers Internal Web Server - Windows 2000 NAS Server - Windows 2000 Internal Web Application (On Web server) utilizing .ASP scripts to access shared directories through mapped drives on NAS Server. (And yes, I know UNC paths should have been used, but I didn't actually write this, just trying to follow someone else)
17
12075
by: merrily | last post by:
Read in one forum the question someone asked after successfully (sort of) installing Picture It 2000 on new computer with Vista. Will this person or any other help me accomplish this install on Vista, please. I tried installing Picture It and it seemed to do so. I got no error messages but it sure took a long time. Then when I tried to open the program it said "access denied" adding that I needed 30 meg of disk space (implying I didn't)...
0
9658
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10533
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10244
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7775
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6975
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5644
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5813
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4443
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3103
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.