LocalDB 父实例版本无效:MSSQL13E.LOCALDB [英] LocalDB parent instance version invalid: MSSQL13E.LOCALDB

问题描述

我无法在开发人员机器上添加数据库.我正在运行 win 10，visual studio 2015.我重新安装了 SQL Server 2016 两次，上次关闭了防火墙，最后都给了绿色标记.

I'm unable to add a database on a developer machine. I'm running win 10, visual studio 2015. I re-installed SQL server 2016 twice, last time with firewall disabled it all gave green marks in the end.

虽然我可以在 VS2015 SQL 服务器对象资源管理器中创建数据库.我无法通过解决方案资源管理器向我的项目添加 SQL 数据库.

While i can create databases in VS2015 SQL server object explorer. I am unable to add a SQL database(S) to my projects, trough solution explorer.

每次我尝试将数据库添加到项目时，我都会收到事件527 SQLLocalDB 12.0LocalDB 父实例版本无效:MSSQL13E.LOCALDB

Each time i try to add a database to a project i get event 527 SQLLocalDB 12.0 LocalDB parent instance version is invalid: MSSQL13E.LOCALDB

我试过了开始 > 运行 > cmd > sqlcmd -L它显示了我的 SQLserver

I've tried Start > Run > cmd > sqlcmd -L and it shows my SQLserver

还确保它使用正确的端口 (为什么我会收到无法连接到服务器 - 与网络相关或特定于实例的错误"?)

Also made sure it uses the right ports as by (Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?)

我认为 SQL 安装正确，但有些东西不允许我添加数据库(可能是因为某些根数据库?接缝不见了??

i think that SQL is installed properly but that something is not allowing me to add databases (maybe because some root database?? is missing or so i am not sure i m not an export on SQL, but as the error says some DB seams missing ??

推荐答案

我有类似的东西并删除了以下所有键:HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft SQL Server\UserInstances没有正确的 ParentInstance 键，例如 MSSQL13E.LOCALDB.

I had something similar and deleted any keys in: HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft SQL Server\UserInstances that did not have the correct ParentInstance key such as MSSQL13E.LOCALDB.

无需重新安装或重启.

这篇关于LocalDB 父实例版本无效:MSSQL13E.LOCALDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！