EEE Reports request Windows username and password - Revision history

Robert at 00:03, 27 February 2009

2009-02-27T00:03:32Z

← Older revision		Revision as of 00:03, 27 February 2009
Line 21:		Line 21:
	# Search for the EEEServices account (all one word) and select		# Search for the EEEServices account (all one word) and select
	# Enter the EEEServices account password (Contact Magenta Retail if this is unknown)		# Enter the EEEServices account password (Contact Magenta Retail if this is unknown)
	# Click OK, and re-enter the EEEServices account password		# Click OK, and re-enter the EEEServices account password. Click OK to confirm and exit back to the IIS console
			# Save the configuration to disk
			## Right Click the Servername in the IIS console
			## Select All Tasks
			## <nowiki>Select 'Save configuration to disk'</nowiki>
			## Click OK to continue
	# Restart the IIS Services		# Restart the IIS Services
	## Right Click the Servername in the IIS console		## Right Click the Servername in the IIS console

Robert at 04:31, 17 February 2009

2009-02-17T04:31:22Z

← Older revision		Revision as of 04:31, 17 February 2009
Line 33:		Line 33:


	See Also:		==See Also:==

Robert at 04:30, 17 February 2009

2009-02-17T04:30:50Z

← Older revision		Revision as of 04:30, 17 February 2009
Line 23:		Line 23:
	# Click OK, and re-enter the EEEServices account password		# Click OK, and re-enter the EEEServices account password
	# Restart the IIS Services		# Restart the IIS Services
			## Right Click the Servername in the IIS console
	# Right Click the Servername in the IIS console		## Select All Tasks
	# Select All Tasks		## Select Restart IIS...
	# Select Restart IIS...		## <nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>
	# <nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>		## Click OK
	# Click OK		## Click End if you wish to restart the services immediately
	# Click End if you wish to restart the services immediately

	Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.		Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.

Robert at 04:30, 17 February 2009

2009-02-17T04:30:31Z

← Older revision		Revision as of 04:30, 17 February 2009
Line 23:		Line 23:
	# Click OK, and re-enter the EEEServices account password		# Click OK, and re-enter the EEEServices account password
	# Restart the IIS Services		# Restart the IIS Services
	## Right Click the Servername in the IIS console
	## Select All Tasks		# Right Click the Servername in the IIS console
	## Select Restart IIS...		# Select All Tasks
	## <nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>		# Select Restart IIS...
	## Click OK		# <nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>
	## Click End if you wish to restart the services immediately		# Click OK
			# Click End if you wish to restart the services immediately

	Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.		Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.


			See Also:

Robert at 04:27, 17 February 2009

2009-02-17T04:27:43Z

← Older revision		Revision as of 04:27, 17 February 2009
Line 23:		Line 23:
	# Click OK, and re-enter the EEEServices account password		# Click OK, and re-enter the EEEServices account password
	# Restart the IIS Services		# Restart the IIS Services

	## Right Click the Servername in the IIS console		## Right Click the Servername in the IIS console
	## Select All Tasks		## Select All Tasks

Robert at 04:00, 17 February 2009

2009-02-17T04:00:06Z

← Older revision		Revision as of 04:00, 17 February 2009
Line 24:		Line 24:
	# Restart the IIS Services		# Restart the IIS Services

	# Right Click the Servername in the IIS console		## Right Click the Servername in the IIS console
	# Select All Tasks		## Select All Tasks
	# Select Restart IIS...		## Select Restart IIS...
	# <nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>		## <nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>
	# Click OK		## Click OK
	# Click End if you wish to restart the services immediately		## Click End if you wish to restart the services immediately

	Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.		Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.

Robert at 03:58, 17 February 2009

2009-02-17T03:58:35Z

← Older revision		Revision as of 03:58, 17 February 2009
Line 24:		Line 24:
	# Restart the IIS Services		# Restart the IIS Services

	# a. Right Click the Servername in the IIS console		# Right Click the Servername in the IIS console
	# Select All Tasks		# Select All Tasks
	# Select Restart IIS...		# Select Restart IIS...

