title: Connecting to a local MS SQL instance - User Must change password at next login
body: <p>I am working on an Azure Mobile Apps backend service, which I am trying to connect to a local MS SQL database, as describe <a href="https://azure.microsoft.com/en-gb/documentation/articles/app-service-mobile-node-backend-how-to-use-server-sdk/#howto-sqlexpress-setup" rel="nofollow noreferrer">here</a>. I have followed all the steps, except I am using 2016 rather than 2014. </p>
  
  <p>If I follow the Microsoft tutorial exactly, everything works fine. I am not sure what the environment variable is about, as I don't reference it anywhere, but anyway, when I run my app, I get the following output:</p>
  
  <pre><code>Express server listening on port 3000
  2016-06-19T09:37:39.331Z - error: Error occurred during table initialization ConnectionError: Login failed for user 'azuremobile'.  Reason: The password of the account must be changed.
      at Connection.&lt;anonymous&gt; (C:\Users\George\Source\Repos\backend\node_modules\mssql\lib\tedious.js:378:25)
      at Connection.g (events.js:260:16)
      at emitOne (events.js:77:13)
      at Connection.emit (events.js:169:7)
      at Connection.processLogin7Response (C:\Users\George\Source\Repos\backend\node_modules\tedious\lib\connection.js:672:16)
      at Connection.message (C:\Users\George\Source\Repos\backend\node_modules\tedious\lib\connection.js:1082:21)
      at Connection.dispatchEvent (C:\Users\George\Source\Repos\backend\node_modules\tedious\lib\connection.js:519:45)
      at MessageIO.&lt;anonymous&gt; (C:\Users\George\Source\Repos\backend\node_modules\tedious\lib\connection.js:439:23)
      at emitNone (events.js:67:13)
      at MessageIO.emit (events.js:166:7)
  </code></pre>
  
  <p>This seems to be because of the setting that is shown below, "User Must change password at next login"? <a href="https://i.stack.imgur.com/L7VP8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/L7VP8.png" alt="enter image description here"></a></p>
  
  <p>However, If I change the password, or delete and recreate the login but unchecking that feature. I get this:</p>
  
  <blockquote>
    <p>error: Error occurred during table initialization ConnectionError: Login failed for user 'azuremobile'.</p>
  </blockquote>
  
  <p>I am possibly getting the password wrong, but I have tried this 6 times now. Is there a way I can check the password or anything else I can do to get my node project to login to my local SQL db? </p>