title: Can't access SQL Server with my sa credential
body: <p>I reset my SQL Server 2008 R2 <code>sa</code> password:</p>
  
  <pre><code>sp_password @new = 'joomlacmssenha', @loginame = 'sa'
  </code></pre>
  
  <p>But when I try to access using SQL Server Authentication with these credentials, I get the following error:</p>
  
  <blockquote>
    <p>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)</p>
  </blockquote>
  
  <p>The explanation for that error is:</p>
  
  <blockquote>
    <p>The SQL Server client cannot connect to the server. This error could occur because the server is not configured to accept remote connections. </p>
  </blockquote>
  
  <p>But it is a local database, not a remote. So why is this error happening?</p>