Database properties
Database properties store information that is used in the connection string that is held in the DefaultCluster property in the Clusters property collection. The connections string is used to connect to the properties table in the project management database.
The values in these properties come from the registry and cannot be changed using DPM Explorer. Refer to MSDN for further information about any of these properties.
Properties
AUTH_INTEGRATED
Whether to log in to SQL Server using Windows or SQL Server authentication.
Value: SSPI, which means that logging in uses Windows authentication.
AUTH_PASSWORD
The SQL Server login password.
Value: Blank (not needed for logging in using Windows authentication).
AUTH_PERSIST_SENSITIVE_AUTHINFO
Whether or not the data source object is allowed to persist sensitive authorization information.
Value: Blank, so sensitive information is not persisted.
AUTH_USERID
The SQL Server user ID to log in with.
Value: Blank (not needed for logging in using Windows authentication).
INIT_CATALOG
The name of the database to connect to; that is, the one that holds the properties table.
Value: UNICOM Intelligence Interviewer - Server Admin Data
INIT_DATASOURCE
The network name of the server on which the database is located.
Value: The database server named during installation. For clusters, it is the first database server named.
INIT_LOCATION
This property is not supported by SQL Server.
Value: Blank.
INIT_PROMPT
How to prompt for datasource initialization.
Value: 4
Provider
The name of the database provider to use for connecting to the database.
Value: MSOLEDBSQL.1
Table
The name of the properties table.
Value: ProjectMgmt
See also