The DB Setup Utility creates an individual Smart Instrumentation database in a SQL Server instance and enables you to configure this instance for working with Smart Instrumentation. You perform the database setup procedure after successfully installing the SQL Server database server, SQL Server client, and Smart Instrumentation for SQL Server. The DB setup application (.exe) is found in the folder where you installed Smart Instrumentation. By default that is; C:\Program Files (x86)\SmartPlant\Instrumentation.
The DB Setup Utility performs the following operations (in the indicated order):
-
Creates a Smart Instrumentation database with SQL Server filegroups in the instance you installed on the SQL Server database server.
-
Creates the INTOOLS_ENGINEER role and the following Smart Instrumentation database schemas: SPI_login, and Admin schema.
-
Create logon information (logins) at the instance level and associates the logon information with the Smart Instrumentation database schemas. For the SPI_login schema, the login is created only once, during the first database setup. The login is shared for all the Smart Instrumentation databases you create in this SQL Server instance.
-
Creates database objects in the Admin schema of Smart Instrumentation and fills these objects with data that appears in the IN_TEMPL template database, supplied with Smart Instrumentation.
-
During the database setup, the INTOOLS_ENGINEER role receives system privileges and privileges for database objects included in the Admin schema. These objects are shared for all domains you initialize. When initializing a new domain, other database schemas of Smart Instrumentation receive the INTOOLS_ENGINEER role.
-
If your Smart Instrumentation database is created in an SQL Server named instance, make sure that in the [Database] section of the Intools.ini file the servername parameter value is as follows:
servername=<Server Windows name>\<named instance>
The following special characters cannot be used in passwords, database names, file
names, and so forth:
/
\
[
]
=
;
#
:
"
!