RSA File Security Manager (FSM)
Microsoft Windows 2003 Server SP3
Microsoft SQL Server
Getting this error when user log son to the box as with their username
FSM Adapter Manager can not access the database
User account does not have access to the MS SQL database
When FSM was configured, Windows Authentication was used. The account used to setup FSM had access to the MS SQL database, but the user logon account doesn't.
The user's logon account must also be setup to have access the MS SQL database used by FSM, or change the FSM configuration to user a database account instead.
From the FSM Manager guide:
**** If using Windows Authentication to connect to the SQL Server database
Before you create the data store account using Windows authentication mode, The NT User must be added to security logins in SQL Server Management Studio. To add NT User to security logins, see Appendix A
In this mode, you need not specify a user name and password to connect to SQL Server database. Your access to the database is controlled by the Windows account that you use to login to your machine.
Related Articles
AM7.1 Unable to install a patch: The installer was unable to set required configuration data. 25Number of Views Why don't my replies via email appear on RSA Community discussion threads? 6Number of Views Getting 'Request Error : The request could not be handled' error when trying to access requests in RSA Identity Governance… 49Number of Views UI not reachable on port 443 in RSA Governance & Lifecyle Virtual Application 119Number of Views Error message of passwd had "2" usages of 0, but expected 1, when installing RSA Identity Governance & Lifecycle 34Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process