.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Sql Server Shared Memory Provider error 233 No process is on the other end of the pipe

Posted By:Brijesh Kumar       Posted Date: March 11, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

If you are getting this erro while connecting to sql express server, then you should follow setting.
 

Cannot connect to SQLEXPRESS.

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)

 

If you are getting this erro while connecting to sql express server then you need to make changes mentioned below.

-----------------------------------------------------------------------------------------------------

1. Click on Start menu > Programs > Microsoft Sql Server > Configuration Tools

2. Select Sql Server Surface Area Configuration.

3. Now click on Surface Area configuration for services and connections

4. On the left pane of pop up window click on Remote Connections and Select Local and Remote connections radio button.

5. Select Using both TCP/IP and named pipes radio button.

6. click on apply and ok.


Now when try to connect to sql server using sql username and password u'll get the error mentioned below 


Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

To fix this error follow steps mentioned below 

1. connect to sql server using window authentication.

2. Now right click on your server name at the top in left pane and select properties.

3. Click on security and select sql server and windows authentication mode radio button.

4. Click on OK.

5. restart sql server servive by right clicking on server name and select restart.


Now your problem should be fixed and u'll be able to connect using sql server username and password. 



 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend