![]() ![]() You can run the command line from there or add the directory to the path statement. HKLM\SOFTWARE\Microsoft\Microsoft SQL Server Local DB\Installed Versions\13.0 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): 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). ![]() ![]() 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. The default install location as pointed out by Discosultan may be: D:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe My install location was D:\Programfiles\130\Tools\Binn\SqlLocalDB.exe ![]() SQL Server Data Tools install may not be needed unless you need SSIS, SSAS or SSRS which I do need.Īfter all of this you will need SQL Server Management Studio 2016 or higher to connect to the local db and access the 2016 functionality.Īfter you have installed this there should be a SQL Local DB command Line tool installed. It stated 2012 SQL Server, but after install and restarting I had both the 20 SqlLocalDB (under 120 and 130 folders respectively). I chose custom Install and under Windows and Web Development options I chose Microsoft SQL Server Data Tools. I was assisting someone else troubleshoot their installation so I installed Visual Studio 2015 Community Edition on another Win 7 Computer. When I initially installed Visual Studio 2015 I chose custom install and selected all options. Download and install SQL Server Data Tools.If you don't have Visual Studio 2015 then get it or the 2015 Community Edition.This will allow the developer to develop and manage them by using using MDFs in LocalDB: Here is a workaround for users that need SQL 2016 on a Windows 7 development PC. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |