Share via

How to disable SQL server 2012 sa password auto reset

  • Article

Question

Friday, January 9, 2015 8:23 AM

We have SQL server 2012 in windows xp and we using sa login and password as null.

My problem is the password automatically reset within 3 hours once,

Anyone can help how to disable the automatically reset password or how to increase the reset time.

Thanks..!!!

All replies (6)

Friday, January 9, 2015 8:57 AM ✅Answered

My problem is the password automatically reset within 3 hours once,

SQL Server never changes any password, someone else is doing this. And it is a high risk to use SA account especially with an empty password!!!

Olaf Helper

[ Blog] [ Xing] [ MVP]

Friday, January 9, 2015 9:27 AM ✅Answered

SQL by itself doesn't change the password, however It is possible that the password policy is being enforced thru Policy Management feature by a central admin. You may need to find out more from the DBA team or a server management teams (depends on your org) to find out such cases

http://msdn.microsoft.com/en-IN/library/ms161959.aspx

Satheesh
My Blog | How to ask questions in technical forum

Friday, January 9, 2015 10:06 PM ✅Answered

SQL Server never changes any password, someone else is doing this. And it is a high risk to use SA account especially with an empty password!!!

Fully agree. A blank password for sa? In 2015?

Apparently something in your environment pokes around for server instances with blank sa passwords and teaches you a lesson. You could set up an event notification or a DDL trigger to find out that may be. Or just prove that you are smarter than them by renaming sa. Or even better, prove that you are living in the present and set a strong password for sa. Or even better, disable sa, and only use Windows accounts that are in sysadmin so that you know how did what.

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Friday, January 9, 2015 8:43 AM

How come you was able to set this password as null? It's either username and password or windows authentication.

Fouad Roumieh

Friday, January 9, 2015 8:51 AM

we only set the password as null

Friday, January 9, 2015 9:24 AM

so your password is null as text and not as null empty?

Fouad Roumieh