allesrob

Mostly a single user, at most 4 users. I will give that a shot, thank you.

However if I am lazy and just pause the SQL service on the server I do get the same response but with a log entry:

[1/8/2014 7:37:29 PM]ERROR SILENT System.Data.SqlClient.SqlException: SQL Server service has been paused. No new connections will be allowed. To resume the service, use SQL Computer Manager or the Services application in Control Panel.

Login failed for user '********'.

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.TestConnection(String userName, String password)

----------

not as big of a deal but still an inaccurate error message.

Still freezes for a bit, won't let me move or dismiss the upgrade window, and tells me bad username & password without putting anything in the log.

Microsoft SQL Server 2008 R2 Express

It will ask for the username & password repeatedly and never write anything to the log.

My testing steps are as follows:

1) Open RDM and connect with manually entered username & password to verify functionality and close RDM.

2) Disconnect the network connection on the server hosting MSSQL.

3) Open RDM and repeat step 1 for about a dozen times and check the log file each time to verify no changes.

Are there any performance, feature, or stability advantages of one over the other?

I ask as I have about a thousand entries and using RDM from my flash drive remotely tends to run horribly and have authentication issues so I was contemplating testing out MySQL. Server bandwidth is not the issue.

I'm using MSSQL and have found that RDM gives the error bad username or password at logon without integrated security checked when it can't reach the server instead of a 'Server Unavailable' message. This has a been a cause of much confusion until I realized RDM was misreporting the error.

I imagine it as alot of things. If not in location x dial vpn first or use remote address. Dialing a vpn could automatically set the location flag but you would want to be able to manually set it too for when a service laptop is onsite.

For many smaller clients I have different connection strings for accessing rdp/vnc/etc... remotely without having to dial a vpn first. I use the ping & port scan feature to auto detect the host but this is slow, freezes up RDM, and doesn't always work properly.

It would be great if I could assign network locations and RDM would only use local address if I said I was in that network location.

When dealing with multiple networks via vpn that may have the same subnet or large networks where I support individual departments and cannot set static ip's I occasionally run into the issue of RDM trying to connect to the wrong device. This is not a bug in RDM, but if RDM where to check the MAC address before connecting it could prevent this and add security.

Max's example is good, although I would probably put it in the interface in the same style as the rdp port option. For me the biggest reason is multiple VPN connections lets say I'm connected to 3 separate client networks at once and I attempt to connect to workstation55.client-domain-A.local it will often fail because windows gets confused with the DNS entries of the local system in addition to those associated with the multiple dns servers or may use a incorrect cached record. Another reason it will fail is if I have the entry set to dial the vpn on demand if a ping fails it will do the lookup only from the local dns and I will have to try to connect again after the vpn is connected.

While the current method works when you configure things properly for many reasons it would be nice if RDM did the dns lookup itself from a user specified dns entry. This would allow for alot more reliable use of connecting to fqdn hostnames over vpn or connecting at all if you are dialed into multiple vpn connections or a vpn without dns configured.

So basically there would be an additional field for DNS lookup server in each session entry.

thank you. The batch clear credentials cleaned it up, but the credentials where at risk.

If you setup a session with session specific credentials and then later change to credential repository it still saves the session specific credentials. Not only that but I can't clear them without going in twice to save it as session specific and then as repository again. This unnoticed behavior has led to several credentials not being cleared and thus being a security risk.

the solution is to not specify a port with the ping. As in it should strip out the :port when doing the ping command.

a similiar issue I have found is when using the Autodetect (ping) option under alternate hosts it fails with a nonstandard port

Yes. For example everyone of my clients/groups has an entry called 'Router' so from the window title tracking I don't know which client/group that was. I know I could rename all the connections, but that seems tedious. thanks.

I use a software called manictime to keep track of my billing hours on projects that records activity mainly by window title. It would be nice to have the window title of RDM be configurable to include other variables for tracking. The most useful being the folder group.

Thank you

As I'm testing I see this as a huge issue preventing use of the program in the way I would most likely deploy it. In addition to the complete lack of security for offline mode, Locking the datasource doesn't stop you from hitting duplicate or viewing the settings, which renders that useless. So I would have to disable offline mode for everyone.

The filter box would be alot more useful if you could use AND, OR, etc.. or at least multiple terms for ANY. I find myself working on two or thee different folder groups and scrolling alot.

When using a different port in the remote desktop address (ex: 192.168.1.1:3390) and using a template to connect it seems to lose the port. I've also noticed issues when using the vpn ping before connect tool when using a different port. Is there a workaround? Is there a way to enter the port in a separate field, that seems like it would be the best way to do it.