SQL Server 2016 开发版无法连接到(LocalDB)\MSSQLLocalDB
技术问答
321 人阅读
|
0 人回复
|
2023-09-12
|
由于未知的原因,我重新安装了 SQL Server 2016,导致SQL Server 宕机……然而,当我完成安装时,我发现我不能再安装了0 o. b, j9 K- I9 Q0 \
连接(LocalDB)\MSSQLLocalDB了。我从SQL Server收到这个错误的消息。* C7 j/ m* a- V
Cannot connect to (LocalDB)\MSSQLLocalDB.+ _7 X7 w+ o' R/ }. K) y
A network-related or instance-specific error occurred while establishing a( J7 d. y7 K ~% r6 r: `
connection to SQL Server. The server was not found or was not accessible.
" Y1 B3 r2 w3 {* B4 HVerify that the instance name is correct and that SQL Server is configured* I# G( A p- o& { z
to allow remote connections. (provider: SQL Network Interfaces,error: 52 -
7 Q1 ?/ o2 y0 y+ R! d* B' aUnable to locate a Local Database Runtime installation. Verify that SQL
' W7 M" n \/ R& `8 J1 a2 @9 yServer Express is properly installed and that the Local Database Runtime
, [ P9 w3 z4 \( ]1 Efeature is enabled.) (Microsoft SQL Server,Error: 2)
+ A5 M# L! E9 u& s% Z3 k1 j# E任何对如何解决这个问题有任何想法的人?我真的需要加快速度
9 ?' p& D2 J8 E但是数据库问题让我什么都做不了。0 [! J C6 Q" M+ z, |
* [# d: F* L; |2 h7 L 解决方案: 9 n3 }7 i1 y# e5 S- B7 {/ ^( f% h) R
LocalDB是 SQL Server Express的特殊版本- 如果您没有安装它,则无法使用服务器/实例名连接到它。% z P, S0 g& t% Q8 x
您可以轻松地单独安装 SQL Server Express LocalDB,与 SQL Server Developer 并行安装- 但是你需要清楚地安装它。 |
|
|
|
|
|