Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have sql server 2008 R2. Everytime I create new sql server authorization login, whatever password I write it was changed to unknown me 15 characters password. Same is for sa. So I can't lofin with sql server authorization.I login with windows authorization and I have sysadmin permissions. How can I fixed that?

share|improve this question

migrated from stackoverflow.com Apr 30 '11 at 5:47

This question came from our site for professional and enthusiast programmers.

    
I fixed problem. –  Aram Gevorgyan May 1 '11 at 16:03
add comment

1 Answer

up vote 0 down vote accepted

Make sure Enforce Password Policy is not enabled

In other words

CREATE LOGIN loginName WITH PASSWORD = '<enterStrongPasswordHere>', 
CHECK_POLICY = OFF;

Also is SQL Server running in Mixed Mode?

share|improve this answer
1  
@SQLMenace : yes it is not enabled, but I have this problem. –  Aram Gevorgyan Apr 27 '11 at 16:52
    
what is the exact error? –  SQLMenace Apr 27 '11 at 16:53
1  
it has no errors it exacts succesfully, but then when I click on login it shows some 15 character password. –  Aram Gevorgyan Apr 27 '11 at 16:55
    
so change it to what you think the password is and then login –  SQLMenace Apr 27 '11 at 16:56
1  
this is my problem. when I try changing and click ok, my changes didn't saved. And when I try login it writes: –  Aram Gevorgyan Apr 27 '11 at 16:58
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.