nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Unable to access the SQL database with sa,

JamalNUMAN

I couldn’t figure out why I’m not able any longer to access my SQL database with sa knowing that the password is not changed and the option of expiration is not check.

I tried to access it with other user (montaser) and it works fine!

Is there any chance that the password of the sa is change accidentally?

What other issues should I consider?

Is there any way to change the password of the sa?

Thank you

Best

Jamal

Trouver plus de publications taguées avec

Accepted answers

AsrujitSengupta

Uncheck those two options and try again.

All comments

JamalNUMAN

Thank you very much Asrujit for the help. It works like a charm

Best

Jamal

AsrujitSengupta

Uncheck those two options and try again.

ScottDean

This is because the account has picked up either local or domain policies. You can change this policy by specifying CHECK_POLICY = OFF, make the change and then turn this back on.

JamalNUMAN

Many thanks Scott,

I got a help from SQL database expert and he could resolve the issue (restoring the password of the Sa). I’m not sure which method he sued.

Now, I wanted to change the password of the sa to ensure better security but I got the message below

What might be the issue here?

ScottDean

Are you able to log into SQL MS with the SA account? If so then your password is not the issue. If not then obviously the password was changed and unless you have another account with SysAdmin then I don't think you can change it. In the event that you cannot determine the password nor the ability to change it you can try the back door mentioned below.

SQL Server lets any member of a Local Administrators group connect to SQL Server with SYSADMIN privileges.

http://technet.microsoft.com/en-us/magazine/jj853293.aspx

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.