Online Help > Data Sources > Data Sources type > Advanced Data Sources

SQL Server

Description

 

Remote Desktop Manager for iOS uses the power of Microsoft SQL Server to save and manage all sessions.

 

Microsoft SQL Server 2005, 2008, 2008R2, 2012 and 2014 are supported (All editions except the compact).

 

BadgeInfo48x48

You will be able to connect to a SQL server but you will not be able to create one. Your SQL Server data source has to be managed by desktop client (either Windows or Mac) to be able to create your data source.

 

 

Settings

 

Connection

 

SQL Server - Connection tab

SQL Server - Connection tab

 

Option

Description

Name

Enter a name for the data source.

Server

Enter the 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 Remote Desktop Manager for iOS.

Test Server

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

Test Database

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

 

Advanced

 

SQL Server - Advanced Settings

SQL Server - Advanced Settings

 

 

Option

Description

Offline mode

Allow the data source to be used in Offline mode, select between:

None: Prevents an offline cache from being used.

Read-Only: Session data can be browsed and launched while not communicating back to the data source.

Auto go offline

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

Caching mode

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

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.