Can't access SQL Server with my sa credential

sql-server sql-server-2008-r2 sa
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.

Related questions

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More
CREATE TABLE IF NOT EXISTS equivalent in SQL Server

CREATE TABLE IF NOT EXISTS works on mysql but fails with SQL Server 2008 R2. What is the equivalent syntax?

Read More