SQLLocalDB event ID 512
Article ID: CTX284751
Updated On:
Description
The Delivery Controller event logs show numerous error
Event ID: 512
Source: SQLLocalDB 14.0
The "DataDirectory" registry value is missing in the LocalDB instance registry key: {44A9EE4E-9BD8-4715-AD84-84FC18033127}
The "DataDirectory" registry value is missing in the LocalDB instance registry key: {3D3F09E6-89DC-46C8-92E7-F7047D897D11}
The "DataDirectory" registry value is missing in the LocalDB instance registry key: {33C6EE25-E218-4C6D-B4ED-089D582062A4}
Environment
Caution! Using Registry Editor incorrectly can cause serious problems that might require you to reinstall your operating system. Citrix cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk. Be sure to back up the registry before you edit it.
Resolution
1. Launch Regedit
2. Browse to HKEY_USERS\S-1-5-20\SOFTWARE\Microsoft\Microsoft SQL Server\UserInstances\
3. Delete all GUIDs that doesn’t contains a value ‘DataDirectory’
If that doesn’t help, you might want to run a repair of the component ‘Microsoft SQL Server 2017 LocalDB’
If needed the installer is available on the CVAD1912 installation media under \Support\SQLLocalDB
2. Browse to HKEY_USERS\S-1-5-20\SOFTWARE\Microsoft\Microsoft SQL Server\UserInstances\
3. Delete all GUIDs that doesn’t contains a value ‘DataDirectory’
If that doesn’t help, you might want to run a repair of the component ‘Microsoft SQL Server 2017 LocalDB’
If needed the installer is available on the CVAD1912 installation media under \Support\SQLLocalDB
Problem Cause
On a ‘working’ environment, there is just one GUID under HKEY_USERS\S-1-5-20\SOFTWARE\Microsoft\Microsoft SQL Server\UserInstances\ which contains a value ‘DataDirectory’
The GUIDs listed the event log seem to refer to invalid LocalDB instance.
Was this article helpful?
Yes
No
Powered by
