title: Unable to change the password of "sa" in SQL Server 2008
body: <p>I am trying to change the password of the <code>sa</code> account via SQL Server Management Studio, but it's not changing it, i tried all the techniques describe here <a href="http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/" rel="nofollow">http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/</a></p>
  
  <p>WhenI tried to enter the management studio by sa it gave this error </p>
  
  <p>Login failed for user 'sa'. (.Net SqlClient Data Provider)</p>
  
  <hr>
  
  <p>For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;EvtSrc=MSSQLServer&amp;EvtID=18456&amp;LinkId=20476" rel="nofollow">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;EvtSrc=MSSQLServer&amp;EvtID=18456&amp;LinkId=20476</a></p>
  
  <hr>
  
  <p>Server Name: MY-PC\SQLEXPRESS
  Error Number: 18456
  Severity: 14
  State: 1
  Line Number: 65536</p>
  
  <p>after changing password I got this error </p>
  
  <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.) (.Net SqlClient Data Provider)</p>
  
  <hr>
  
  <p>For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;EvtSrc=MSSQLServer&amp;EvtID=233&amp;LinkId=20476" rel="nofollow">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;EvtSrc=MSSQLServer&amp;EvtID=233&amp;LinkId=20476</a></p>
  
  <hr>
  
  <p>Server Name: MY-PC\SQLEXPRESS
  Error Number: 233
  Severity: 20
  State: 0</p>