Warning

The SQL feature is in an early beta stage and not intended for use in an productive environment!
I recommend you to do a full backup of your connections and settings before switching to SQL Server.

Steps to configure your SQL Server

• Create a new Database called "mRemote" on your SQL Server.
• Run the SQL Script below on the newly created Database.
• Give the users that you want to grant access to the mRemote Connections Database Read/Write permissions on the Database.

Steps to configure mRemote for SQL

• Start mRemote if it's not already running.
• Go to Options - Connections.
• Check the box that says "Use SQL Server to load & save connections".
• Fill in your SQL Server hostname or ip address.
• If you do not use your Windows logon info to authenticate against the SQL Server fill in the correct Username and Password.
• Click OK to apply the changes. The main window title should now change to "mRemote | SQL Server".
• Now click on File - Save to update the tables on your SQL Server with the data from the loaded connections xml file. (Do not click File - New, this doesn't work yet)
• You should now be able to do everything you were able to do with the XML storage plus see the changes live on another mRemote instance that is connected to the same Database.

SQL Table creation Script

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblCons]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblCons]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblRoot]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblRoot]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblUpdate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblUpdate]
GO

CREATE TABLE [dbo].[tblCons] (
                [ID] [int] IDENTITY (1001, 1) NOT NULL ,
                [ConstantID] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [PositionID] [int] NOT NULL ,
                [ParentID] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [LastChange] [datetime] NOT NULL ,
                [Name] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [Type] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [Expanded] [bit] NOT NULL ,
                [Description] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [Icon] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [Panel] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [Username] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [DomainName] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [Password] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [Hostname] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [Protocol] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [PuttySession] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [Port] [int] NOT NULL ,
                [ConnectToConsole] [bit] NOT NULL ,
                [ICAEncryptionStrength] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [Colors] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [Resolution] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [DisplayWallpaper] [bit] NOT NULL ,
                [DisplayThemes] [bit] NOT NULL ,
                [CacheBitmaps] [bit] NOT NULL ,
                [RedirectDiskDrives] [bit] NOT NULL ,
                [RedirectPorts] [bit] NOT NULL ,
                [RedirectPrinters] [bit] NOT NULL ,
                [RedirectSmartCards] [bit] NOT NULL ,
                [RedirectSound] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [RedirectKeys] [bit] NOT NULL ,
                [Connected] [bit] NOT NULL ,
                [PreExtApp] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [PostExtApp] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
                [InheritCacheBitmaps] [bit] NOT NULL ,
                [InheritColors] [bit] NOT NULL ,
                [InheritDescription] [bit] NOT NULL ,
                [InheritDisplayThemes] [bit] NOT NULL ,
                [InheritDisplayWallpaper] [bit] NOT NULL ,
                [InheritDomain] [bit] NOT NULL ,
                [InheritIcon] [bit] NOT NULL ,
                [InheritPanel] [bit] NOT NULL ,
                [InheritPassword] [bit] NOT NULL ,
                [InheritPort] [bit] NOT NULL ,
                [InheritProtocol] [bit] NOT NULL ,
                [InheritPuttySession] [bit] NOT NULL ,
                [InheritRedirectDiskDrives] [bit] NOT NULL ,
                [InheritRedirectKeys] [bit] NOT NULL ,
                [InheritRedirectPorts] [bit] NOT NULL ,
                [InheritRedirectPrinters] [bit] NOT NULL ,
                [InheritRedirectSmartCards] [bit] NOT NULL ,
                [InheritRedirectSound] [bit] NOT NULL ,
                [InheritResolution] [bit] NOT NULL ,
                [InheritUseConsoleSession] [bit] NOT NULL ,
                [InheritICAEncryptionStrength] [bit] NOT NULL ,
                [InheritUsername] [bit] NOT NULL ,
                [InheritPreExtApp] [bit] NOT NULL ,
                [InheritPostExtApp] [bit] NOT NULL ,
) ON [PRIMARY]
GO
 
CREATE TABLE [dbo].[tblRoot] (
                [Name] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [Export] [bit] NOT NULL ,
                [Protected] [varchar] (4048) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
                [ConfVersion] [float] NOT NULL
) ON [PRIMARY]
GO
 
CREATE TABLE [dbo].[tblUpdate] (
                [LastUpdate] [datetime] NULL
) ON [PRIMARY]
GO