- Remove From My Forums
-
Question
-
I have SQL LocalDB 2016 sp1 installed and when I execute at the command line «SQLLocalDB versions» I get the following error «Windows API call «RegGetValueW» returned error code: 0.»
I used sysinternals procmon.exe to capture any errors accessing the registry.
The following path was not found that seems significant.
HKLMSOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions13.1
I loaded regedit and confirmed the path does not exist. The registry does have
HKLMSOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions13.0
SQL LocalDB installed with Visual Studio 2017 which is not SP1 runs without errors.
I have tried installing service packs for SQL, uninstalling/reinstalling. I have reset windows 2 times. In this final test I installed Windows 10 from scratch and installed only SQL Express Advanced with Sp1. All Windows updates are installed.
I can’t resolve this issue with reinstall or installing the updates.
I do not find any hits in google for this error. The error is on a clean install of Windows 10.
Thanks.
Answers
-
I got this on my machine, the problem was that under this registry key:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL13E.LOCALDBMSSQLServerCurrentVersion
There is an «CurrentVersion» value that is «13.1.4001.0» and under:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions
I had «13.0» — changing it to «13.1» fixed the error — not sure why the installed versions wasn’t changed when it went to 13.1.
Probably uninstalling/re-installing would fix it as well.
SSDT Dev Pack — Open source (free) Visual Studio Add-in: -Extract select statements into TVF’s -Create stub tSQLt tests -Change keyword casing -Name constraints -Ui for Merge statements https://the.agilesql.club/Projects/SSDT-Dev-Pack
-
Proposed as answer by
Wednesday, March 29, 2017 8:59 AM
-
Marked as answer by
.MARK
Sunday, April 30, 2017 5:48 PM
-
Proposed as answer by
- Remove From My Forums
-
Question
-
I have SQL LocalDB 2016 sp1 installed and when I execute at the command line «SQLLocalDB versions» I get the following error «Windows API call «RegGetValueW» returned error code: 0.»
I used sysinternals procmon.exe to capture any errors accessing the registry.
The following path was not found that seems significant.
HKLMSOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions13.1
I loaded regedit and confirmed the path does not exist. The registry does have
HKLMSOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions13.0
SQL LocalDB installed with Visual Studio 2017 which is not SP1 runs without errors.
I have tried installing service packs for SQL, uninstalling/reinstalling. I have reset windows 2 times. In this final test I installed Windows 10 from scratch and installed only SQL Express Advanced with Sp1. All Windows updates are installed.
I can’t resolve this issue with reinstall or installing the updates.
I do not find any hits in google for this error. The error is on a clean install of Windows 10.
Thanks.
Answers
-
I got this on my machine, the problem was that under this registry key:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL13E.LOCALDBMSSQLServerCurrentVersion
There is an «CurrentVersion» value that is «13.1.4001.0» and under:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions
I had «13.0» — changing it to «13.1» fixed the error — not sure why the installed versions wasn’t changed when it went to 13.1.
Probably uninstalling/re-installing would fix it as well.
SSDT Dev Pack — Open source (free) Visual Studio Add-in: -Extract select statements into TVF’s -Create stub tSQLt tests -Change keyword casing -Name constraints -Ui for Merge statements https://the.agilesql.club/Projects/SSDT-Dev-Pack
-
Proposed as answer by
Wednesday, March 29, 2017 8:59 AM
-
Marked as answer by
.MARK
Sunday, April 30, 2017 5:48 PM
-
Proposed as answer by
- Remove From My Forums
-
Question
-
I have SQL LocalDB 2016 sp1 installed and when I execute at the command line «SQLLocalDB versions» I get the following error «Windows API call «RegGetValueW» returned error code: 0.»
I used sysinternals procmon.exe to capture any errors accessing the registry.
The following path was not found that seems significant.
HKLMSOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions13.1
I loaded regedit and confirmed the path does not exist. The registry does have
HKLMSOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions13.0
SQL LocalDB installed with Visual Studio 2017 which is not SP1 runs without errors.
I have tried installing service packs for SQL, uninstalling/reinstalling. I have reset windows 2 times. In this final test I installed Windows 10 from scratch and installed only SQL Express Advanced with Sp1. All Windows updates are installed.
I can’t resolve this issue with reinstall or installing the updates.
I do not find any hits in google for this error. The error is on a clean install of Windows 10.
Thanks.
Answers
-
I got this on my machine, the problem was that under this registry key:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL13E.LOCALDBMSSQLServerCurrentVersion
There is an «CurrentVersion» value that is «13.1.4001.0» and under:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server Local DBInstalled Versions
I had «13.0» — changing it to «13.1» fixed the error — not sure why the installed versions wasn’t changed when it went to 13.1.
Probably uninstalling/re-installing would fix it as well.
SSDT Dev Pack — Open source (free) Visual Studio Add-in: -Extract select statements into TVF’s -Create stub tSQLt tests -Change keyword casing -Name constraints -Ui for Merge statements https://the.agilesql.club/Projects/SSDT-Dev-Pack
-
Proposed as answer by
Wednesday, March 29, 2017 8:59 AM
-
Marked as answer by
.MARK
Sunday, April 30, 2017 5:48 PM
-
Proposed as answer by
Ohh Sorry seeplus was doing other things.. and forgot about it. I decided to make it work with RegQueryValueExA function. SO it works.
Ahh.. about my windows SDK version.. I think is V.10.0A. Still in my winreg.h what you show me … I DON’T HAVE.. i type it to search … and doesn’t exist. My winreg.h is so small I think it doesn’t reach 200 lines .
|
|