EEE Database Connection Error

From EnablerWiki

Created: 16 May 2011. Last Reviewed: 16 May 2011

Error Details

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

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

1. Open IIS Manager (Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager)
2. Expand Websites
3. Expand the website that hosts the EEE web interface (Default Web Site)
4. Right click EEE and click Properties
5. Click the Directory Security Tab
6. Click the Edit button under the Authentication and access control heading
7. Tick Enabler anonymous access
8. Enter the username and password for the EEEServices account
9. Click OK and re-enter the EEEServices password when prompted

Update the EEE Application Pool Authenticaion details

1. Open IIS Manager (Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager)
2. Expand Application Pools
3. Right click EEEAppPool and click Properties
4. Click the Identity Tab
5. Tick Configurable
6. Enter the username and password for the EEEServices account
7. Click OK and re-enter the EEEServices password when prompted

Solution 2

Update the EEE webpage to use the ASP.Net application pool, EEEAppPool.

1. Open IIS Manager (Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager)
2. Expand Websites
3. Expand the website that hosts the EEE web interface (Default Web Site)
4. Right click EEE and click Properties
5. On the Virtual Directory tab, set the Application Pool to EEEAppPool
6. Click OK to save

See Also

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