• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 713
  • Last Modified:

sql error named pipes shared memory

A connection was successfully established with the server,  but then an error occurred during login process. Provider shared memory provider error: 0 – no process is on the other end of the pipe Error 233
this is the error when database was trying to be accessed using sa account.
named pipes is disabled. could that be the problem
0
sqlserverdba
Asked:
sqlserverdba
  • 3
1 Solution
 
garethh86Commented:
Is SQL authentication enabled on the server? Would also check that SQL Browser service is started.

http://support.microsoft.com/kb/914277
0
 
garethh86Commented:
How to enable SQL Authentication:

http://kbase.gfi.com/showarticle.asp?id=KBID002804

It's meant for enabling reporting for GFI but the process and images are the same.
0
 
sqlserverdbaAuthor Commented:
yes sql authentication is enabled
0
 
garethh86Commented:
Ok, that was the obvious one, here's a list of what could be wrong, trial and error and see where you get:

Enable 'Named pipes' in configuration manager

Too many connections open to the server (Increase maximum connections allowed, see below)

Disable Shared memory protocol

Make sure that the sql account has a default DB assigned

Delete any ailiases


==============
Make sure there are no open connections to server and run the following script, right click server and stop and start after runnning, will set maximum number of allowed connections to unlimited.


EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE

GO

EXEC sys.sp_configure N'user connections', N'0'

GO

RECONFIGURE WITH OVERRIDE

GO

EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE

GO




If none of this works then please look at the sql log for anything fishy:

(by default located in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory).
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now