Setting up the database servers
To set up a database server, complete the following steps:
1 Log in to DPM Explorer as a user who has DPMAdmin permission.
2 Under Site/Properties, create a DatabaseServers collection.
For more information about using DPM Explorer, see
DPM Explorer.
3 Under DatabaseServers, create a property collection using the name that you want to use to access this database server; for example, SQLServer1 or AzureMI1.
4 Under the database server, create either a ConnectionString or Connection Properties:
Specifying a ConnectionString
You must specify the Provider and Data Source properties. Do not include the Initial Catalog.
Specifying Connection Properties
The following connection properties are supported.
You do not have to specify all the properties. If a ConnectionString is provided, then any additional properties are ignored.
AUTH_USERID
The user ID used to authenticate.
For more information, see DBPROP_AUTH_USERID in the Microsoft OLE DB documentation.
AUTH_PASSWORD
The password used to authenticate.
For more information, see DBPROP_AUITH_PASSWORD in the Microsoft OLE DB documentation.
AUTH_ACCESS_MODE
Authentication mode. This property can be used to specify authentication with an Azure Active Directory identity.
For more information, see SSPROP_AUTH_MODE in the Microsoft OLE DB documentation.
AUTH_ACCESS_TOKEN
Access token used for authentication.
For more information, see SSPROP_AUTH_ACCESS_TOKEN in the Microsoft OLE DB documentation.
INIT_ENCRYPT
Specify whether to encrypt data going over the network.
For more information, see SSPROP_INIT_ENCRYPT in the Microsoft OLE DB documentation.
INIT_TRUST_SERVER_CERTIFICATE
Enable or disable server certificate validation.
For more information, see SSPROP_INIT_TRUST_SERVER_CERTIFICATE in the Microsoft OLE DB documentation.
Examples
SQL Server Authentication using ConnectionString:
ConnectionString = Provider=MSOLEDBSQL;Data Source=[MyServerName];Authentication=SqlPassword;UserID=[MyUsername];Password=[MyPassword]
SQL Server Authentication using Connection Properties:
AUTH_INTEGRATED = Null (Leave the value empty)
INIT_DATASOURCE = [MyServerName]
AUTH_USERID = [MyUserName]
AUTH_PASSWORD = [MyPassword]
Azure Active Directory Authentication using ConnectionString:
ConnectionString = Provider=MSOLEDBSQL;DataSource=[MyServerName];Authentication=ActiveDirectoryPassword;UserID=[MyUserName];Password=[MyPassword]
See