EEE Database Connection Error

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.

How to fix

Update IIS to use the correct EEEServices login details for both the EEE webpage and EEE ASP.Net application pool.

Update the EEE webpage to use the correct ASP.Net application pool.