DOCS

Initializing a Microsoft SQL Server Database for CAE

To initialize a Microsoft SQL Server database for CAE

1. In the left frame of the Connection Manager page, expand Database Installation & Configuration Tools:

2. Select SQL Server - Initialize database for CAE, then click Next.

Or  

Double-click SQL Server - Initialize database for CAE.

The Server list displays:

3. In the left frame of the Initialize SQL Server Database for CAE page, expand, if necessary, the Server list and select a database server connection.
4. In the Database server area, review this information:
Driver
Database server hostname
Database name
If the connection parameters are not correct, go to the Connection Manager to edit them before continuing the database initialization.
5. If the database instance has been created with the Windows authentication option, select the Use Windows system credential check box.

Or  

Enter the database administrator account password.

In the Database administrator account area, change the account password. If, when adding the database server connection, you saved the account password in step 4 , the Account password field is deactivated.
6. Click Next.
7. On the Initialize database for CAE window, verify or change the data files that contain these elements for the CAE entry point(s):
Object property tables
Object property indexes
Link tables
Link indexes
Source and file data
Model and read-only data tables
Model and read-only data indexes
Internal work tables
Internal work indexes
8. Click Run to initialize the SQL Server database for CAE.