Hi all I am administering TMG 2010 firewall in our office and for quiet couple of days I have been facing some problems I am not able to genrate the daily report on my firewall and SQL SERVER EXPRESS SERVICE IS NOT RUNNING I tried to do it manually but of no avail. I have installed tmg 2010 sp1 udpate only Alerts showing – SQL server Reporting service could not be configured for Forefront TMG job scheduler service may resolve this issue. Reporting services error info: connection failure. 2) The SQl server Express (MSFW) service could not open an Active Data objects connection for accessing the SQL Server express database for Microsoft forefront TMG firewall logging. SQL server Express service error description :Invalid connection string attribute ,(DBNETLIB) [Connection open(connect())] .SQL server doesnot exist or access denied. Connection to the sql server express database will be retrieved periodically until a connection is established log record will be saved in a log queueon the disk forefront tmg will continue to operate normally but the log records in the log queue will not be available in the Forefront TMG logs viewer after a connection to the sql server express database is established the logs records in the log queue will be moved to the sql server express database and will be available in the log viewer. Even caching is not working. showing error as cache log failure : failed to connect to database cacheperfCounters; this may interfere with cache utilization monitoring. The failure is due to error; A network related or instance specific error occured while establishing a conection to sql serer. The server was not found or was not accessible. Verifiy that the instance name is correct and that SQL server is configured to allow remote connections.(Provider share memmory provide, erro: 40 could not open a connection to sql server). I dont have much familiarity with SQL SERVER. Kindly give some tips. Rohan Gaur System Admin

This post is not related to SQL Server Reporting Services. I think the required SQL Server Express is not installed. You may need to review the procedure on installing the your Firewall product.Arthur My Blog

Hi Rohan, Thanks for your post. According to your description, your topic is related to Forefront TMG reports. So I would provide guidance for diagnosing and resolving issues that you may encounter when configuring and generating reports. Forefront TMG reports are based on log summaries that are derived from the web proxy and firewall logs. Using SQL Server reporting services, Forefront TMG generates log summaries on a daily, weekly or monthly basis. You can trouble shooting it through the following three sections: · Troubleshooting the reporting configuration · Troubleshooting report generation · Troubleshooting summary reports Thanks, Bill LuBill Lu TechNet Community Support