To create an asset management database using Microsoft SQL Server:

1. In the Basic Database Settings dialog box, specify Server and Database name.
   Specify each item in the following Basic Database Settings dialog box.
   

   Figure 5-4 Basic Database Settings dialog box (for Microsoft SQL Server)

   

   The following describes each item in the dialog box.
   
   • Server
     Specifies the server name or IP address of the database to be connected. The permitted value is 1 to 63 bytes of alphanumeric characters, %, ~, -, _, ., /, and \. By default, this item is blank.
     
   • Database name
     Specifies the name of the database to be created. The permitted value is 1 to 128 bytes of alphanumeric characters and symbols, excluding ", |, -, *, :, <, >, ?, /, and \. By default, this item is blank.
     
   • ODBC data source name
     Displays the value specified for Service name in the Server Setup dialog box. This item cannot be changed.
     
   • Connection user ID
     Displays the value specified for Login ID in the Server Setup dialog box. This item cannot be changed.
     
2. Click the Next button.
   The Authenticate User dialog is displayed in order to connect to the database.
   
3. In the Authenticate User dialog box, in Administrator ID and Password, enter the administrator ID and password for the asset management database.
4. Click the OK button.
   When authentication is successful, the following Detailed Database Settings dialog box appears.
   

   Figure 5-5 Detailed Database Settings dialog box (for Microsoft SQL Server)

   

   If authentication fails, a message is displayed. Take an appropriate action according to the displayed message.
   
5. Specify an area for data file and transaction log.
   The following describes each item to be specified in the dialog box.
   
   • File Path
     In File Path, specify the file path for storing the database. Clicking the ... button displays a dialog box in which you can browse files and specify a desired file path. Specify 1 to 255 bytes of characters. Note that ", |, *, <, >, ?, &, ^, and / are not permitted. For the data file, AIMDB.mdf in the folder that contains Microsoft SQL Server's master database is specified by default. For the transaction log, AIMDB.ldf in the folder that contains Microsoft SQL Server's database is specified by default.
     
   • Initial Size [MB]
     Specifies the initial size of the database area. Select the initial size of a desired area and specify an integer. By default, the estimate value obtained in the Estimate Capacity dialog box is specified. For the transaction log, a size of 20 megabytes is specified. You can also use the Estimate Capacity dialog box to specify the initial size.
     
   • Automatically grow file
     Specifies that the maximum size and expansion increment of the database area are to be changed from the default value. By default, this check box is selected.
     
   • Maximum file size
     Specifies the maximum size of the database area. By default, Unrestricted file growth is specified. To specify the maximum file size, select Restrict file growth [MB] and then enter a maximum value in megabytes in the input field. Make sure that the integer specified in the input field is greater than the initial size. You can also use the Estimate Capacity dialog box to specify the maximum size.
     
   • Expansion increment
     Specifies the expansion increment for the database area. By default, an increment of 10% increase is specified. To specify the expansion increment in megabytes, select In megabytes and then enter an integer that is 1 or greater in the input field. To set the expansion increment in percents, select By percent and then specify an integer in the range from 1 to 100.
     
   • Estimate Capacity button
     Enables you to estimate the database capacity. For details about how to estimate the database capacity, see 5.4.4 Estimating the database capacity.
     
6. Click the Create button.
   The asset management database is created. When database creation is completed, a message indicating the completion of setup is displayed and the Database Manager dialog box closes. If database creation fails, a message to that effect is displayed, in which case, take an appropriate action according to the displayed message.