How IIS queries are handled for FSSMC jobs
Submitted by Paul Gruner - Microsoft
Symptoms=============================
When sending web-based reports in Microsoft Forefront Server Security Management Console (FSSMC), you might receive following error: The GenerateAndSendReport function returned an error.
Cause
=============================
When creating the first job in FSSMC, IIS is queried to check if authentication is enabled for FSSMC.
There are two possibilities:
1) If authentication is enabled, we set the default URL used for all web-based reports to https://localhost/FSSMConsole/
2) If authentication is not enabled, we set the default URL used for all web-based reports http://localhost/FSSMConsole/
Any following jobs created in FSSMC, will use this default URL. FSSMC does not query IIS anymore in order to verify if any changes to the security settings have been implemented.
Resolution
=============================
The default URL for web-based reports is stored in SQL. The value containing the default URL is called SemURL, the database is called SybariEnterpriseManager and the table is called dbo.sdSettings.
There are two established workarounds:
1) Install Microsoft SQL Server Management Studio Express (SSMSE), and edit the SemURL value directly in the dbo.sdSettings table in SQL. In order to access this table, you can download a free copy of SSMSE from following location: http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
2) After making changes to the FSSMC security settings in IIS, delete all existing jobs and recreate them. This will force FSSMC to query the security settings of IIS again, upon the creation of the first job.
Repro Steps
=============================
- Disable authentication in IIS for FSSMC
- Create the first job in FSSMC
- Enable authentication in IIS for FSSMC
- Create a second job in FSSMC and send a web-based report for this job.
More Information
=============================
This is a known issue and won't be fixed in a future release.
References
=============================
Microsoft Forefront Server Security Management Console Version: 10.5.1241.0
