Any SQL Experts here?

[Waifu4Life]

Hi there,

 

I was wondering, without creating an SQL user in an SQL instance, is it possible to open a database using SMSS when you're not within the domain where the DB reside. In short, I want to query the a DB using my domain user form where the SQL server resides without remoting to it, just from within SMSS which is locally installed on my computer.

 

Cheers

[Quickstrike]

55 minutes ago, the_importer said:

is it possible to open a database using SMSS when you're not within the domain where the DB reside

You'll have to work with your security team to create a bypass to circumvent all the security.

A possible workaround is to establish an SSH tunnel to wherever (ip and port) with an existing user and that would establish a secure access to you instance.
 

[LogicalDrm]

Usually this is done with SSH or VPN connection tailor-made for each companies security solution.

[Waifu4Life]

On 9/24/2020 at 5:28 AM, LogicalDrm said:

Usually this is done with SSH or VPN connection tailor-made for each companies security solution.

Of course, VPN, why didn't I think of this!

 

Cheers mate