title: SQL Server 2008 Error 233
body: <p>I'm creating new login in SQL Server 2008 with following sql script:</p>
  
  <pre><code>CREATE LOGIN [xyz] WITH PASSWORD='xyz',
              DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], 
              CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
  </code></pre>
  
  <p>It creates new login successfully. But when I try to login with it using SQL Server Management Studio it fails saying:</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: 233)</p>
  </blockquote>
  
  <p>What's wrong? How do I solve this issue?</p>