Answered by:
Problem with login password

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.aspxif 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 -
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.aspxif 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 -
Monday, May 13, 2013 5:00 AM