Search This Blog

Friday, September 10, 2010

MS GP: How to unlock a user in SQL?


Go to SQL Managemnt Studio -> Security -> User -> Properties -> Status
Uncheck lock box

1 comment:

  1. Hi Yulia,
    This wont work if you make usage in Dynamics GP of the enforced security policy... Then the domain policy takes precedence and you get errors when trying to do this. You've to login as sysadmin in GP first to disable the enforced security and then reset the password from there.
    Have a great day,
    Beat
    PS: Sorry to no be @ Convergence 2011 this year, I see that you met my friends Mariano & David.

    ReplyDelete