由于未知原因,我重新安装了我的 SQL Server 2016,导致SQL Server 宕机……但是,当我完成安装时,我发现我无法再 连接(LocalDB)\MSSQLLocalDB了。我从SQL Server收到此错误消息。
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 SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.) (Microsoft SQL Server, Error: 2)
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 SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.) (Microsoft SQL Server, Error: 2)
任何对如何解决这个问题有任何想法的人?我确实需要加快 开发速度,但是数据库问题使我无法做任何事情。
LocalDB是 SQL Server Express的特殊版本- 如果您尚未安装它,则无法使用该服务器/实例名称连接到它。
您可以轻松地单独安装 SQL Server Express LocalDB,与 SQL Server Developer 版本并行安装 - 但您需要明确安装它。