SQL Server 2016 开发版无法连接到(LocalDB)\MSSQLLocalDB
技术问答
275 人阅读
|
0 人回复
|
2023-09-12
|
|
由于未知的原因，我重新安装了 SQL Server 2016，导致SQL Server 宕机……然而，当我完成安装时，我发现我不能再安装了* x3 Q' y1 S" j9 E
连接(LocalDB)\MSSQLLocalDB了。我从SQL Server收到这个错误的消息。+ X0 s1 q' S$ S
Cannot connect to (LocalDB)\MSSQLLocalDB.
( l2 q% _! d- G* J: aA network-related or instance-specific error occurred while establishing a
6 Q, K3 W$ G: l5 ]connection to SQL Server. The server was not found or was not accessible.9 d4 f; `3 n5 o3 O$ U
Verify that the instance name is correct and that SQL Server is configured
) m6 Y+ L9 H# A% lto allow remote connections. (provider: SQL Network Interfaces,error: 52 -8 J! n- S- c' Z; I t5 X
Unable to locate a Local Database Runtime installation. Verify that SQL' m& ]+ a* l6 A8 y
Server Express is properly installed and that the Local Database Runtime
' r, U) a; z/ F+ z( U" B; P0 w) @feature is enabled.) (Microsoft SQL Server,Error: 2)/ R3 C3 V$ h3 u- y1 ]2 G2 t' D9 F
任何对如何解决这个问题有任何想法的人？我真的需要加快速度# u. `; o R7 Y+ C. b
但是数据库问题让我什么都做不了。
* ]: a! h' Q* |# u- }; |8 }3 X: a2 M
" A, l! t3 {3 b4 T8 R- | 解决方案:
3 K/ j, \) u; j4 g# M* O LocalDB是 SQL Server Express的特殊版本- 如果您没有安装它，则无法使用服务器/实例名连接到它。! Y" A( t: W" ~. x( p& z
您可以轻松地单独安装 SQL Server Express LocalDB，与 SQL Server Developer 并行安装- 但是你需要清楚地安装它。 |
|
|
|
|
|
|
|
|
|
