Problem:
If you encounter the following error when attempting to login to the PSIsafe Client or the Management Console "Cannot open database "[DB_NAME]" requested by the login. The login failed. Login failed for user 'sa' as in this screenshot:
(screenshot)
Sometimes, due to a variety of reasons, including but not limited to:
- Maintenance
- Power Outage
- Recent sa user account password change
- Recent DB upgrade to new SQL version
A DB will enter an offline mode and display (Recovery Pending) addended to the DB name in SSMS.
Solution:
To resolve this issue, usually, simply requires executing the following query on the DB from SSMS:
ALTER DATABASE MX_MSCRM SET ONLINE
This should resolve your issue by bringing the DB online (if no other serious damage has occured or changes been made, if this solution does not work, consider recovery efforts by restoring the most recent backup).
Comments
Please sign in to leave a comment.