Users

All Posts (15)

avatar

rgs

Disabled

Error creating new user

avatar
avatar
avatar
avatar
rgs
Disabled

Good question Min, it turns out I was using the only remaining RDM v14 installation in the company, the rest were on v2020.20! I updated it and deleted the user and started again, but there are still errors.

Yes I was using the RDM user management console, it gave me that SQL error.

Stefane thanks for the script, it showed some odd results so I've PM'd you the information.

Error creating new user

avatar
avatar
avatar
avatar
rgs
Disabled

Our RDM database is on SQL Server Express 14, on a Windows Server 2016 server. Users are using Windows 10 on a Server 2016 domain.

I can create a new user with domain credentials without a problem, but when I try to create a non-domain user using database authentication, the 'Test Server' button works OK, but get the following error when trying to connect to the database. The new user is created on the SQL server for that database.

The 'Fix SQL Login' button doesn't help, nor does making the user an administrator in RDM. Any ideas on how to fix this?

System.Data.SqlClient.SqlException (0x80131904): The SELECT permission was denied on the object 'DatabaseInfo', database 'rdm_IT', schema 'dbo'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetData(String sql, IDbDataParameter[] parameters)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetDataSourceSettings()

at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.c29fbd34504079a3525ca4c390d5d4074(BaseConnectionDataSource c7f28727fc7a5daa94ba08f688b2a5781)

at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.ca4799bebd8b706f34eea94a778843b55(BaseConnectionDataSource c7f28727fc7a5daa94ba08f688b2a5781, Boolean cfe205b02d73750f8fd14d199343fe545)

at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource, ConnectionEngine currentEngine)

ClientConnectionId:5580a931-2c79-495a-a3cd-3e5ab7de3bad

Error Number:229,State:5,Class:14

Watchguard VPN RWSCMD.exe missing

avatar
avatar
avatar
rgs
Disabled

Thanks Jeff, I'll give that a try. It looks like openvpn.exe is the right file to copy & rename.

Watchguard VPN RWSCMD.exe missing

avatar
avatar
avatar
rgs
Disabled

I've installed Watchguard Mobile VPN and it works OK, now I'm trying to get it running from RDM.

RDM is prompting me for the location of rwscmd.exe, but the file isn't in the Watchguard program folder.

Doe anyone know where I might be able to download this file?

Creating a custom Permissions report

avatar
avatar
avatar
rgs
Disabled

I would like to create a report similar to the built-in Permissions report, but I want to list all users individually instead of only listing roles.

I tried to do a database query (I'm using SQL Server as a data source). The information I need to link users to roles is in the Data column of the dbo.UserAccount table. It appears to be in XML format, but SQL Server doesn't recognise it as XML and throws an error.

Is there a way to extract this data in a usable format?

Citrix Web Login

avatar
avatar
avatar
avatar
rgs
Disabled

For anyone who is interested, David sorted this out for me. I'm new to Citrix and I didn't realise that I was in fact trying to log into a Citrix gateway. David showed me that I just needed to create a regular web session in RDM to log in.

Thanks David :-)

Citrix Web Login

avatar
avatar
avatar
avatar
rgs
Disabled

I can view the source, what exactly should I be looking for?

Citrix Web Login

avatar
avatar
avatar
avatar
rgs
Disabled

I'm using RDM v8.2.0.0. I have a Citrix web connection for which I have a URL, a username and a password. I can log in manually OK, but while RDM opens the browser with the correct address it won't automatically enter the username and password.

I have tried it with the embedded viewer, and with the browser manually set to IE and Firefox. I have tried all of the credential options and entering the credentials in the Login tab, but nothing works.

How do I get RDM to log in automatically?

Adding SQL Server Data Source

avatar
avatar
avatar
rgs
Disabled

Thanks David, 8.1 works perfectly.

Adding SQL Server Data Source

avatar
avatar
avatar
rgs
Disabled

I'm trying to add SQL Server 2005 as a data source, but I'm getting the error message

"A database upgrade is required. If you don't upgrade the data source will not be available"

What does this mean, and what exactly will it do if I agree to upgrade?

I'm using RDM Enterprise v8.0.12.0 trial.

Cisco VPN connection problem

avatar
avatar
avatar
rgs
Disabled

It's part of the Cisco VPN application. It seems to be a launcher for vpngui.exe, I'm not sure why we don't just use vpngui.exe directly. Our VPN connections were set up by a Cisco guy. I'll ask him next time I see him and let you know the reason.

Cisco VPN connection problem

avatar
avatar
avatar
rgs
Disabled

I just had a closer look and using ipsecdialer.exe with the /sc (silent connect) switch doesn't show anything while connecting or after it is connected.

Maybe users could have the option of command line , GUI, or GUI silent?

Cisco VPN connection problem

avatar
avatar
avatar
rgs
Disabled

Is it possible to use ipsecdialer.exe instead? It's what we use for our Cisco VPN shortcuts.

It adds an icon to the system tray while it's running but otherwise does the same as vpnclient.exe does. It opens the VPN GUI while it's connecting but it's no more intrusive than vpnclient.exe opening a command window.

Cisco VPN connection problem

avatar
avatar
avatar
rgs
Disabled

Hi David,

Yes, when I use vpnclient.exe in a command line session it connects and the command window stays open.

Cisco VPN connection problem

avatar
avatar
avatar
rgs
Disabled

When I make a Cisco VPN connection the command window opens and makes the connection OK but the "Opening Cisco VPN Connection" dialog box stays open.

The Cisco client GUI confirms the connection has been made and I can connect to devices on the remote network. However the dialog stays open until I manually close the command window.

I'm using v5.8.2.1 and Cisco VPN client v5.0.00.0340.

1 - 15 of 15 items