Online Help > Support/Resources > Tips And Tricks

SQL Server Data Source with Integrated Security

Overview

 

We will take you through a step by step guide to configure and test a Remote Desktop Manager deployment against an SQL Server data source using Integrated Security.

 

Any user (domain, local machine or SQL user) that has a server role of sysadmin is automatically an administrator of Remote Desktop Manager.

 

Create the database

 

The first step is to create the database that will store all your entries.

Click on the ellipsis button in the navigation pane, then click on Add a new data source.

 

Navigation pane - Data sources

Navigation pane - Data sources

 

Select the Microsoft SQL Server data source and click Ok.

 

Microsoft SQL Server data source

Microsoft SQL Server data source

 

Specify the Name, Server and Database

Authenticate with a user that is part of the sysadmin role.

 

Create the SQL Server data source

Create the SQL Server data source

 

If the logged-on Windows User is not part of the SQL Server sysadmin role, and you've configured the server to use SQL Server and Windows Authentication Mode, then use a SQL Server user (SA for example) that has the appropriate role assigned. You can then add yourself as a Remote Desktop Manager user after the fact and change the data source to use Integrated security.

 

Press  to validate the connection information.

From the upgrade tab, click Test Server then Create Database to create the SQL Server database.

 

Test the server and create the database

Test the server and create the database

 

Press Ok to close the dialogs. In the navigation pane, select the newly created data source from the data source drop down list.

 

Select the data source

Select the data source

 

Create users

 

To create users, navigate to Administration – Users.

 

Administration - Users

Administration - Users

 

Click Add Users.

 

User and security management

User and security management

 

Check the Integrated security (Active Directory) box and click the ellipsis button to select the domain user to add.

 

User Management – Integrated Security

User Management – Integrated Security

 

Select the User type. Grant the Add, Edit, and Delete rights (optional, restricted user only). For more information on user types and rights, please consult the Administration – Users topic.

 

User Management – Rights

User Management – Rights

 

Keep the Create SQL Server Login and User box checked. This will in effect cause Remote Desktop Manager to map a new login to the domain account and link it to a user.

 

You can uncheck this in the case where your DBA has created your login already on the SQL Server.

 

Repeat these steps for each user that needs access to this data source in Remote Desktop Manager.

 

Configure Remote Desktop Manager for other workstations

 

To configure the data source on other workstations, three methods are available:

 

Create the data source as done at the first time, making to check the Integrated Security (Active Directory) box.

Export the data source from the initial workstation and import into Remote Desktop Manager on all client workstations.

Use our Custom Installer service to help distribute the application and personalize the installation process.

 

Test the configuration

 

If you have a second set of domain credentials, you could use this trick to test locally. Running Remote Desktop Manager as Another User

 

Now in your Remote Desktop Manager that has admin rights, create a few sessions and assign them a security group (Admin, Production or Staging). Leave the security group blank for some sessions.

 

Now in Remote Desktop Manager running under a limited account, refresh the data source, you will only see the sessions that are part of the security group for which you've granted rights to this user.