Authentication / Login problem

  • Sup all, noob alert 🙂 I am using management studio express and am trying to create a log in that requires SQL server auth(currently logged in using windows auth). I select a password and confirm it, select the default database and click OK... however if i go back to edit the login I have just created, the password has changed!!? (its alot longer)

    Have tried a couple of times and it always does this. It does the same if i try to add new credentials too..

    Any idea's?

    Cheers muchly in advance 🙂

  • Did you try logging on to the SQL Server using the Login you just created? I think you will be able to log in. It is just that the management studio is showing a different length if I am not mistaken

    -Roy

  • If you are talking about the number of dots in the password field, that is just a bit of security through obfuscation. It displays the same number of dots regardless of the actual password length. It means that someone can't go in there to count the dots and determine the length of the password (which would make a brute-force attack a lot quicker - only 1 password length to check).



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply