首页 > IT知识库 > windows 2003 >

错误消息error: 0 - No process is on the other end of the pipe

通常,要解决此问题,请转到SQL Server配置管理器(SSCM)
我正在尝试在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

回答:通常,要解决此问题,请转到SQL Server配置管理器(SSCM),然后:
 
确保启用了共享内存协议
确保已启用命名管道协议
确保启用了TCP / IP,并且在设置中位于“命名管道”之前

这是旧的,但是我在连接对话框中遇到了问题,它仍然默认使用我已删除的数据库。 通过运行这些命令,提示中的默认数据库不会更改。 我读到某个我现在找不到的地方,如果您打开“连接到服务器”对话框,然后选择“选项”,然后通过键入默认数据库(从下拉列表中进行选择)选择“连接属性”选项卡 然后将保持输入的新值。 这对我来说听起来像是一个缺陷,但是如果有人对此感到疑惑,那应该可以解决此问题,至少在SQL Server 2012上可以解决此问题。