SQL Server login fail after some time

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

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

Posted 1-Jan-14 17:42pm

Member 8028486

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2014-01-01T17:50:00

Solution 1

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.

Posted 1-Jan-14 17:50pm

Christian Graus

Comments

Member 8028486 1-Jan-14 23:56pm

I am using a dataset and i am not directly opening or closing connection in my code. But the second application can use the database every time. But i can't login from other application or process to the database.

Christian Graus 2-Jan-14 0:13am

Well, what is connecting to the database then ?

Member 8028486 2-Jan-14 2:27am

one of my 24/7 working applications is inserting data to the database continuously, but during that time when i try to connect through SSMS, it shows me the error. But when i restarts the PC, it allow me to connect from both.

BK 4 code 2-Jan-14 0:04am

Increase connection pooling size from database.

Member 8028486 2-Jan-14 2:31am

Can u pls tell me how do i do that?? and what does connection pooling size means??

thatraja · Answer 2 · 2014-01-01T20:46:00

Solution 2

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[^]

Posted 1-Jan-14 20:46pm

thatraja

Comments

Member 8028486 2-Jan-14 2:54am

Sorry..it didn't helped...I have tried this all..and thanks for the try

thatraja 2-Jan-14 2:55am

Alright, could you please use Google search for this error message? you could get more links with different solutions. Believe me.

Member 8028486 2-Jan-14 2:57am

I googled this and tried it all..but no use..

thatraja 2-Jan-14 3:00am

I found typo(s) in error message from your question. So search with perfect error message. Surely you'll get...