Solved

SQL Server Error

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now