up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
I fixed problem. – Aram Gevorgyan May 1 '11 at 16:03
feedback

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

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

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?

link|improve this answer
@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
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
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
feedback

Your Answer

 
or
required, but never shown
discard

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