Online Help > Data Sources > Data Sources Types > Advanced Data Sources

SQL Server Data Source

Description

 

DataSourceSQLServerLarge

With the SQL Server data source, Password Vault Manager uses the power of Microsoft SQL Server to save and manage entries.

 

All editions of SQL Server (including Express) starting with 2012 and above are supported.

 

The following features are also supported:

Always on availability group

Clustering

Log Shipping

Database mirroring

 

Highlights

 

Supports user management with a superior security model.

Supports Offline Mode for when the server or network is unavailable.

Supports Full connection log and attachment.

Supports repositories to organize thousands of entries.

 

BadgeWarning48x48

A proper database backup strategy should be implemented to minimize possible data loss, please refer to Backups topic.

 

Configuration

 

Consult Configure SQL Server topic for more information on the configuration.

 

Settings

 

Connection

 

SQL Server - Connection tab

SQL Server - Connection tab

 

Option

Description

Name

Name the data source.

Server

Enter the server hostname or IP address.

Ellipsis button

Provides the list of computers discovered on your network. This can take a few moments to generate.

Login mode

Specify the authentication mode to use. Select between:

Database login

Integrated security

Custom login

User

Enter the username to access the SQL server.

Password

Enter the Password to access the SQL server.

Database

Enter the name of the database.

Two factor

Enable the 2-Factor Authentication.

Test Server

Test the connection with the server to validate if the proper information has been provided.

Test Database

Test the connection with the database to validate if the proper information has been provided.

 

Settings

 

SQL Server - Settings tab

SQL Server - Settings tab

 

Option

Description

Repository

Click on the ellipsis button to select a repository.

Root filter

Enter the name of a root level folder to display only the entries contained in that folder.

Auto refresh

Set the interval for the automatic refresh.

Ping online method

Indicate the preferred ping online. Select between:

None

Ping

Port Scan

Auto go offline

Use the data source in offline mode if the ping online method does not respond.

Disable lock

Disable the option to lock the data source directly. You can still lock the application but you won't be prompted for the database password if this option is disabled.

 

Advanced

 

SQL Server - Advanced tab

SQL Server - Advanced tab

 

Option

Description

Offline mode

Determine if you want to use this data source in Offline Mode. With this mode, the data source can be available in Read Only or in Read/Write mode

Prompt for offline mode on startup

Every time you will connect to your data source, you will be prompted to use the data source in offline mode.

Caching mode

Determine how the entries will be reloaded in the data source. See Caching Mode topic for more information.

Connection timeout

Waiting time before a connection timeout.

Command timeout

Waiting time before a command timeout.

Allow beta database upgrade

If an upgrade is required and you are using a beta version and database, it will authorize you to upgrade it.

Allow data source credential variables

Allow to use the data source credential to be use in variables.

Advanced Settings

Edit of the connection string values directly.

 

Upgrade

 

SQL Server - Upgrade tab

SQL Server - Upgrade tab

 

Option

Description

Test Server

Test the connection with the server to validate if the proper information has been provided.

Create Database

Create the database on the SQL server to use Password Vault Manager.

Update Database

Update the database on the SQL server, if required to use Password Vault Manager.

Test Database

Test the connection with the database to validate if the proper information has been provided.

Email Schema to Support

Send your schema to the Devolutions Support team.

View upgrade script

Generate your updated script.