EEE Database Connection Error: Difference between revisions
From EnablerWiki
Jump to navigationJump to search
Created page with "When trying to login to EEE, you may be presented with this error <code>A connection to the SQL Server database could not be established SQL Server: <SQLSERVERNAME> Database: ..." |
No edit summary |
||
| Line 1: | Line 1: | ||
When trying to login to EEE, you may be presented with this error | When trying to login to EEE, you may be presented with this error | ||
< | <pre style="color:red">A connection to the SQL Server database could not be established | ||
SQL Server: <SQLSERVERNAME> | SQL Server: <SQLSERVERNAME> | ||
Database: EEE</pre> | |||
Database: EEE</ | |||
You may also see an error logged in the Windows Event Log on the SQL Server similar to the following: | You may also see an error logged in the Windows Event Log on the SQL Server similar to the following: | ||
< | <pre>Event Type: Failure Audit | ||
Event Source: MSSQL$ | |||
Event Source: MSSQL$ | Event Category: (4) | ||
Event ID: 18456 | |||
Event Category: (4) | Date: 16/05/2011 | ||
Time: 10:33:54 p.m. | |||
Event ID: 18456 | User: BANKS\APPSERVERNAME$ | ||
Computer: SQLSERVERNAME | |||
Date: 16/05/2011 | Description: | ||
Login failed for user 'DOMAIN\APPSERVERNAME$'. [CLIENT: <IP Address of app server>]</pre> | |||
Time: 10:33:54 p.m. | |||
User: BANKS\APPSERVERNAME$ | |||
Computer: SQLSERVERNAME | |||
Description: | |||
Login failed for user 'DOMAIN\APPSERVERNAME$'. [CLIENT: <IP Address of app server>]</ | |||
Revision as of 10:58, 16 May 2011
When trying to login to EEE, you may be presented with this error
A connection to the SQL Server database could not be established SQL Server: <SQLSERVERNAME> Database: EEE
You may also see an error logged in the Windows Event Log on the SQL Server similar to the following:
Event Type: Failure Audit Event Source: MSSQL$ Event Category: (4) Event ID: 18456 Date: 16/05/2011 Time: 10:33:54 p.m. User: BANKS\APPSERVERNAME$ Computer: SQLSERVERNAME Description: Login failed for user 'DOMAIN\APPSERVERNAME$'. [CLIENT: <IP Address of app server>]
This error can be caused when the EEE Web Application is not using the correct IIS Application Pool on the App Server, or is using the incorrect EEEServices login details.
Update IIS to
