Online Help > Data Sources > SQL Server

SQL Server Settings

Settings

 

Select

 

When creating your new Data Source, select Microsoft SQL Server in your data source type.

 

clip0029

Select data source type

 

Settings

 

clip0030

Connection

 

Option

Description

Name

Name of the data source.

Server

Name of the server where the data source is store.

Integrated security (Active Directory)

Specify to use Windows Integrated Authentication for authenticating to the data source. Applies only to SQL Server and RDMS, depending on their configuration. When checked, an ellipsis button appears to allow you to browse for the user account in the directory.

User

Username to access the SQL server.

Password

Password used to access the SQL server.

Save password

If the option is not activated, you will need to enter your password every time you access your SQL server.

Database

Name of the database on the SQL server for the utilization of Password Vault Manager for Android.

Test Server

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

 

Advanced

 

clip0031

SQL Advanced tab

 

Option

Description

Offline mode

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

Auto go offline

If the ping online method doesn’t work it will automatically go offline.

Caching mode

Determine how the entries will be reload in the data source. You can select between:

Disabled

Simple

Intelligent

Auto refresh

Set the interval for the automatic refresh

Connection timeout

Waiting time before a connection timeout.

Command timeout

Waiting time before a command timeout.

Ping online method

Indicate the prefer ping online method. Select between:

Non

Ping

Port Scan

Department

Departments are folder paths that will allow you to have a single database with multiple data sources.