sql-server - 无法连接到 (localdb)\MSSQLLocalDB

Question

Cannot connect to (LocalDB)\MSSQLLocalDB.A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that the SQL server is configured to allow remote connections.(provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start.)( Microsoft SQL server)

昨天我能够连接到 (LocalDB)\MSSQLLocalDB，并且能够在 SQL Server Management Studio 中看到其中的所有数据库。但是今天当我尝试连接时，出现了上述错误。

昨天我是如何连接的，为什么现在不行了？请帮助我。

Answer 1

Windows 日志中有关缺少注册表值的错误消息表明您的 localdb 实例已损坏。您可以通过从命令提示符运行这些命令来重新创建 MSSQLLocalDB 实例和注册表项:

sqllocaldb delete MSSQLLocalDB
sqllocaldb create MSSQLLocalDB -s