October 1, 2007 at 12:34 am
Comments posted to this topic are about the item SS2K - sp_helprevlogin`
September 23, 2010 at 7:59 am
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
September 23, 2010 at 10:31 am
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)
You must be logged in to reply to this topic. Login to reply