hi All,
i have imported my sql DB into azure, i have configured the SQL DB in RDM and it connect with out an issue, however when i try to access it i get:
System.Data.SqlClient.SqlException: Cannot open database "RDM" requested by the login. The login failed.
Login failed for user 'USERNAME'.
This session has been assigned a tracing ID of '2c6ad3cb-9baa-4a35-b986-bbf76bbf386f'. Provide this tracing ID to customer support when you need assistance.
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.DatabaseConnectionDataSource.GetData(String sql, IDbDataParameter[] parameters)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.GetDataSourceSettings()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadDataSourceSettingsFromDataSource(BaseConnectionDataSource newDataSource)
i know i need to add the user in the azure DB side but do you know where to do this?
Thanks James.
Hi,
If I remember correctly you can do that within RDM but make sure you've checked in the Data Source configuration Azure. You will need your Azure admin user for the initial connection.
David Hervieux
I got the initial connection.
i found a program to add users, needed to add a "login" first the a user for the server, then on the master AND the actual DB then all is good.