Target Database Parameters (SQL Server) Dialog Box - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Hexagon PPM

Intergraph Smart Instrumentation Administration

Language
English (United States)
Product
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version
13.1

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 session for Smart Instrumentation 2009 in the current SQL Server database, the logon name must be unique in the SQL Server database server.

  • If this is not the first database setup session,  you can use an existing Admin schema logon name but in this case, you must also use the existing Admin schema logon password.  You can only use an existing Admin schema logon name if the password in that Admin schema is different.  For example, if in another Smart Instrumentation database, the Admin schema logon name is IN_DBAMN, and the password is also IN_DBAMN, you cannot use IN_DBAMN for the Admin schema in the new Smart Instrumentation database.

  • 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 session for Smart Instrumentation 2009 in the current SQL Server database, the logon password must be unique in the SQL Server database server.

  • If this is not the first database setup session,  you can either use the existing Admin schema logon password or type a new password.  If you want to use the existing password, you must also use the existing logon name.  If you want to define a new password, you must also define a new logon name.

  • 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.