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
Error 'Autogen not enabled for: DefaultKeyClass' when trying to get a key 11Number of Views Getting 'Request Error : The request could not be handled' error when trying to access requests in RSA Identity Governance… 47Number of Views Error 'HTTP/1.1 403 Forbidden' when trying to get a key 39Number of Views How to get more verbose logs for CMP Server in RSA Certificate Manager 39Number of Views AADSTS50107: Requested federation realm object 'http:/<Identity Router FQDN>/' does not exist when trying to access the Mi… 53Number of Views
Trending Articles
How to download and install the AFX Server Archive in RSA Identity Governance & Lifecycle RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide The Template ({Connector Template Name}) has missing file content error when creating AFX Connectors in RSA Identity Gover… Downloading RSA Authentication Manager license files or RSA Software token seed records Troubleshooting RSA MFA Agent for Microsoft Windows