Introduction



Database and Application DeploymentBackground Check SystemIT Deployment GuideVersion 01 SAVEDATE \@ "M/d/yyyy" \* MERGEFORMAT 2/19/2015Table of Contents TOC \o "1-2" \u 1Introduction PAGEREF _Toc411969868 \h 32BCS Hardware Requirements PAGEREF _Toc411969869 \h 43BCS Software Requirements PAGEREF _Toc411969870 \h 44Setting Up the BCS Platform PAGEREF _Toc411969871 \h 54.1Source Installation Package PAGEREF _Toc411969872 \h 54.2Microsoft .NET 4.0 Framework PAGEREF _Toc411969873 \h 54.3Internet Information Services (IIS) 7.x PAGEREF _Toc411969874 \h 54.4BCS Database PAGEREF _Toc411969875 \h 55Running the BCS Platform PAGEREF _Toc411969876 \h 65.1Visual Studio Professional 2010 SP1 Configuration PAGEREF _Toc411969877 \h 65.2Website Configuration PAGEREF _Toc411969878 \h 65.3Criminal Justice Information Services (CJIS) Enhancements PAGEREF _Toc411969879 \h 75.4Testing the Application PAGEREF _Toc411969880 \h 86Running the BCS Tasks Service PAGEREF _Toc411969881 \h 96.1BCS Tasks Service Installation PAGEREF _Toc411969882 \h 96.2BCS Tasks Service Configuration PAGEREF _Toc411969883 \h 106.3Uninstalling the BCS Tasks Service PAGEREF _Toc411969884 \h 10IntroductionThe Background Check System (BCS) platform is a Microsoft-based application that takes advantage of the .NET 4.0 Framework and SQL Server 2008 R2. This deployment guide is intended to instruct IT staff on how to deploy the BCS application and database on a single machine. Instructions are not intended to demonstrate best practices for establishing a secure production environment, which should be dictated by the policies and procedures set by your agency for your infrastructure.In order to understand the BCS platform deployment instructions provided within this document, the reader will need an understanding of the IT/coding concepts described in the following table.IT/Coding ConceptsDescriptionApplication C# application written in Visual Studio Professional 2010 with Service Pack 1 on the .NET Version 4 FrameworkDatabase SupportSQL Server 2008 R2 Service Pack 1 and database development, Transact-SQL (T-SQL) for configuration items and development, SQL JobsReporting DevelopmentSQL Server?Reporting Services (SSRS) 2008 R2Integration ServicesSQL Server Integration Services (SSIS) with Visual Studio 2010 being the platform to develop the packagesTask ServiceAn operational services component, written in C#/.NET 4.xInfrastructure/Operations/SecurityInternet Information Services (IIS) 7.x. To establish a website and Application Pool for the BCS platform to run under, this would include publishing the application to IIS, creating and properly securing a database connection, and updating configuration files for the website and task service.BCS Hardware RequirementsFor the BCS platform to run effectively, you must ensure that the machine on which BCS will be deployed meets or exceeds the requirements listed in the following table. (Note: The machine is not assumed to be a production grade server.)BCS Machine ComponentsMinimum RequirementProcessorMinimum 1GHz processor or equivalentOperating SystemWindows Server 2008 R2 (Recommended, preferred Service Pack 1); Windows Server 2008; Windows Server 2003; Windows 7; Windows 7 SP1Memory2GB-4GB (Recommended)Hard Disk20+ GB of available spaceAssumptionsInstallation user has local administrative privilegesBCS Software RequirementsThe machine to which the BCS will be deployed must have the following software in order to be compatible with the BCS platform:Visual Studio Professional 2010 with Service Pack 1SQL Server 2008 R2 with Service Pack 1; An SQL Developer license will suffice; SQL Standard is not required; Please refer to the “Database Installation” IT Deployment guide. Microsoft .NET 4.0 Framework; Please refer to the “.Net 4.0 Framework Verification” IT Deployment guide.Internet Information Services (IIS) 7.x; Please refer to the “IIS Installation Verification” IT Deployment guide.Source Installation PackageDeployment documentationSource codeBack up of BCS supported databases (.bak files)SQL scripts to initialized the databaseSetting Up the BCS PlatformSource Installation PackageCopy the contents of the Source Installation Package to a local drive, preferably named “C:\BCS_SourceFiles.” The contents of the Source Installation Package will be divided into the folders described in the table below.Source Installation Package FoldersDescriptionApplicationSource code of the BCS solution to be opened via Visual StudioDatabaseDataUpdateDatabase scripts to update or modify data within the BCS applicationDatabaseSchemaDatabase scripts to update the schema or actual back up files for initial deploymentSSISSQL Server Integration Services (SSIS) installation packagesSSRSSQL Server Report Services (SSRS) source Report Definition Language (RDL) Service source code for installation or updatesMicrosoft .NET 4.0 FrameworkPlease refer to the “.Net 4.0 Framework Verification” IT Deployment guide for setup steps.Internet Information Services (IIS) 7.xPlease refer to the “IIS Installation Verification” IT Deployment guide for setup steps.BCS Database Please refer to the “Database Installation” IT Deployment guide for setup steps.Running the BCS PlatformVisual Studio Professional 2010 SP1 ConfigurationDepending on how you normally setup your Visual Studio projects, copy the source code (Application folder of the Source Installation Package) to a preferred location. For example: “C:\Projects\Cna\Registries\.”To load and build the BCS web project, named “Bcs.Web.Mvc.Website.Bureaucrat,” you will need to install MVC 3, which can be found at: . Open the “Bcs.sln” file from the root directory and ensure no errors occur when loading the project.Website ConfigurationYou will need to modify the “web.config” file to ensure that the database connection strings are correctly associated to the BCS platform databases. Please refer to the <connectionStrings> attribute and the “Data Source=” values.In the “Database Installation” IT Deployment guide, Database Security (section 4.5) recommends creating the SQL server login as ‘BCS’ (or as your security policy requires). Update the “web.config” file to match to the SQL server user under which the BCS platform will be running.The following is an example of the connection section of a working application where the database resides on the same server as the web application (Data Source=.\):<connectionStrings><add name="Logging" connectionString="Data Source=.\;Initial Catalog=BcsLogging; integrated security=False;User ID=USERNAME;Password=PASSWORD;multipleactiveresultsets=True" providerName="System.Data.SqlClient" /><add name="Registry" connectionString="Data Source=.;Initial Catalog=BcsRegistry;integrated security=False;User ID=USERNAME;Password=PASSWORD;multipleactiveresultsets=True" providerName="System.Data.SqlClient" /><add name="Bcs" connectionString="Data Source=.;Initial Catalog=Bcs;integrated security=False;User ID=USERNAME;Password=PASSWORD;multipleactiveresultsets=True" providerName="System.Data.SqlClient" /></connectionStrings>Criminal Justice Information Services (CJIS) EnhancementsSystems that Utilize CJIS InformationIf your system includes enhancements related to viewing CJIS information and the associated security needed to do so, the following instructions will guide you through how to correctly establish the CJIS web pages on your web server. Since CJIS code will not be deployed automatically, you must consider the processes described below in order to deploy the code.Local builds should automatically copy the “Bcs.Cjis.*.dll” files into the “\Bin” folder; therefore, typical development should not be impacted by any of these changes.The following files are related to the CJIS implementation and should be copied to the “\Bin” folder after publishing:Bcs.Cjis.Dal.dllBcs.Cjis.Impl.dllBcs.Cjis.Log.dllBcs.Cjis.Sani.dllBcs.Cjis.Val.dllBcs.Web.Mvc.Website.Controllers.Cjis.dllBcs.Web.Mvc.Website.Models.Cjis.dllSystems that do not Utilize CJIS InformationAlternatively, for a non-CJIS deployment, the “Views\Cjis” folder and its contents should be deleted. These “*.cshtml” files are responsible for rendering the HTML generated via the Controllers.Cjis and Models.Cjis classes (that should not be present). Even though the CJIS views won’t work without the underlying controller and model classes, they should be deleted nonetheless.The related “*.Cjis.*.dll” files should also be deleted. Though deleting the views will provide some level of protection against users being able to access CJIS functionality, it is possible to perform get/post actions against controllers with missing views. Such attempts would fail due to our use of the AntiForgeryToken, but it is still best to delete all CJIS related files.Testing the ApplicationRun the application from Visual Studio to ensure you have a working system on your local machine. Run the solution via the Start Debugging process by clicking: Debug > Start Debugging or {F5}. Verify the application builds without error and that a web session is started. When the Login page displays, login with the temporary Admin account. After reaching the Home page, you have successfully installed and configured the BCS web application.If needed, set Bcs.Web.Mvc.Website.Bureaucrat as your StartUp Project in Visual Studio.Once you are ready for development deployment, publish the BCS to your local IIS installation (or to another server if internal processes dictate).Running the BCS Tasks ServiceThe Tasks Service facilitates messaging within the BCS platform. Install it as a service on the machine to which BCS is being deployed.BCS Tasks Service InstallationBrowse to the location where the source was installed on to your target machine; for example: “C:\BCS_SourceFiles\TaskService.” Verify the “Install.bat” and “Uninstall.bat” files are located within the folder. Edit both files to make sure the path to “InstallUtil.exe” is valid. (The default path is: “C:\Windows\\Framework64\v4.0.30319.”) Below is an example of running the “Install.bat” file.path=C:\Windows\\Framework64\v4.0.30319;%PATH%installutil /ShowCallStack Bcs.Tasks.WinService.exerem installutil /ShowCallStack C:\Projects\Cna\Registries\Application\Tasks\Bcs.Task.Winservice\Bin\Debug\Bcs.Tasks.WinService.exepauseNote that when running the “Install.bat” file, the path to “Bcs.Tasks.WinService.exe” must be correct. If the relative path does not work, you can use a direct path.Update the “Bcs.Tasks.WinService.exe” file to ensure that <connectionStrings> is updated to reflect the correct database connection information. Refer to Website Configuration (section 5.2 above) for more information.Run the “Install.bat” file.Review the output of the DOS window to ensure there are no errors. Confirm the Tasks Service has been installed in the Services section. Confirm the name of the service running is BCS Task Service.If you want to modify the name of the Task Service, modify the value for the Deployment key in the configuration file prior to running the “Install.bat” file. The value you enter will be appended to the BCS Task Service name. For example, if you enter a value of “UAT”, the service name will be: “BCS Task Service – UAT.”BCS Tasks Service ConfigurationAfter completing the steps described above (section 6.1), the Tasks Service should now be installed under Services for the target machine.Edit the Properties of the BCS Tasks Service and update the following configurations:Set Startup Type to Automatic. Depending on your needs, you may also set it to delayed start so that the Tasks Service will startup at a designated time instead of immediately.Edit Log On As (if necessary, per your security or infrastructure requirements).Click Start the Service.Uninstalling the BCS Tasks ServiceWhen the need arises to remove the Tasks Service from the target machine, refer to the same directory used in the installation. Note that when running the “Uninstall.bat” file, the path to “Bcs.Tasks.WinService.exe” must be correct. If the relative path does not work, you can use a direct path. Run the “Uninstall.bat” file.Review the output of the DOS window to ensure there are no errors. Confirm the Tasks Service has been removed from the Services section. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download