Cannot access SQLServer with my sa accout.

Question

Sql Server Version : Express 2008 RC2. 

I can access fine with windows mode, and the password is fine for the sa, but i get the message 

"...............an error occured during the login process (provider: Shared Memory Proider, error:0 - No process is on the other end of the pipe.) 

Note I have mixed mode security switched on. 

Any help / advice welcome.

Gerry

Answer 1

Hi,

Could you try forcing it to use TCP/IP?  Just to see if it works...

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 2

Is the sa account enabled? How to: Change Server Authentication Mode http://msdn.microsoft.com/en-us/library/ms188670.aspx

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 3

Hi Gerryabbott,

You could refer to this article: http://www.sqlmusings.com/2011/06/25/connection-error-233-no-process-at-the-other-end-of-the-pipe/.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.