Currently we have a few users that are not members of our domain, but we'd like them to connect to our SQL instance of our datasource which used Integrated Authentication. Machines that are members of the domain work beautifully, and the users have accounts.
Is there a way that you could introduce a method to allow us to specify those credentials when making the SQL connection to those?
Currently we can do it in other applications (e.g. SQL Management Studio) by performing a:
"RUNAS /userOMAIN\user /netonly "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"" to run the application.
However when we do this to RDM, it doesn't seem to work as expected, nor in the same way.
Would this be something you'd consider adding?
Thanks for makin' a great product! Keep it up!
If you installed your SQL Server in mixed mode, you can create specific user in the database. It's the default installation mode and the default user is sa. By using the RDM application, you can create those user. This way, you user will be identified as a SQL user and not one from your domain.
Is is a possible solution for you ?
I wish it was, but unfortunatly, our corporate security policy dictates we aren't able to do so. We've gotten around it in some cases by using the method below, however, for some reason, RDM, doesn't work using it. =(