Database Settings
The Install Database dialogue asks you to submit information about the database and how the Bizview application server will login and access the data in the database:
- Enter a descriptive name for the database. The prefix "bizview_" and the suffix "ds_" will always be part of the database name and will be input automatically. You need to enter the unique <name>, e.g. "bizview_demodev_ds".
- Choose what database collation you want to use. By default, this is set to server default.
- Specify which type of SQL authentication the Bizview application server should be using when connecting to the Bizview application database.
- SQL Server Authentication: Enter a SQL login and password for the Bizview to use when connecting to the application database. DBWizard will add the following properties:
- The login will be created if it does not exist.
- Add Server Roles bulkadmin and dbcreator to the account.
- Add User Mapping db_owner to the Bizview_<name>_ds database
- Windows Authentication: Select this option if you wish to use Windows Authentication between the Bizview application and the Bizview database. If you select Windows Authentication, no account will be created, nor will it be added as db_owner in the Bizview database. This has to be done manually! To enable Windows Authentication between the Bizview application and database, follow these steps:
- Find what server account is running the Application Pools that the Bizview application is using (typically DefaultAppPool)
- Add the account, CREATE LOGIN [domain\machine_name$] FROM WINDOWS, to the SQL Server Logins (If the SQL Server and IIS server are different machines, this script must be used to add the Account)
- Add Server Roles bulkadmin and dbcreator to the account
- Add User Mapping db_owner to the Bizview_<name> database
In the example below, the DefaultAppPool is run by NetworkService account. This account also needs to be added as the db_owner of the Bizview database:
Next step:Snapshot File