EEE Reports request Windows username and password: Difference between revisions
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... |
No edit summary |
||
| 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 | ||
Revision as of 03:56, 17 February 2009
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.
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...
Ensure 'Restart Internet Services on <SERVERNAME>' is selected
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.
