Connection to SQL Server
Hello
I have an AD Service User DOMAIN\rdm.service and also created a login at our SQL Server and gave sysadmin permission to create a new RDM DB. If a start the Remote Desktop Manager with this user and use integrated security, then I can contact the DB Server. But if I type in exactly these user credentials I get a warning, that RDM is unable to connect to the SQL Server. Any hint for this?
Thanks in advance
All Comments (3)
When authenticating to SQL Server using Integrated Security you can not specify the username/password. You must use "run as" trick as described here:
http://help.remotedesktopmanager.com/index.html?tipsandtricks_runas_rdm.htm
This is a limitation (as per designed) for any Windows application that uses Integrated Security.
Best regards,
Stéfane Lavergne
Thanks for your reply, but your answer doesn't fit to my problem.
I can contact DB Server, if I start RDM with mentioned credentials and use integrated authentication.
I cannot contact DB Server, if I start RDM with another user and type in mentioned credentials by hand and do not use integrated authentication. It seems that the applications security context is used to contact the DB Server and not the data source credentials.
Can you reproduce my problem?
Integrated authentication will always start using the Windows credential (or credentials supplied via runas/netonly). Not sure what you mean by "if I start RDM with mentioned credentials"? You performed a runas?
When connecting to SQL with Windows credentials you cannot specify the username/password directly. It will not work regardless of the application you are trying to connect with (RDM or other application). Try it, open SQL Server Management Studio (SSMS) and try connecting with the same credentials (specify the credentials). If you want to specify username/password explicitly you must do so using a SQL Login (sa for example).
Stéfane Lavergne