question

jhunu avatar image
jhunu asked

login issue

In sql , error message is "login failed " after first time login. Pls help .
loginissue
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
We need a little more to go on. Are you using SQL authentication or Windows authentication? Typically "login failed" means you have the wrong combination of user name and password. Make sure you are using the proper authentication method, either local SQL or Windows.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
I'm guessing that the first login was successful, but subsequent logins using the same credentials weren't, which would mean that the account was set up with "change password on first login" set (using the GUI), or with the option "MUST_CHANGE" (if created using T-SQL).
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.