On the Database page you can create databases, connect a database with Performance Manager and disconnect the database again.
Configure the database connection with the following UI controls:
| Item | Description |
|---|---|
| DBMS type | The type of DBMS you want to access (MSSQL Server). |
| DBMS hostname or IP address | The computer name or IP address of the computer hosting the database management system (DBMS) in the format
<computer name>\<instance name>.
|
| Port |
The port on which the DBMS listens. The default port for Microsoft SQL Server, including Express, is 1433. |
| Database / SID |
MS SQL Server database name. |
| Username |
Database user with sufficient credentials. The default Microsoft SQL Server user, including Microsoft SQL Server Express, is sa, if not changed by your database administrator. |
| Password |
Valid password for the specified Username.
|
| Read-only Username (optional) | An optional database user with read-only rights on all tables and views in the specified database. This user is used for
executing reports. This will ensure that running reports with advanced queries will not change any data in the database, as
executing advanced queries could have a detrimental effect on the data.
For Microsoft SQL Server, Performance Manager automatically creates this user if you specify a name and password. |
| Read-only Password (optional) |
Valid password for the specified Read-only Username (optional). |
| Status |
Displays the status of the Performance Manager connection to the DBMS. |
| DBMS version info |
Displays DBMS and operating system version information. |
| Connect / Disconnect |
Depending on the current connection status, use this button to connect to or disconnect from a DBMS. |