This is a list of all of the databases that need the WDD Account password updated on when it is updates.
- stage-web1
- mssql-db1.ec2.wddonline.net
- jobnet-sql.cf.ec2.wddonline.net
Here is a script to do it
USE c4_secure_sql
DECLARE @newPass AS VARCHAR(50)
SET @newPass = ''
UPDATE dbo.users
SET user_password = @newPass, PasswordExpires = DATEADD(dd,60,PasswordExpires)
WHERE user_id = 1
2. update password in LastPass
3. send an email to staff@wddonline.com to notify WDD.
Article ID: 370, Created: July 27, 2015 at 10:33 AM, Modified: September 13, 2017 at 4:16 PM