SA Account Failure
Posted on 2010-11-23
I just installed SQL Server Express 2008 R2 on my laptop, activated my sa account, and when i try to login under sa, i get
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.) (.Net SqlClient Data Provider)
if i login undeer windows authentication, i don't get this error.
also, if it matters - this is a laptop which had some type of a sql 2005 version.