On the Server Machine
1. Install or unzip Remote Desktop Manager Enterprise on the machine
2. Install SQL Server or SQL Server Express (this version is free) with the administrator user named "sa" (mixed mode authentication). Learn more at
http://remotedesktopmanager.com/remotedesktopmanager/Home.aspx/Download
| • | To create the Remote Desktop Manager database, you must use the user "sa" because domain users are not currently supported |
| • | Make sure to remember the SQL Server instance name, as you will need it for the connection |
| • | SQL Server 2000 is not supported by Remote Desktop Manager |
3. Use your administrator user "sa" in Remote Desktop Manager to create an empty database.
| • | To create an empty database, go to File->Data Sources |
| • | Configure the connection with the user "sa" and test the connection |
| • | Click the button "Create Database" |
4. SQL Server ports are blocked by default, so 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 (menu File > Administration > Users)
Client Machine
1. Install or unzip Remote Desktop Manager Enterprise
2. Configure Remote Desktop Manager to connect directly to the SQL Server database (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 Data source" |
| • | Configure the connection settings and test the connection (see the SQL Server data source topic here) |