The Database Configuration Tool configures the cab folder and database used to store WinQual data for a profile.
If you don't have a supported database management system (DBMS) available click install SQL Server 2008 R2 Express Edition with recommended settings. You can move your profile data to an alternative database later if necessary (see Service Options). See Common Database Configurations below for instructions on different configurations.
Cab Folder: Stores downloaded cab (crash dump) files. Enter a path or click the Browse... button to select or create a folder.
Note that the cab folder must exist and must be accessible to the StackHash Service. By default the StackHash Service runs under the NETWORK SERVICE account. This means a folder in your profile (i.e. C:\Users\...) will not be accessible. We recommend using a folder in the root directory (i.e. C:\StackHash).
You can optionally decide to create the database files in the cab folder rather than the default database location. This keeps all of your StackHash data in one folder. The Store database files in cab folder checkbox is only available when creating a new profile database. Note that UNC paths are not supported when using this option.
SQL Server does not support storing database files on compressed volumes.
Database Name: Name (initial catalog) of the database to create or select. This must start with a letter and can then contain letters, numbers and the underscore character. The profile name can be no longer than 50 characters. Reserved SQL identifiers like INDEX may not be used as a database name.
Database Type:: Select which database to use. StackHash currently supports express, standard and enterprse editions of SQL Server 2005 and 2008. Click Refresh to update the list of available instances.
Database Instance: If you are using a locally installed database select it from this list. If you are connecting to a remote database you must update the connection string manually.
Connection String: The connection string will be updated automatically as you choose a database name, database and instance. If you need to make any modifications to the connection string do so immediately before clicking OK. Use the Test button to check that the StackHash Service can access the database.
For the best possible performance we recommend using a dedicated STACKHASH instance of SQL Server 2008 R2 running on the same computer as the StackHash Service. Use the install SQL Server 2008 R2 Express Edition with recommended settings link to install a dedicated STACKHASH instance. You may need to reboot after installing. Once installed, select STACKHASH in the list of available instances for SQL Server 2008.
When creating a database for StackHash on an existing SQL Server instance you should first make sure that the StackHash Service can access the database. By default the StackHash Service runs under the NETWORK SERVICE account.
To provide access for NETWORK SERVICE:
The StackHash Database Configuration Tool will not create databases on a remote SQL Server instance.
To use a remote database: