Unable to Connect to your Data Source error message
Hi All,
I was able to create the Data Source in MSSQL but now I am receiving "Unable to Connect to your Data Source" when doing various things in Remote Desktop Manager
I can't find a rhyme or reason why I'm getting this error message. I want to create the SQL data source instead of using XML.
Thank You!
System.Data.SqlClient.SqlException (0x80131904): Cannot find the login 'MYDOMAIN\xxxxxxx', because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbConnection dbConnection, IDbDataParameter[] parameters, Int32 commandTimeout)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerSecuritySubDataSource.ce57bff8d1ddc8948a77dee461f378db8(UserEntity cf98b881282579a38f0d3820b4755fa4a)
ClientConnectionId:22fadcfd-6318-4319-9e5f-a09e8d38119f
Error Number:15151,State:1,Class:16
All Comments (6)
Hello,
After creating the database in RDM, have you created the user in the Administration - Users section?
Which type of authentication are you trying to use?
I would also need a screenshot of your File - Datasources window please.
Best regards,
Jeff Dagenais
yes to user. In fact when I hit the "Users" tab I am receiving the error message there as well. Can you open a ticket and set up a time I can do a remote session? I don't really want to go back and forth here and posting images that have our server names and user IDs and whatnot. Thank You.
error.PNG
Greg,
Try to remove the SQL2 from your hostname. I had the same issue as you and that resolved it for me.
I say resolved, but I need to know why specifying the instance name does not work.
Hello,
Sorry for the delay of my reply. I had in mind that I have created the ticket regarding this, but it seems that I have not open it.
The ticket number is DEVO-1555. I've sent you an email from our ticketing system. Please just reply to my email.
Best regards,
Jeff Dagenais
Jeff (Devolutions)
Any comments on why (using Gregs example)
DCSTFS1V would work but DCSTFS1V\SQL2 would not?
In my case DCSTFS1V\SQL2 would work on the server where the SQL DB is installed but on other hosts I need to use DCSTFS1V. All other settings are identical as I used Custom installer to deploy.
If your server is configured as a named instance, then you must specify the named instance regardless if you are connecting to it via a remote machine or locally from the server.
In Greg's case his server must not have been a named instance.
You can test with SQL Server Management Studio (SSMS). Whatever the setting is that you are using in SSMS will be the same setting in RDM.
Stéfane Lavergne