Post reply

SS2K - sp_helprevlogin`

  • October 1, 2007 at 12:34 am

    #179474

    Comments posted to this topic are about the item SS2K - sp_helprevlogin`

  • September 23, 2010 at 7:59 am

    #1226333

    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

    #1226447

    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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy