How do you delete and re-add the database adapter for RSA Data Security Manager?
Originally Published: 2007-12-05
Article Number
Applies To
Microsoft Windows Server 2003 SP1
Microsoft SQL Server 2000
Issue
Resolution
Here is what needs to be done.
Go to the Adapter Manager
Decrypt all the columns that are encrypted
Remove all roles from Security->Policy Manager
Right Click on the Adapter and choose Remove
If this gives an error, click OK and then click on Yes in the next.
Close the Adapter Manager
On the database server, you have to do the following.
Open Management Studio or Enterprise Manager
Go to the Master Database
Drop all VDSA* tables
Drop all VKS* or VDS* extended stored procedures, functions, views etc
Drop VDSUSR users from the databases (mainly Master, better to check the others)
Drop VDSUSR login
Finally, you can uninstall the Adapter Manager from the Control Panel -> Add/Remove Programs.
Note:
Decrypt all the columns that are encrypted
Remove all roles from Security->Policy Manager
Right Click on the Adapter and choose Remove
If this gives an error, click OK and then click on Yes in the next.
Close the Adapter Manager
On the database server, you have to do the following.
Open Management Studio or Enterprise Manager
Go to the Master Database
Drop all VDSA* tables
Drop all VKS* or VDS* extended stored procedures, functions, views etc
Drop VDSUSR users from the databases (mainly Master, better to check the others)
Drop VDSUSR login
Finally, you can uninstall the Adapter Manager from the Control Panel -> Add/Remove Programs.
Note:
If Adapter is already configured, should never drop or delete the VDSUSR. Its always good to change the password. After password change at the database, you need to recover the Adapter from the Adapter Manager. At that time it will ask for the new password.
Deleting the user means, all grants on the MS SQL Master database objects are lost and you need to grant them manually. Also DBSM will not recreate the user if it finds any DBSM objects in the Master database. Clean up here means you are starting from scratch.
Related Articles
RSA Authentication Manager Displays Unwanted Certificate Signing Requests (CSRs) in the Operations Console Certificate Man… Number of Views The documentation for enabling the RSA Database Security Manager adapter for SQL Server 2005 discusses the requirement for… Number of Views On RSA Via Lifecycle and Governance the aveksa_server start returns message: Cannot connect to the database, but the DB is up Number of Views Integrating Vormetric Data Security Manager with RSA Authentication Manager 8.x Number of Views How to install RSA Access Manager SQL data adapter on Microsoft SQL Server 2005 Number of Views
Trending Articles
RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide How to Download OTP Token Seed Files from myRSA RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide Module "SecurIDModule" could not be found message displayed in the web browser
Don't see what you're looking for?
