title: How can I resolve error 233 in SQL Server 2005 under Windows 7?
body: <p>I'm creating a new login with SQL Server authentication. Once the login is created, I then try to connect to the database using SQL Server authentication. This produces the following error:</p>
  
  <blockquote>
    <p>Cannot connect to (SERVER NAME) i.e machine name/sql\express </p>
  </blockquote>
  
  <p>Additional Information:</p>
  
  <blockquote>
    <p>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.) 
    (Microsoft SQL  Server, Error: 223)</p>
  </blockquote>
  
  <p>Here is what I have already tried for troubleshooting:</p>
  
  <ul>
  <li>Enabling all the protocols</li>
  <li>Ensuring that I am running as Administrator</li>
  <li>Setting the Authentication Mode to Windows and SQL Server Authentication</li>
  </ul>
  
  <p>Unfortunately, none of these steps seem to have worked. How can I fix this error?</p>