"The ease of use and implementation were key to our decision to move ahead with FileHold."
- Engineering Customer
Reporting with Windows Authentication in the Document Management Software
Reporting with Windows Authentication
FileHold Technical support can provide a document that gives step by step instructions in how to configure SQL Server 2005 or 2008 Reporting Services and the FileHold Reporting system. You will use your FH_Service account that runs the FileHold Server Application. You will be using Windows Authentication to integrate SQL Reporting services with FileHold Server and the FileHold databases.
This document assumes that IIS and SQL Standard or Enterprise are on the same Windows Server that is running the FileHold Web Server Application.
We do not provide advice if IIS and SQL 2005/2008 are on separate servers as there are many considerations in the areas of IT security and technical configuration best practices.
You will want to ensure that Windows Integrated security for report data source connections is set in SQL 2005 Surface Area Configuration > For Features if you are using SQL 2005, and that you have taken appropriate steps if using SQL 2008.
Requirments to Complete this Process:
o Windows 2003 R2 with Service Pack 2.
OR
o Windows 2008 with SP1 x64 or Windows 2008 R2 x64
o SQL 2005 Express or Standard or Enterprise with reporting services installed and configured
o SQL 2005 Service Pack 2 or 3 has been successfully applied to all aspects of your SQL Server installation.
OR
o SQL 2008 with SP1 with reporting services installed and configured
o SQL 2008 R2 with reporting services installed and configured
o We recommend that you install an SSL certificate for the web server before beginning this so that reporting services can be run under SSL. We do not provide instructions on how to do this within this document.
Please email support@filehold.com for the latest version of the package you will need to set up SQL Reporting Services integration with FileHold.
This package contains several sample report definition files (RDL) for Library reporting and User reporting. These are the two most common reports requested by FileHold customers. You can create other reports as needed, or FileHold consulting can create them for you at an additional cost.

