Solved

SQL Server Error

Posted on 2010-08-31
5
396 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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 I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

828 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