locked
Problem with login password RRS feed

  • Question

  • Hi, when I create a login in SQL Server Express and give it a 12 alphanumeric password, whenever I go to Properties of the login, the password is 15 characters long.

    Any idea what is happening here? I can't connect with the login / password I specify in the login definition. The login also has a user in the database I'm trying to connect to.

    Let me know. Thanks

    Sunday, May 12, 2013 7:57 PM

Answers

  • Looks like you are troubleshooting in wrong direction due to the fact that number of "stars"/Characters" in password screen is always shown as 15 in that screen.

    What I believe is that your SQL Server is running under "Windows Authentication and you are trying to login with a SQL Account. To correct that, please change the Authentication Mode of mixed.
    http://msdn.microsoft.com/en-us/library/ms188670.aspx

    if issue is not solve after this, please share the error message and errorlog


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    • Proposed as answer by Olaf HelperMVP Monday, May 13, 2013 4:59 AM
    • Marked as answer by Fanny Liu Monday, May 20, 2013 10:20 AM
    Monday, May 13, 2013 1:41 AM
  • the password is 15 characters long.


    The saved password in SSMS is always shown with 15 char for security reason, so no one can guess the length of your password.

    Olaf Helper

    Blog Xing

    • Proposed as answer by Fanny Liu Tuesday, May 14, 2013 6:50 AM
    • Marked as answer by Fanny Liu Monday, May 20, 2013 10:20 AM
    Monday, May 13, 2013 5:00 AM

All replies

  • Looks like you are troubleshooting in wrong direction due to the fact that number of "stars"/Characters" in password screen is always shown as 15 in that screen.

    What I believe is that your SQL Server is running under "Windows Authentication and you are trying to login with a SQL Account. To correct that, please change the Authentication Mode of mixed.
    http://msdn.microsoft.com/en-us/library/ms188670.aspx

    if issue is not solve after this, please share the error message and errorlog


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    • Proposed as answer by Olaf HelperMVP Monday, May 13, 2013 4:59 AM
    • Marked as answer by Fanny Liu Monday, May 20, 2013 10:20 AM
    Monday, May 13, 2013 1:41 AM
  • the password is 15 characters long.


    The saved password in SSMS is always shown with 15 char for security reason, so no one can guess the length of your password.

    Olaf Helper

    Blog Xing

    • Proposed as answer by Fanny Liu Tuesday, May 14, 2013 6:50 AM
    • Marked as answer by Fanny Liu Monday, May 20, 2013 10:20 AM
    Monday, May 13, 2013 5:00 AM