provider: Shared Memory Provider, error: 0

通常情况下,要解决这个,你去SQL Server配置管理器(SSCM)和:

【1】在SSCM中设置

【1.1】确保共享内存协议启用

【1.2】确保命名管道协议

【1.3】确保TCP / IP被启用,和S超前的命名管道中的设置

【2】数据库设置,开启win+SQL  mode

  1. 右键单击服务器名称,然后选择properties
  2. 选择security标签;
  3. 启用SQL Server and Windows Authentication mode

核心参考:https://stackoverflow.com/questions/27267658/no-process-is-on-the-other-end-of-the-pipe-sql-server-2012

核心参考:https://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

原文地址:https://www.cnblogs.com/gered/p/11577198.html