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.
Hi,
Could you check the application logs to see what is the exact message text underneath? This is located in Help-View Application Logs
David Hervieux
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.
Could you try to set the debug level to 1 in File->Options | Advanced?
David Hervieux
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.
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.
Hi,
I have found the problem. We had two different places where we were showing the error message and one of it was missing some details. This will be much better in the next beta release. Thank you very much for your help.
David Hervieux
It's now available here:
http://remotedesktopmanager.com/Home/Download#beta
David Hervieux