SQL Server Error: 4060 Access to selected database has been denied

SQL Server Error: 4060 Access to selected database has been denied

Microsoft SQL Server Login
Connection failed:
SQLState: '08004'
SQL Server Error: 4060

Server rejected the connection; Access to selected database has been denied.

 

Root Cause: The Database Vendor is Microsoft SQL server, and the error code is a Microsoft SQL error code.

Microsoft support information about error code 4060 is this: "Server rejected the connection; Access to selected database has been denied"

This SQL error would indicate the SQL login or logins used by the Servicing Director applications have not been granted the proper access rights and permissions to the Service database.

All Servicing Director applications initially login as the SQL login named "LoanServicing".

The logins for the Servicing Director applications are installed automatically by the Servicing Director Database installation program, and the logins will have the proper access rights and permissions maintained with each upgrade.  

Normal use of the Servicing Director applications does not change the login access or permissions. 

Therefore, contact your local IT to review changes made outside of the product to the login access rights or permissions, such has moving servers or restoring databases. 


Workaround:

Run the Servicing Director LSCNFG application, which is installed on the Servicing Director SQL server, and run it specifically with the Run Fixrights option to recreate both the Reports and LoanServicing logins, and the associated access rights and permissions. For more information about running LSCNFG, review Changing the Servicing Director SQL Login Passwords

ArticleNumber:

000039132