Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Oct 23 '13 at 15:55

This question came from our site for professional and enthusiast programmers.

    
I suggest you ask this either on super user or on dba.stackexchange. This is not a programming question. –  Dan Oct 23 '13 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 '13 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 '13 at 14:42

2 Answers 2

up vote 4 down vote accepted

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.

share|improve this answer
    
can i try SQL Server 2008 x32 or x64? –  Sudhakar Chaudhary Oct 23 '13 at 14:29
    
If you have a 64-bit machine, either of those options should work. –  bhamby Oct 23 '13 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. –  Aaron Bertrand Oct 23 '13 at 16:04

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).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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