Using AD credentials for MS SQL Server DB from non AD workstation

Using AD credentials for MS SQL Server DB from non AD workstation

avatar
fernando02
Disabled

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

All Comments (2)

avatar

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

avatar

That works! Thanks