February 23, 2009 at 4:41 am
The developer has installed a test database on a server (before I knew about it). He put the installation into SQL and Windows authentication and then disabled the 'sa' account. I think the password is probably still blank.
However if I now enable the account, enter a password and then disable the account again, what affect will that have? He's concerned that any member of the IT team can change the password again; I have explained that this is already the situation.
Madame Artois
February 23, 2009 at 10:43 am
No effect. If you disable it, it will be the same as now, same password or now.
February 24, 2009 at 5:48 am
Steve is right. The sa account can have any password without impaqcting on how SQL Server operates.
Anyone who has sysadmin authority can change the password of the sa account. If you do not want someone to change this password than make sure they do not have sysadmin authority.
The DAC can be used regardless of if the sa account is disabled.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 25, 2009 at 5:01 am
Thanks for the help guys.
I'll speak to the develeloper but I fear I may be back
Madame Artois
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply