Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server Error

Posted on 2010-08-31
5
Medium Priority
?
411 Views
Last Modified: 2012-08-14
Never seen this before. Turned on my computer and tried to connect to my local machine with Management Studio. Tried rebooting, nothing. Here's the error:

a connection was successfully established with the server, but then an error occurred during the login process. (provider: shared memory prrovider, error 0 - no process is on the other end of the pipe) (microsoft sql server, error: 233).

Please help!

Thanks!
0
Comment
Question by:infotechelg
  • 3
5 Comments
 

Expert Comment

by:viralbhatt
ID: 33567842
This error usually indicates that the server closed the connection, e.g. during login verification.

The best is to check for any messages from SQL Server correlated to the time of the failure - either in the Application EventLog or in the ERRORLOG file (by default located in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory).  There is a chance they provide more information to identify the root cause of the failure.
0
 

Author Comment

by:infotechelg
ID: 33567913
the log file hasn't been updated since 8/16
0
 

Author Comment

by:infotechelg
ID: 33567959
I take that back. The log file wasn't in the MSSQL.1 folder, it was in the MSSQL.3 folder.

Is this the issue?

2010-08-31 09:41:05.04 Logon       Could not connect because the maximum number of '1' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2010-08-31 09:41:05.04 Logon       Error: 17809, Severity: 20, State: 3.
0
 

Accepted Solution

by:
infotechelg earned 0 total points
ID: 33568035
Something about the VIA protocol not being enabled? I have no idea what that means, but that was the issue.
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 33568513
Is the SQL Server running locally? Does the login failure happen almost immediately, or does it take about 30 seconds to timeout?

 - If it's immediate, then SQL Server is denying your login request, which indicates that it's not configured properly.
 - However, if it times out, then I'd suspect the SQL Server service is stopped - check your Administrative Tools -> "Services" list to see if "SQL Server" is running, and start it if it's stopped for some reason.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Integration Management Part 2
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question