EP5 Web Client displays error box, "Critical Error has Occured" after login
Problem:
EP5 Web Client displays error box, "Critical Error has Occured" after login.
The event viewer shows an Error Event reading:
Event ID 100
An exception of type 'System.Data.SqlClient.SqlException' occured and was caught OR system error has occured
System.Data.SqlClient.SqlException:Invalid object name "cas_exception_editor_config".
The key is the failure to read the table "cas_exception_editor_config". This table contains the default settings for the Web Client, as well as any personal settings. An examination of the SQL database shows that the table "cas_exception_editor_config" exists and contains at least one record.
Solution:
The eqcas user has to have the eqcas database defined as their default database.
The core problem with EP5 Web Client in this case is that the eqcas user in the SQL server does not have eqcas database defined as the default database for this user. This setting may have changed when the firm's database was moved to the new SQL server. Setting this users default database to eqcas will resolve this issue with the Web Client.
How to change:
Connect to the SQL server with Microsoft SQL Server Management Studio
Expand Security, Logins
Right click on "eqcas" and select properties.
Toward the bottom of the screen, change the default database to "eqcas"
Click OK to save changes
Note: You may need to be connected to the SQL server with windows authentication while logged in as an administrator to change this setting.