Robert at 03:57, 17 February 2009

2009-02-17T03:57:58Z

← Older revision		Revision as of 03:57, 17 February 2009
Line 24:		Line 24:
	# Restart the IIS Services		# Restart the IIS Services

	Right Click the Servername in the IIS console		# a. Right Click the Servername in the IIS console
			# Select All Tasks
	Select All Tasks		# Select Restart IIS...
			# <nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>
	Select Restart IIS...		# Click OK
			# Click End if you wish to restart the services immediately
	<nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>

	Click OK

	Click End if you wish to restart the services immediately


	Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.		Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.

Robert at 03:56, 17 February 2009

2009-02-17T03:56:18Z

← Older revision		Revision as of 03:56, 17 February 2009
Line 1:		Line 1:
			Created: 17 February 2009. Last Reviewed: 17 February 2009

	Some Microsoft updates to SQL Server 2005 and Reporting Services reset the Anonymous Access option on the ReportServer webpage in IIS. This results in EEE users being prompted to enter a Windows username and password when running EEE Reports.		Some Microsoft updates to SQL Server 2005 and Reporting Services reset the Anonymous Access option on the ReportServer webpage in IIS. This results in EEE users being prompted to enter a Windows username and password when running EEE Reports.

Line 8:		Line 10:


	On the SQL Database Server, open the IIS console (Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Console)		# On the SQL Database Server, open the IIS console (Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Console)
			# Expand Websites
			# Expand Default Web Site (assuming the default website was used during install)
	Expand Websites		# Right Click 'ReportServer'
			# Select Properties
			# Select the Directory Security tab
	Expand Default Web Site (assuming the default website was used during install)		# Click the Edit button under the 'Authentication and access control' section
			# Tick the option 'Enable anonymous access'
			# Click the Browse button
	Right Click 'ReportServer'		# Search for the EEEServices account (all one word) and select
			# Enter the EEEServices account password (Contact Magenta Retail if this is unknown)
			# Click OK, and re-enter the EEEServices account password
	Select Properties		# Restart the IIS Services


	Select the Directory Security tab


	Click the Edit button under the 'Authentication and access control' section


	Tick the option 'Enable anonymous access'


	Click the Browse button


	Search for the EEEServices account (all one word) and select


	Enter the EEEServices account password (Contact Magenta Retail if this is unknown)


	Click OK, and re-enter the EEEServices account password


	Restart the IIS Services

	Right Click the Servername in the IIS console		Right Click the Servername in the IIS console

Robert: New page: Some Microsoft updates to SQL Server 2005 and Reporting Services reset the Anonymous Access option on the ReportServer webpage in IIS. This results in EEE users being prompted to enter a W...

2009-02-17T03:34:44Z

New page: Some Microsoft updates to SQL Server 2005 and Reporting Services reset the Anonymous Access option on the ReportServer webpage in IIS. This results in EEE users being prompted to enter a W...

New page

Some Microsoft updates to SQL Server 2005 and Reporting Services reset the Anonymous Access option on the ReportServer webpage in IIS. This results in EEE users being prompted to enter a Windows username and password when running EEE Reports.

An example update is KB960089.

To resolve this issue, the anonymous access has to be re-applied, and the EEEServices username and password specified.

On the SQL Database Server, open the IIS console (Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Console)

Expand Websites

Expand Default Web Site (assuming the default website was used during install)

Right Click 'ReportServer'

Select Properties

Select the Directory Security tab

Click the Edit button under the 'Authentication and access control' section

Tick the option 'Enable anonymous access'

Click the Browse button

Search for the EEEServices account (all one word) and select

Enter the EEEServices account password (Contact Magenta Retail if this is unknown)

Click OK, and re-enter the EEEServices account password

Restart the IIS Services

Right Click the Servername in the IIS console

Select All Tasks

Select Restart IIS...

<nowiki>Ensure 'Restart Internet Services on <SERVERNAME>' is selected</nowiki>

Click OK

Click End if you wish to restart the services immediately

Test that reports run as expected in EEE. You should no longer be prompted for a Windows Username and password.