Answered by:
SQL Server installation on Windows 8

Question
-
I am planning to buy a hybrid laptop/tablet device, to be specific – LENOVO IdeaPad Yoga 13 13.3" Touchscreen Ultrabook. This device comes with Windows 8 OS. It has so many things that are appealing to me. Now, my dilemma is that I’m not sure if it is possible to install SQL Server 2008 (or above) on this device. Can someone please kindly help me understand if it is possible to install SQL Server 2008 and above on Windows 8 regardless whether it is Pro or not; or I need to get the Pro versions like Surface Pro 2 or Lenovo Yoga 2 Pro?
Many thanks,
Mpumelelo
- Edited by Mpumelelo S Monday, January 6, 2014 11:56 AM clarity
Monday, January 6, 2014 11:17 AM
Answers
-
Hi Mpumeleo S,
According to your description, you can install SQL Server on the Lenovo Yoga with Windows 8 Pro. And Surface Pro supports installing SQL server. You can only install Windows Store Apps on Windows RT, and the SQL Server Compact will never be made available on that platform. Porting a .NET WPF app to Windows Store App is sadly not trivial. If your device comes with Windows RT, you’d better host the database elsewhere and access via REST or similar, or use SQLite.
For more information about Lenovo Yoga with Windows 8 Pro, you can review the following post.
https://forums.lenovo.com/t5/Idea-Windows-based-Tablets-and/Lenovo-Yoga-with-Windows-8-Pro-Office-2013-and-Visual-Studio/td-p/939305You can check the requirements in the below link for installing SQL 2008.
http://msdn.microsoft.com/en-us/library/ms143506(v=sql.100).aspxRegards,
Sofiya LiIf you have any feedback on our support, please click here.
Sofiya Li
TechNet Community Support- Marked as answer by Sofiya Li Tuesday, January 14, 2014 2:37 AM
Tuesday, January 7, 2014 6:37 AM
All replies
-
- Proposed as answer by Shanky_621MVP Monday, January 6, 2014 12:27 PM
- Marked as answer by Alberto MorilloMVP Monday, January 6, 2014 1:36 PM
- Unmarked as answer by Mpumelelo S Monday, January 6, 2014 1:59 PM
Monday, January 6, 2014 11:42 AM -
Thank you Olaf. It is a "normal" Windows 8 and definitely not Windows 8 RT. Phew... What a relief!!!
Kind regards,
Mpumelelo
Monday, January 6, 2014 11:54 AM -
Hello,
Do you have any other question? Can we help you with something else?
Regards,
Alberto Morillo
SQLCoffee.comMonday, January 6, 2014 3:10 PM -
Hello Alberto
Thank you for your follow up question. All that I wanted to know has been whether it is possible to install SQL Server on "normal" Windows 8 (not Windows 8 RT) regardless of whether it is Pro or not Pro edition. Olaf confirmed that it is possible. Any additional suggestions which you think will be useful are welcome.
Kind regards,
Mpumelelo
- Edited by Mpumelelo S Monday, January 6, 2014 10:49 PM addition
Monday, January 6, 2014 10:43 PM -
Hello,
SQL Server 2008 requires Service Pack 3 to be compatible with Windows 8 (Not RT). The following article explains all the requirements to install (all versions of ) SQL Server on Windows 8.
http://support.microsoft.com/kb/2681562/en-us
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com- Proposed as answer by Sofiya Li Tuesday, January 7, 2014 5:54 AM
Tuesday, January 7, 2014 2:13 AM -
Hi Mpumeleo S,
According to your description, you can install SQL Server on the Lenovo Yoga with Windows 8 Pro. And Surface Pro supports installing SQL server. You can only install Windows Store Apps on Windows RT, and the SQL Server Compact will never be made available on that platform. Porting a .NET WPF app to Windows Store App is sadly not trivial. If your device comes with Windows RT, you’d better host the database elsewhere and access via REST or similar, or use SQLite.
For more information about Lenovo Yoga with Windows 8 Pro, you can review the following post.
https://forums.lenovo.com/t5/Idea-Windows-based-Tablets-and/Lenovo-Yoga-with-Windows-8-Pro-Office-2013-and-Visual-Studio/td-p/939305You can check the requirements in the below link for installing SQL 2008.
http://msdn.microsoft.com/en-us/library/ms143506(v=sql.100).aspxRegards,
Sofiya LiIf you have any feedback on our support, please click here.
Sofiya Li
TechNet Community Support- Marked as answer by Sofiya Li Tuesday, January 14, 2014 2:37 AM
Tuesday, January 7, 2014 6:37 AM