EEE Database Connection Error - Revision history

Robert at 11:20, 16 May 2011

2011-05-16T11:20:39Z

← Older revision		Revision as of 11:20, 16 May 2011
Line 1:		Line 1:
			Created: 16 May 2011. Last Reviewed: 16 May 2011
	__NOTOC__		__NOTOC__
	===Error Details===		===Error Details===

Robert at 11:19, 16 May 2011

2011-05-16T11:19:32Z

← Older revision		Revision as of 11:19, 16 May 2011
Line 1:		Line 1:
			__NOTOC__
	===Error Details===		===Error Details===
	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

Robert at 11:16, 16 May 2011

2011-05-16T11:16:39Z

← Older revision		Revision as of 11:16, 16 May 2011
Line 1:		Line 1:
			===Error Details===
	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

Line 21:		Line 22:

	===How to fix===		===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 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 → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager)		# Open IIS Manager (Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager)
	# Expand Websites		# Expand Websites
Line 34:		Line 38:
	# Click OK and re-enter the EEEServices password when prompted		# Click OK and re-enter the EEEServices password when prompted

	Update the EEE webpage to use the ASP.Net application pool, EEEAppPool.		=====Update the EEE Application Pool Authenticaion details=====
			# Open IIS Manager (Start → Control Panel → Administrative Tools → 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 → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager)		# Open IIS Manager (Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager)
	# Expand Websites		# Expand Websites
Line 41:		Line 55:
	# On the Virtual Directory tab, set the Application Pool to EEEAppPool		# On the Virtual Directory tab, set the Application Pool to EEEAppPool
	# Click OK to save		# Click OK to save

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

Robert at 11:09, 16 May 2011

2011-05-16T11:09:08Z

← Older revision		Revision as of 11:09, 16 May 2011
Line 20:		Line 20:
	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.		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~~'''~~		===How to fix===

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

Robert at 11:08, 16 May 2011

2011-05-16T11:08:42Z

← Older revision		Revision as of 11:08, 16 May 2011
Line 24:		Line 24:
	Update IIS to use the correct EEEServices login details for both the EEE webpage and EEE ASP.Net application pool.		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.		# Open IIS Manager (Start → Control Panel → Administrative Tools → 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 webpage to use the ASP.Net application pool, EEEAppPool.
			# Open IIS Manager (Start → Control Panel → Administrative Tools → 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

Robert at 11:01, 16 May 2011

2011-05-16T11:01:05Z

← Older revision		Revision as of 11:01, 16 May 2011
Line 18:		Line 18:
	Login failed for user 'DOMAIN\APPSERVERNAME$'. [CLIENT: <IP Address of app server>]</pre>		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'''

	~~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 use the correct EEEServices login details for both the EEE webpage and EEE ASP.Net application pool.


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

Robert at 10:58, 16 May 2011

2011-05-16T10:58:49Z

← Older revision		Revision as of 10:58, 16 May 2011
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

	<~~code~~>A connection to the SQL Server database could not be established		<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</~~code~~>

	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:

	<~~code~~>Event Type: Failure Audit		<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>]</~~code~~>

Robert: Created page with "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: Database: ..."`


2011-05-16T10:51:38Z
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: ..."
New page
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: EEE</code>



You may also see an error logged in the Windows Event Log on the SQL Server similar to the following:



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







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

EEE Database Connection Error - Revision history

Robert at 11:20, 16 May 2011

Robert at 11:19, 16 May 2011

Robert at 11:16, 16 May 2011

Robert at 11:09, 16 May 2011

Robert at 11:08, 16 May 2011

Robert at 11:01, 16 May 2011

Robert at 10:58, 16 May 2011

Robert: Created page with "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: Database: ..."

Robert: Created page with "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: Database: ..."`