2

I need to install SQL Server 2005 Express on Windows 8 Home Edition x64.

But I get a compatibility error!

I have tried SP1, SP2, SP3 of SQL Server 2005.

Visual Studio 2008 is working fine.

Any suggestions?

3
  • I suggest you ask this either on super user or on dba.stackexchange. This is not a programming question.
    – Dan
    Oct 23, 2013 at 14:21
  • SQL Server 2005 Express is supported on x64 and EMT64 systems in Windows On Windows (WOW). SQL Server 2005 Express is not supported on IA64 systems. From official MS site...
    – apomene
    Oct 23, 2013 at 14:25
  • Not supported != not possible. See my answer, I have Sql 2005 running on Win8 and I haven't seen any issues.
    – Andy
    Oct 23, 2013 at 14:42

2 Answers 2

5

According to this Microsoft KB article, SQL Server 2005 (in any form, even with all the Service Packs installed) is not supported on Windows 8.

  • SQL Server 2008 is supported, as long as you install Service Pack 3.

  • SQL Server 2008 R2 is supported, as long as you install Service Pack 1.

  • SQL Server 2012 is supported with any version.

3
  • can i try SQL Server 2008 x32 or x64?
    – Sudhakar Chaudhary
    Oct 23, 2013 at 14:29
  • If you have a 64-bit machine, either of those options should work.
    – bhamby
    Oct 23, 2013 at 15:06
  • 5
    @Sudhakar If you have a 64-bit machine, I have absolutely no idea why you would want to install the 32-bit version of SQL Server. Oct 23, 2013 at 16:04
1

While the others are correct in that its not supported, it doesn't mean you can't install it and that it doesn't work (actually I have SQL Server 2005 on my Win8 machines, and have not seen any issues with it) If you turn off the Compatibility Assistant (which actually will block you from doing what you want) you should be able to install it. See this answer at Superuser which describes how to turn it off.

As an alternate suggestion, maybe you could setup Win7 in a hyper-v virtual machine, assuming you have a license for Win7. If you don't you may want to consider at least an MSDN OS only subscription, which would cover you in this situation (you could install Win7 or whatever OS you wanted that SQL Server 2005 was supported on as a virtual).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.