Enables you to set parameters for the target Smart Instrumentation database and start the database setup process. Setting the database parameters is the second step in the Smart Instrumentation database setup process on SQL Server. This dialog box opens after clicking Connect on the Microsoft SQL Server Connection dialog box in the DB Setup utility.
Target database name — Type the name of the Smart Instrumentation database for which you want to run the setup process. This value must be unique within your SQL Server that you specified on the Microsoft SQL Server Connection dialog box.
Admin schema
The options in this section are used to define the Admin schema name and password.
Logon name — Displays the default Admin schema logon name SPI_DBAMN. You can type a different name if needed. The logon name can only start with a letter and may not contain spaces. You can use an underscore ( _ ) to indicate a space. The Admin schema logon name must be different from the Admin schema logon password.
-
If this is the first database setup for Smart Instrumentation in the current SQL Server database, the logon name must be unique. If you have already setup a Smart Instrumentation database in the current SQL Server, you must create a new instance for the new Smart Instrumentation database setup.
-
If you want to define a new logon name, you must also define a new logon password, different from the logon name.
Logon password — Displays the default Admin schema logon password SPI_DBA. You can type another password, if it is different from the Admin schema logon name. The logon password can only start with a letter and may not contain spaces. You can use an underscore ( _ ) to indicate a space.
-
If this is the first database setup for Smart Instrumentation in the current SQL Server database, the logon name must be unique. If you have already setup a Smart Instrumentation database in the current SQL Server, you must create a new instance for the new Smart Instrumentation database setup.
-
The software automatically converts all the password characters to upper case. This means that after completing the database setup, if you need to connect to the Smart Instrumentation database externally, you must enter the Admin schema logon password using upper-case characters.
Admin data
Admin file name — Accept the default value or type the required Admin file name.
Datafile name and path — Accept the default settings or type the required Admin datafile name and path. The default file extension is .mdf. You can change the file extension as you require.
Initial size (MB) — Accept the default value or type the required initial size value of the Admin datafile.
Admin index
Index file name — Accept the default value or type the required Admin index file name.
Datafile name and path — Accept the default settings or type the required Admin index datafile name and path. The default file extension is .mdf. You can change the file extension as you require.
Initial size (MB) — Accept the default value or type the required initial size value of the Admin index datafile.
Filegroup — Accept the default filegroup to which the Admin index datafile belongs, or type the required filegroup name.
Command Buttons
OK — Starts the database setup process.
Cancel — Closes this dialog box and discards all the values you have entered.