SQL Server 2016 开发版无法连接到(LocalDB)\MSSQLLocalDB
技术问答
312 人阅读
|
0 人回复
|
2023-09-12
|
由于未知的原因,我重新安装了 SQL Server 2016,导致SQL Server 宕机……然而,当我完成安装时,我发现我不能再安装了* g1 a" ?& O; X
连接(LocalDB)\MSSQLLocalDB了。我从SQL Server收到这个错误的消息。
2 c5 s1 B; f2 V% Y* CCannot connect to (LocalDB)\MSSQLLocalDB.- k8 ~; Z- [% s3 O! M6 z
A network-related or instance-specific error occurred while establishing a% P0 d% S4 @" O" V1 q
connection to SQL Server. The server was not found or was not accessible.+ N; R* A( h5 }6 Q6 I6 i! ]+ `
Verify that the instance name is correct and that SQL Server is configured
8 D$ E9 l- d0 [; m# S: sto allow remote connections. (provider: SQL Network Interfaces,error: 52 -
. ^9 k; m% ]1 f0 {1 o3 |& KUnable to locate a Local Database Runtime installation. Verify that SQL
; [ `3 Q0 }) E/ m$ RServer Express is properly installed and that the Local Database Runtime0 j" _0 ^+ [6 i7 T) ^6 ~) j8 `5 R R
feature is enabled.) (Microsoft SQL Server,Error: 2)
; H( N% j3 n. M8 U! i任何对如何解决这个问题有任何想法的人?我真的需要加快速度
6 [* v, ~9 H2 y* _0 \' L0 M8 z+ x但是数据库问题让我什么都做不了。( }! h9 {1 d9 @6 s6 d
! B4 P2 L& p5 p" N0 v* e" P
解决方案: 6 c V+ x& Q [% j1 {, d R
LocalDB是 SQL Server Express的特殊版本- 如果您没有安装它,则无法使用服务器/实例名连接到它。# j, Y, s" L B- D0 G$ Z9 y6 q
您可以轻松地单独安装 SQL Server Express LocalDB,与 SQL Server Developer 并行安装- 但是你需要清楚地安装它。 |
|
|
|
|
|