Change WDD C4 Password

C4 Accounts and Admin
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
  • cfpt1.cedarfair.com
 
 
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

Add Feedback