Solved

SQL Server Error

Posted on 2010-08-31
5
399 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

749 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