Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mRemoteNG with SQLDB to share connections #2579

Open
Weben-is-me opened this issue Apr 10, 2024 · 0 comments
Open

mRemoteNG with SQLDB to share connections #2579

Weben-is-me opened this issue Apr 10, 2024 · 0 comments
Assignees
Labels
1.77.3 Version 1.77.3 DBs Issues with DBs Need 2 check

Comments

@Weben-is-me
Copy link

I've just deployed mRemoteNG in a Windows Servers 2016 and I'd like to set SQL as DB to store more than 1000 connections and share them in a team. I've followed the instructions:
https://github.com/mRemoteNG/mRemoteNG/blob/v1.77.3-dev/mRemoteNGDocumentation/sql_configuration.rst

and deployed the db with the following script:
https://github.com/mRemoteNG/mRemoteNG/blob/develop/mRemoteNGDocumentation/mssql_db_setup.sql

I'm able to connect to the database I create a connection but when putting the hostname at the Config tab the following error is showed:


ErrorMsg
04/10/2024 17:13:02
Couldn't save connections file as ""!
Column 'InheritExternalCredentialProvider' does not belong to table .

If I close the application and reopen it it shows the following error after reconnecting ti the DB:
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at mRemoteNG.Config.Serializers.ConnectionSerializers.MsSql.DataTableDeserializer.PopulateConnectionInfoFromDatarow(DataRow dataRow, ConnectionInfo connectionInfo)
at mRemoteNG.Config.Serializers.ConnectionSerializers.MsSql.DataTableDeserializer.DeserializeConnectionInfo(DataRow row)
at mRemoteNG.Config.Serializers.ConnectionSerializers.MsSql.DataTableDeserializer.CreateNodesFromTable(DataTable table)
at mRemoteNG.Config.Serializers.ConnectionSerializers.MsSql.DataTableDeserializer.Deserialize(DataTable table)
at mRemoteNG.Config.Connections.SqlConnectionsLoader.Load()
at mRemoteNG.Connection.ConnectionsService.LoadConnections(Boolean useDatabase, Boolean import, String connectionFileName)
at mRemoteNG.UI.Forms.OptionsPages.SqlServerPage.ReinitializeSqlUpdater()
at mRemoteNG.UI.Forms.OptionsPages.SqlServerPage.SaveSettings()
at mRemoteNG.UI.Forms.FrmOptions.SaveOptions()
at mRemoteNG.UI.Forms.FrmOptions.BtnOK_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, WM msg, IntPtr wparam, IntPtr lparam)

Environment

  • Version used: 1.77.3
  • Operating System and version (e.g. Windows 10 1709 x64): Windows Server 2016 / 2022 - SQL Server 2012

Question
Is the SQL script used the correct one to the application version (1.77.3 )?
I've tried with the 3 available versions for downloading 1.76.20.24615 / 1.77.1.27654 / 1.77.3.nb-1784, and get different errors:

1.76.20.24615 & 1.77.1.27654

ErrorMsg
04/10/2024 17:24:01
Couldn't save connections file as ""!
The given ColumnMapping does not match up with any column in the source or destination.

Thanks for any help!

@Kvarkas Kvarkas self-assigned this Apr 10, 2024
@Kvarkas Kvarkas added Need 2 check DBs Issues with DBs 1.77.3 Version 1.77.3 labels Apr 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
1.77.3 Version 1.77.3 DBs Issues with DBs Need 2 check
Projects
None yet
Development

No branches or pull requests

2 participants