title: Obtaining / resetting password from an MS SQL .BAK file?
body: <p>We have a client who wants us to extract data from their MS SQL bak file.  I've gone to restore it, but I'm just getting:</p>
  
  <h2>TITLE: Microsoft SQL Server Management Studio Express</h2>
  
  <p>An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)</p>
  
  <hr>
  
  <p>ADDITIONAL INFORMATION:</p>
  
  <p>Access is denied due to a password failure
  RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3279)</p>
  
  <p>For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=09.00.4053&amp;EvtSrc=MSSQLServer&amp;EvtID=3279&amp;LinkId=20476" rel="nofollow noreferrer">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=09.00.4053&amp;EvtSrc=MSSQLServer&amp;EvtID=3279&amp;LinkId=20476</a></p>
  
  <hr>
  
  <p>BUTTONS:</p>
  
  <h2>OK</h2>
  
  <p>The password itself seems to have been set by the original software vendor, and so the client doesn't have it.</p>
  
  <p>Is there any way I can reset or obtain this password?</p>