Using AD credentials for MS SQL Server DB from non AD workstation
I am working remote from a non AD workstation. When I try to add a datasource with my AD credentials, it fails. From an AD computer with logged in with the AD credentials it works fine.
Is it possible to use AD credentials to access the RDM database from remote?
Thanks
Hello,
Indeed, it's not possible to enter the domain\username inside the username field to authenticate on the database.
Even SQL Server Management Studio (SSMS) doesn't accept this.
That being said, you would need to use the runas feature to accomplish what you are trying to accomplish
https://help.remotedesktopmanager.com/tipsandtricks_runas_manualrunas.htm
Best regards,
Jeff Dagenais
That works! Thanks