question

74152859 avatar image
0 Votes"
74152859 asked TianyuSun-MSFT commented

vs2019无法使用localdb(13)

标题: 错误 ------------------------------ 在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: SQL Network Interfaces, error: 0 - [x89C50118]) (Microsoft SQL Server,错误: -1983577832) 有关帮助信息,请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1983577832&LinkId=20476 ------------------------------ 其他信息: Unknown error (0x89c50118) ------------------------------ 按钮: 确定 ------------------------------

vs-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @74152859 , I have not heard from you for a couple of days. Please let me know if there is anything that I can help here.

0 Votes 0 ·
74152859 avatar image
0 Votes"
74152859 answered TianyuSun-MSFT commented

Hello, because of the time, I didn't use your suggestion in detail to find the error. Later, I downloaded the version of localdb15, which solved the problem that I can't use the local database function on vs2019. To put it simply, I can use localdb15 here, and localdb13 will cause various problems.

Sincere respect
Jianle

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Happy to hear that, feel free to contact us if you meet any other issues about VS in the future. Have a nice day:)

0 Votes 0 ·
TianyuSun-MSFT avatar image
0 Votes"
TianyuSun-MSFT answered TianyuSun-MSFT edited

Hello @74152859 ,

Welcome to Microsoft Q&A forum.

Currently in Microsoft Q&A we only support English, could you please edit your question into English? Then we can help to solve your issue better, thank you for your understanding.

Besides, have you checked the related things that error message pointed out(instance name, SQL Server configuration, network connection)?

For the general connection issues about SQL Server, here are some troubleshooting steps you can try:

1). Make sure SQL Server Service is running.
2). If named an instance, make sure SQL Server browser service is running. Make sure the instance name is spelled correct and there is such an instance exists on your target machine.
3). Make sure SQL Server is configured to allow remote connections.
4). Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports.
5). Test the connectivity between the server and PING from the client machine.
6). Using TELNET to the server and the port (from step 4) from the client machine to test the connectivity of the port. For example TELNET <server-name> 1433.
7). Check firewall settings if the connection test in step 5 or 6 fails.

Also, please check this document: Troubleshoot connection to the SQL Server Database Engine for more detailed information.

Best Regards,
Tianyu


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.