sql - 错误消息 : (provider: Shared Memory Provider, 错误 : 0 - No process is on the other end of the pipe. )

Question

我正在尝试在 Windows Server 2003 上部署我的网站。我是否遗漏了某些内容，或者以下错误消息有什么问题，我该如何纠正？谢谢

我收到错误消息:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1019
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
NHibernate.Connection.DriverConnectionProvider.GetConnection() +104
NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare() +15 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper) +89
NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory) +80
NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners) +599
NHibernate.Cfg.Configuration.BuildSessionFactory() +104
MyProject.API.Data.SessionManager..cctor() in C:\Dev\Code\API\Data\SessionManager.cs:27

Answer 1

通常，要解决此问题，您可以转到 SQL Server 配置管理器 (SSCM) 并:

1. 确保启用共享内存协议(protocol)
2. 确保命名管道协议(protocol)已启用
3. 确保 TCP/IP 已启用，并且位于设置中的命名管道之前

也许它可以帮助:Could not open a connection to SQL Server

注意:如果这是 SQL Server 的新实例，请确保启用SQL Server 和 Windows 身份验证

1. 右键单击 SSMS 中的服务器并调出服务器属性
2. 转到“安全性”--> 选择“SQL Server 和 Windows 身份验证模式”
3. 重新启动服务器并使用凭据登录