Post reply

Problem creating password on any account including sa

  • July 16, 2005 at 11:32 pm

    #152473

    Hello everybody,

    I have done an extensive research but have not found anything that can solve my problem. I use SQL Server and Windows Authenitaction but the sa account had already some password after I installed SQL Server. Password is 10 simbols long and can not be changed, every time I change it goes back to the same password. And the strangest thing is that I get the same password (the same length) even when I create a new login.

    I am out of ideas and would be very thankful if anyone can help me out.

     

    Thank you in advance.

  • July 17, 2005 at 7:17 am

    #575109

    The pwd is shown as the same length only for security purposes (so no one can try and guess based on length)...it is actually the length of whatever you set it to...

    the main thing is whether you have database access or not using the password - do you get an error when you try to access the database using the sa login ?

    Also, here's something from BOL that you may not have read:

    "System administrator (sa) is a special login provided for backward compatibility. By default, it is assigned to the sysadmin fixed server role and cannot be changed. Although sa is a built-in administrator login, do not use it routinely. Instead, make system administrators members of the sysadmin fixed server role, and have them log on using their own logins. Use sa only when there is no other way to log in to an instance of Microsoft® SQL Server™ (for example, when other system administrators are unavailable or have forgotten their passwords)"







    **ASCII stupid question, get a stupid ANSI !!!**

  • July 17, 2005 at 8:05 am

    #575110

    THANK YOU VERY MUCH ! 

    My problem was that I was looking at the length and not testing it. I was testing an ASP.NET program and it kept telling me that it can not login to SQL Server. I created new login but noticed that the password is different than the one I put in (the length was different), not even testing it. I did not know that it always shows the pwd with the same length, even if it is blank ( which probably confused me the most ).

    Anyway I learn from my stupidity and will know to always test before I start panicing.

    Thanks again for your help !

    ID

  • July 17, 2005 at 10:21 am

    #575113

    Glad it got sorted out!







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 4 posts - 1 through 4 (of 4 total)

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