Can't access SQL Server with my sa credential

Guilherme Longo picture Guilherme Longo · Nov 29, 2012 · Viewed 13.7k times · Source

I reset my SQL Server 2008 R2 sa password:

sp_password @new = 'joomlacmssenha', @loginame = 'sa'

But when I try to access using SQL Server Authentication with these credentials, I get the following error:

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)

The explanation for that error is:

The SQL Server client cannot connect to the server. This error could occur because the server is not configured to accept remote connections.

But it is a local database, not a remote. So why is this error happening?

Answer

Guilherme Longo picture Guilherme Longo · Nov 29, 2012

I found the solution.

https://serverfault.com/questions/35505/cant-connect-to-sql-server-using-sa-account-what-im-missing

I still don´t understand why microsoft says that is a remote connection problem.