Comments posted to this topic are about the item SS2K - sp_helprevlogin`
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
This scripit will not work with
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
I did a test I have a login that I know the password to.
Run the sripit get the output create user on above machine try to login will not except the password.
When I take same out put and run scripit on a 2005 instance password works fine as you would expect.
So something is not the same with login increption going from 2005 to 2008 R2
Found out what the true problem was I didn't have the authentification mode set to windows auth only.
After that was able to get the passwords to work correctly..
Doh I hate these types of fixes I was sure I choose the correct option on setup...
Viewing 3 posts - 1 through 2 (of 2 total)