How to configure Remote Desktop Manager Enterprise with SQL Server

Server computer

  1. Install or unzip Remote Desktop Manager Enterprise on the machine.

    Download RDM

  2. Install SQL Server or SQL Server Express (this version is free) with the administrator user named "sa" (Mixed mode authentification).

    Note:

    • To create the Remote Desktop Manager database, you must use the user "sa", domain user are not supported yet.
    • Make sure that your remember the SQL Server instance name, you will need it for the connection.

  3. Use your administrator user "sa" in Remote Desktop Manager to create an empty database.

    • To create an empty database, you must go in the menu: ( File > Data Sources ).
    • Configure the connection with the user "sa" and test the connection
    • Click the button "Create Database".

  4. SQL Server port are blocked by default, follow this link to open the necessary ports and firewall:

    http://support.microsoft.com/kb/914277

  5. Create and configure security access for any other user needed in Remote Desktop Manager
    ( File > Administration > Users )
Client computer

  1. Install or unzip Remote Desktop Manager Enterprise on the machine.

    Download RDM

  2. Install SQL Server Native Client 32 bits / 64 bits (used to connect to the SQL Server instance).

  3. Configure Remote Desktop Manager to connect directly to the SQL Server (use the machine name and SQL Server instance name).

    • You can configure the connection in the menu: ( File > Data Sources ).
    • Click on the button "Add SQL Server Datasource".
    • Configure the connection settings and test the connection.