- Can't Install Windows 7 Sp1
- Cannot Install Windows 7 Service Pack 1 For X64-based Systems
- Cannot Install Windows 7 Sp1
Active10 months ago
When trying to install SQL Server 2016 Express in Windows 7 Professional x64 SP1 in VMware I get the following message.
What can I do to solve this?
How to install Windows 7 Service Pack 1 – Step by Step Steps to take before installing Windows 7 Service Pack 1: Before you take the plunge, take a moment to prepare your computer to minimize the chance of any problems: Click here for additional information on preparation and then return back to continue on. Windows 7 SP1 will not install - posted in Windows 7: I am new to this forum. I have been prompted to upgrade my browser to IE11. When attempting to do so, I get a prompt indicating Windows 7 SP1.
Vadim Ovchinnikov8,26844 gold badges3232 silver badges5555 bronze badges
Hamza Ahmed ZiaHamza Ahmed Zia59433 gold badges99 silver badges3030 bronze badges
3 Answers
As the error message states SQL Server 2016 is not supported in Windows 7. You will have to upgrade to Windows 8 or higher or switch to a Windows Server operating system. Here is a list of all the operating systems (and other hardware and software requirements) in which SQL Server 2016 can be installed.
S.KarrasS.Karras
Here is a workaround for users that need SQL 2016 on a Windows 7 development PC. This will allow the developer to develop and manage them by using using MDFs in LocalDB:
- If you don't have Visual Studio 2015 then get it or the 2015 Community Edition
- Download and install SQL Server Data Tools. SSDT
Note:
When I initially installed Visual Studio 2015 I chose custom install and selected all options. I was assisting someone else troubleshoot their installation so I installed Visual Studio 2015 Community Edition on another Win 7 Computer. I chose custom Install and under Windows and Web Development options I chose Microsoft SQL Server Data Tools. It stated 2012 SQL Server, but after install and restarting I had both the 2014 and 2016 SqlLocalDB (under 120 and 130 folders respectively). SQL Server Data Tools install may not be needed unless you need SSIS, SSAS or SSRS which I do need.
After all of this you will need SQL Server Management Studio 2016 or higher to connect to the local db and access the 2016 functionality.
After you have installed this there should be a SQL Local DB command Line tool installed. My install location was
D:Programfiles130ToolsBinnSqlLocalDB.exe
The default install location as pointed out by Discosultan may be:
My install path was different, but that may be due to the several versions and related components of SQL server that I have installed on the PC and the manner of my installs. Once you have done the install you can search for SqlLocalDB.exe if you have multiple versions and navigate to the 2016 version, (product version 13 in the 130 subfolder).
You can find the install folder path in the registry for SQL 2016 by reviewing the following Registry Entry in HKEY_LOCAL_MACHINE (Abbreviated to HKLM below):
HKLMSOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions13.0
You can run the command line from there or add the directory to the path statement. I have multiple versions so I just go to the directory. Then you create a localDB instance and start it:
SqlLocalDB create 'LocalDBExample2016' -s
Free guitar lessons online for beginners videos. The 12-video series of Guitar Lessons for Beginners will provide you with the steps needed to gain a basic foundation required to learn how to play guitar. It's such a great way to get your feet wet playing guitar as a beginner. Learning to play guitar from guitar basics to advanced concepts Guitarists of any level can improve their playing with Yousician. Whether you’re a beginner hoping to pick up the basics or already advanced, our missions and exercises are perfect for developing a wide range of skills.
From that point if you prefer the GUI you can open SQL server Management Studio 2016 or through Visual Studio and connect to server:
From there you can add databases, etc.
The mdf and log files will default to C:Users[UserName], but they can be moved when creating the databases or copied elsewhere and given to the DBAs, etc. Some of the features won't be available like in memory OLTP tables. Here are the edition comparisons: Editions and Supported Features for SQL Server 2016
Charles ByrneCharles ByrneCan't Install Windows 7 Sp1
78122 gold badges99 silver badges2020 bronze badges
Late to the party, but while you can't install SQL 2017 Express or 2016 Express on Windows 7, you can install SQL 2014 Express. This may not work for compatibility purposes if you're dealing with a newer version of SQL (although I've been able to install the non-express version of SQL 2016 and 2017 to Windows 7) but if you're supporting something that uses an older version of SQL Express (which, frankly, is likely if you don't have access to a newer OS) this should work well enough.
Cannot Install Windows 7 Service Pack 1 For X64-based Systems
NotVonKaiserNotVonKaiser