|
|
No process is on the otherend of the pipe Microsoft SQL Server Error: 233
Thu, 08/05/2010 - 10:33
I installed "SQL Server 2005 Express edition" and "SQL Server Management Studio Express" on my windows 2003 server.I logged in using windows authentication and created a user in security->logins and assigned all server roles.But while trying to log in using newly created user and SQL Server authentication in "SQL Server Management Studio Express" it throws the error
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
how to resove the said error.Thanks in advance
Similar entries
- SQL Server does not allow remote connections Error 26
- solution to winsock error
- Script action to job in Server Management Studio Express
- IIS problem:The Web server reported the following error
- 500 - Internal server error generic error message in ASP pages
- How to resolve "Failed to generate a user instance of SQL Server due to failure in
- windows 2003 shares Error 2114: ther server service is not startd
- database restore from .bak file problem
- Change authentication mode from windows to mixed mode in SQL Server 2005 (Express)
- Problem in creating primary key in SQL Server
As you told that you are able to login using Windows Authentication but while trying to login using SQL Server Authentication you are facing the error.This may be becuse you selected Windows Authentication instead of Mixed Mode Authentication(Windows Authentication and SQL Server Authentication)at the time of installation.I think converting from Windows Authentication to Mixed Mode Authentication(Windows Authentication and SQL Server Authentication)will solve problem.