initial database configuration. Enter the credentials for a SQL-authorized user account,
not a Windows-authorized user account.
The “Create database using” user must have, as a minimum, the following roles in
SQL Server:
◦
Server role: public
◦
Database roles for the two DSS databases: db_owner
●
The Access database using area: Enter values for the User name and Password
fields. DSS uses these credentials for all database operations, except the database
initialization process
The “Access database using” user must have, as a minimum, the following roles in
SQL Server:
◦
Server role: public
◦
Database roles for the two DSS databases: db_datareader, db_datawriter
●
The Connect using area:
◦
Database type: Select one of the three SQL Server versions:
●
SQL Server 2005
●
SQL Server 2008
●
SQL Server 2012
◦
Autoclose: When set to On, the SQL Server instance and its databases are
closed and their resources are freed when the last associated DSS instance is
closed. The SQL server instance and its databases are opened automatically
when a DSS user requires them. When set to Off, the SQL Server instance and
its databases remain open even when the last associated DSS instance is
closed.
◦
Command timeout: The amount of time DSS waits for a connection to the SQL
Server before terminating the connection attempt.
◦
Server name: The name of the server where the DSS SQL server is installed.
◦
DB instance name: The name of the SQL Server instance.
◦
Machine database name: The name to use for the machine data database. This
database must exist within the SQL Server instance before DSS can be
configured to use it. DSS will fill out the structure of the database but will not do
the initial creation.
◦
Customer database name: The name to use for the customer data database. This
database must exist within the SQL Server instance before DSS can be
configured to use it. DSS will fill out the structure of the da
tabase but will not do
the initial creation.
●
The Optional parameters area: Use the For machine database and For customer
database fields to enter additional connection strings parameters appended to the
connection string when connecting to these databases. The syntax of these additional
connection string parameters must adhere to the SQL Server connection string format.
ENWW Installation 41
Comentarios a estos manuales