When a user uses SQL Server authentication for the "Access Credentials and Database Creation Login Credentials wizards during configuration and provides a password that uses a semi-colon at the end, clicking the Test Connection button to validate the account results in StoragePoint raising an error, stating An error occurred: Login failed for user sqluser.
Blobs are not archived when the Metadata Change Rule Condition is Content Property = Folder when creating new folders in a Storage Profile.
If a user has moved CDB on to another SQL instance with a different SMK (service master key), the connection between the SMK and DMK will be broken. To work correctly (e.g. a STP upgrade) with those CDBs, StoragePoint needs to regenerate the DMK with the following SQL query:
OPEN MASTER KEY DECRYPTION BY PASSWORD = '<DMK password>'; -- password used to protect DMK on previous/source SQL instance
ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = '<new or the same DMK password>'; -- could be used the same password but this one will be "secured" by target SQL instance SMK
CLOSE MASTER KEY;
You do not need to regenerate DMK if CDB does not have DMK or if the existing DMK is working correctly.
Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Office 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now. Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat. Quest Software. Where next meets now. For more information, visit www.quest.com.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center