一段时间后SQL Server登录失败 [英] SQL Server login fail after some time

问题描述

我有一个服务器系统，其中安装了Windows Server 2003和SQL Server 2005企业版。它有两个24/7运行的应用程序。其中一个是接受并将数据保存为XML文件的TcpListener，另一个是处理xml并插入数据库。数据库已启用远程访问。但几个小时后我们无法在本地或远程登录数据库而无需重新启动服务器..请帮助我这是什么原因??



这是我得到的错误消息



与服务器建立了连接成功，但在登录过程中出现错误。（提供商：共享Memeory Provoder，错误：0 - 没有进程在管道的另一端。）Microsoft SQL服务器错误：233

I have a server system with windows server 2003 and SQL server 2005 Enterprise edition installed in it. It has two applications running 24/7. One of which is a TcpListener which accept and save data as XML file, the other which process the xml and insert into database. The database is enabled to access remotely. But after some hours we can't login to the database locally or remotely without restarting the server..Pls help me what is the reason for that??

This is the error message what i am getting

"A connection was succesfulyl established with the server, but then an error occured during the login process. (provider: Shared Memeory Provoder, error: 0 - No Process is on the other end of the pipe.)Microsoft SQL server error:233

推荐答案

我的第一个端口如果您的连接被关闭并在代码中被处理掉了，那么听起来就好像您正在使用所有资源，然后重启会强制重置。

My first port of call would be, are your connections being closed and disposed of in code ? It sounds to me like you're using all your resources, and then a reboot forces a reset.

检查这些

与服务器成功建立连接，但是在登录过程中发生了错误。（提供者：共享内存提供者，错误r：0 - 管道的另一端没有进程。）（。Net SqlClient数据提供程序） [ ^ ]

SqlServer共享内存提供程序Error233没有进程在管道的另一端 [ ^ ]

Check these
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.) (.Net SqlClient Data Provider)[^]
SqlServer Shared Memory Provider Error233 No Process Is On Other End Of Pipe[^]

这篇关于一段时间后SQL Server登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！