View source for EEE Database Connection Error

__NOTOC__
===Error Details===
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>
Database: EEE</pre>

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 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>]</pre>

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===
You may have to apply one or both of the solutions below

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

=====Update the EEE Web Page Authentication details=====
# Open IIS Manager (Start &rarr; Control Panel &rarr; Administrative Tools &rarr; Internet Information Services (IIS) Manager)
# Expand Websites
# Expand the website that hosts the EEE web interface (Default Web Site)
# Right click EEE and click Properties
# Click the Directory Security Tab
# Click the Edit button under the Authentication and access control heading
# Tick Enabler anonymous access
# Enter the username and password for the EEEServices account
# Click OK and re-enter the EEEServices password when prompted

=====Update the EEE Application Pool Authenticaion details=====
# Open IIS Manager (Start &rarr; Control Panel &rarr; Administrative Tools &rarr; Internet Information Services (IIS) Manager)
# Expand Application Pools
# Right click EEEAppPool and click Properties
# Click the Identity Tab
# Tick Configurable
# Enter the username and password for the EEEServices account
# Click OK and re-enter the EEEServices password when prompted

====Solution 2====
=====Update the EEE webpage to use the ASP.Net application pool, EEEAppPool. =====
# Open IIS Manager (Start &rarr; Control Panel &rarr; Administrative Tools &rarr; Internet Information Services (IIS) Manager)
# Expand Websites
# Expand the website that hosts the EEE web interface (Default Web Site)
# Right click EEE and click Properties
# On the Virtual Directory tab, set the Application Pool to EEEAppPool
# Click OK to save

==See Also==
http://msdn.microsoft.com/en-us/library/ab4e6cky.aspx