Another quick post: if you find that when you try to apply updates to a DRM application the utility times out trying to connect to the database, make sure there isn't an "@" sign in the database user's password!
Encountered this strange issue recently, hope it helps someone!
Wednesday, 22 July 2015
DRM Admin Password Expiry Fix
I realise I haven't done a blog post in a while, unfortunately work has been super busy recently, so I decided to drop a quick tip here.
I have had issues with the DRM admin password expiring. This is obviously not a situation anyone wants and it seems that DRM ignores the "no password expiry" option as well. The only fix I have found is running the SQL script below:
UPDATE [DRM].[dbo].[RM_User]
SET [d_password_expire_date] = '2035-01-01 01:01:01.00'
,[b_exclude_from_timeout] = 1
,[b_no_password_expiration] = 1
,[b_exclude_from_lockout] = 1
WHERE c_user_name = 'ADMIN'
GO
I have had issues with the DRM admin password expiring. This is obviously not a situation anyone wants and it seems that DRM ignores the "no password expiry" option as well. The only fix I have found is running the SQL script below:
UPDATE [DRM].[dbo].[RM_User]
SET [d_password_expire_date] = '2035-01-01 01:01:01.00'
,[b_exclude_from_timeout] = 1
,[b_no_password_expiration] = 1
,[b_exclude_from_lockout] = 1
WHERE c_user_name = 'ADMIN'
GO
Obviously altering the name of the DRM database for your own.
Subscribe to:
Posts (Atom)