Downtime database connection properties
- Last UpdatedSep 10, 2023
- 1 minute read
Refer to the following table for the key configurable properties of the database connection properties.
Database Connection properties
|
Property |
Description |
Valid values |
|---|---|---|
|
DataSource |
The name of the data source this connector accesses. This is the name of the computer. If the data source is on the local computer, use (local), instead of local or localhost. The connection expects to use the default instance of SQL server. If you use a named instance, precede the name of the instance with the characters .\. For example, if you have a named instance called SQL2008R2, then enter .\SQL2008R2. You can enter either <MachineName>\SQL2008R2 or .\SQL2008R2. |
<MachineName>\<SQLServerInstanceName> |
|
IntegratedSecurity |
The integrated security code used by the OLE-DB connection; for example, SSPI. |
|
|
UserID |
The user name for the OLE-DB connection. |
|
|
Password |
The password for the OLE-DB connection. |
|
|
Provider |
The name of the provider used by the OLE-DB connection; for example SQLOLEDB or MSDAORA. |