Connect to MSSQL database datasource using domain users from a non-domain-integrated Windows machine
Connect to MSSQL database datasource using domain users from a non-domain-integrated Windows machine
Hi,
I'm experiencing the following situation:
- Currently RDM for Mac v5.3.2 and RDM for Windows v13.5.8
- The database is in SQL Server 2016, users are created as Database users with Integrated Active Directory security option enabled
Under RDM for Mac I can create aData Source and connect to the SQL database by selecting Integrated Security and entering my domain username/password.
On RDM for Windows, if the computer has joined the domain then integrated security works just right, however, we have some Windows computers that we need outside the domain and still being able to connect to RDM using domain credentials, however, unlike the Mac behaviour, once you select Integrated security you can't enter username/password. The application doesn't seem to be aware that the computer has not joined any domain.
Is there any way to achieve this connection?
All Comments (3)
Hello,
You should use the "runas" command, here's a link to how to use it:
https://help.remotedesktopmanager.com/tipsandtricks_runas_manualrunas.htm
I hope this helps,
Regards,
Alex Belisle
Thank you Alex for your help,
With your advise I was able to solve the problem. In case anyone needs to solve this in the future as well, all I did was (Windows 10 machine, local administrator or local user with administrative privileges):
- Right click the existing RDM shortcut (or create a new one) and select Properties.
- Go to Shortcut tab, under Target type as follows:
%systemroot%\system32\runas.exe /netonly /user:domain\username "C:\Program Files (x86)\Devolutions\Remote Desktop Manager\RemoteDesktopManager64.exe"
Replacing domain\username for your actual username, also, your application path may be different depending on how you deploy it just preserve the original path that was on the shortcut.
- Click Apply and close the shortcut window. Once you double click the shortcut, a CMD window will appear prompting for the domain user password you just set in the shortcut target setting, once you type the password the prompt will close and after a brief period of time the RDM app should start, now configure the datasource to use Integrated security and should connect without issues.
Regards.
Hello,
Thanks for your feed back, much appreciated.
Regards,
Alex Belisle