Field level security is not working after sa password changed

(0) Share

Report

Posted on by Nias Kasim

125

Hi ,

Recently we changed sql server sa password .After that Field level security stopped working. We are using dex customization and vba customization. After the sa password change sa account got locked due to wrong password . please help.

Thanks in advance

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Field level security is not working after sa password changed

Great answer Keat2008,

Nias, If you change the password back does everything work? If it does, look at the services as Keat suggested, and check out anyplace in your code where you may have hard-coded the password.

Kind regards,

Leslie
Community Member on at

Like (0)

Report

RE: Field level security is not working after sa password changed

Have you been able to recover the sa account? You probably have some services that were try to login as sa but couldn't because the password changed. They then locked out the sa password. Check your services and see if anything is trying to login as sa and update the password.