今天遇到一個(gè)問(wèn)題:SQLServer的.如圖:
問(wèn)題報(bào)錯(cuò)內(nèi)容:
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: 50 - Local
Database Runtime error occurred.無(wú)法創(chuàng)建自動(dòng)實(shí)例。有關(guān)錯(cuò)誤詳
細(xì)信息，請(qǐng)參閱Windows應(yīng)用程序事件日志。)
原因:在VS上勾選了SQLServer服務(wù),又再次安裝了導(dǎo)致版本沖突,添加基于服務(wù)的數(shù)據(jù)庫(kù)時(shí)一直無(wú)法自動(dòng)創(chuàng)建初始化實(shí)例.估計(jì)是實(shí)例被破壞了.
我的解決思路:使用
-- 停止VS中數(shù)據(jù)庫(kù)服務(wù)
C:>sqllocaldb stop MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" stopped.
-- 刪除VS中數(shù)據(jù)庫(kù)服務(wù)
C:\Users\執(zhí)著>sqllocaldb delete MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" deleted.
--重新創(chuàng)建VS中數(shù)據(jù)庫(kù)服務(wù)
C:>sqllocaldb create MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" created with version 15.0.4153.1.
--開(kāi)啟VS中的數(shù)據(jù)庫(kù)服務(wù)
C:>sqllocaldb start MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" started.最后我就解決了.可以添加實(shí)例了如圖:文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-858877.html
文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-858877.html
到了這里，關(guān)于SQL網(wǎng)絡(luò)接口錯(cuò)誤50 - 發(fā)生本地?cái)?shù)據(jù)庫(kù)運(yùn)行時(shí)錯(cuò)誤。無(wú)法創(chuàng)建自動(dòng)實(shí)例的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
