June 21, 2009 at 5:10 pm
I thought I read that under sql 2008 one should NOT change the "sa" password by right-clicking the account (under SSMS) and updating it there. There was some concern that encrypted data may become unavailable. ?? (Server Master key, database master key ??? I'm not sure).
How would you change the "sa" password?
TIA,
barkingdog
June 21, 2009 at 7:28 pm
I'm not sure if that happens but this is how you change a password.
ALTER LOGIN sa WITH
PASSWORD = 'new_password'
June 22, 2009 at 2:53 am
Your post is the first time I have heard about problems changing the sa password by using the GUI.
Can you post your reference that said this? I think someone may be giving out wrong information.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply