SQL Server 6.5 on Windows 10 x64

SQL Server 6.5 running on Windows 10

In the same effort as getting SQL Server 4.21a running on Windows 10, I found that SQL Server 6.5 will run as well.  For what it’s worth, SQL Server 6.0 runs, but the enterprise manger will not run, giving this fun error:

sdf

The SQLOLE OLE object could not be registered.

And SQL 7.0 just bombs out with this:

x

Your SQL Server installation is either corrupt or has been tampered with (unknown package id).

Which clearly means I’m missing something in trying to transplant settings.  However for some reason SQL 6.5 I can register the SQLOLE type, and boom!

SQL 6.5 in action

SQL Server 6.5 running on Windows 10

SQL Server 6.5 running on Windows 10

On Win64 vs Win32 and COM objects

I should mention that when registering a COM object you typically run something like this:

regsvr32.exe \mssql\binn\SQLOLE65.DLL

Which picks up the one in the default path.  What about system32?

%SYSTEMROOT%\system32\regsvr32.exe \mssql\binn\SQLOLE65.DLL

Well it turns out that this ‘system32’ directory is actually the 64bit system directory!  And attempting to do this will just result in the error:

64bit regsvr32 on a 32bit COM object

64bit regsvr32 on a 32bit COM object

The module was loaded but the call to DllRegisterServer failed with the code 0x80040005. Well great.  This typically goes back to a permissions issue, or the wrong regsvr32.exe being called.

However on a Win64 based OS, you actually need to specify the Win32 version of regsvr32 which actually lives in the SysWOW64 directory, and run the command prompt at administrator!  So you would run it like this:

%SYSTEMROOT%\SysWOW64\regsvr32.exe \mssql\binn\SQLOLE65.DLL

And you should get:

adf

32bit regsvr32 working

With this COM object registered, you can now launch the Enterprise manager!

Also I found a semi fun way to rename the SQL server:

sp_configure ‘allow updates’, 1
go
reconfigure with override
go
delete sysservers
go
sp_addserver YOURSERVERNAME,local
go
shutdown
go

Running this and it renamed the local SQL instance, and shut it down.  Restarting and it connected to itself just fine.  Naturally change YOURSERVERNAME to whatever your hostname is.  SQL server always wants to be called whatever the actual hostname is, otherwise things break in strange and confusing ways.

Thoughts

Is this terribly useful?  Probably not.  But I think it’s kind of interesting to run 90’s era server software in the 21st century.  Sure I wouldn’t want to run any of it in any type of production environment, but it shows at it’s core how Win32 has not drifted.  However looking at the Microsoft Management console of SQL Server 7.0, and how it will not either run on Windows 10, nor will the snapin run show just how fragile the house of COM turned out to be, and meanwhile good old fashioned Sybase/Win32  code still runs from 1993 onward.

I suppose the next thing to do is to try it on Wine, or a fun enough debugger/syscall trace to see what on earth SQL 7.0’s problem is.  I don’t have any doubt that it’s nothing that can’t be fixed, although back to the root point, would you really want SQL 7.0 in 2016… or even SQL 2000 for that matter.

5 thoughts on “SQL Server 6.5 on Windows 10 x64

  1. To be honest, “it works” don’t mean the same as “supported”. Officially supporting something requires resources, especially for a server product like SQL Server.

    • If my life really depended on SQL Server 6.5 I would be using NT 3.51 on either native hardware or on VMWare/KVM. But for the sake of validation, I would try running it on a newer OS. The disk caching and drivers really don’t compare to the later OSes.

  2. Hi.. I am trying to install SQL Server 6.5 on my Windows 10 machine using your link (http://winnt31.superglobalmegacorp.com/files/sql60.zip). But I end up getting a pop-up message saying – ‘The setup program has detected that SQL Server 6.5 has already been install by neozeed’. Would you please let me know if there is any workaround in fixing this issue?

    Thank you very much in adv.

  3. Hi neozeed,

    Thank you very much for sharing all this knowledge, I’m having a problem, in the SQL 6.5 installation the order id 54 was configured, would there be any way to change it to the order id 52?

    Thx.

    [SQL SERVER] The database you are attempting to LOAD was DUMPed under a different sort order ID (52) than the one currently running on this server (54), and a least one of them is a non-binarry sort order.

    51 Dictionary order, case-sensitive, for use with 1252 character set.
    52 Dictionary order, case-insensitive, for use with 1252 character set.
    53 Dictionary order, case-insensitive, uppercase preference, for use with 1252 character set.
    54 Dictionary order, case-insensitive, accent-insensitive, for use with 1252 character set.

    • Probably best to install on NT 3.5 with the options that you want and copy the master database over.

      I forget if the sort order is in the registry, it probably isn’t, as Sybase stored damned near everything in master.dat

Leave a Reply to Yuhong Bao Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.