Jump to content

Any SQL Experts here?

Waifu4Life
By Waifu4Life
in Programs, Apps and Websites
 Share
Go to solution Solved by LogicalDrm,

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

Posted

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

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
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.
 

Spoiler

 

CPU Ryzen 5900X - Motherboard Asus ROG STRIX X570-E - RAM 16GB of G.SKILL NEON 3600 -
GPU EVGA RTX 3080 XC3 - Case Mastercase H500p mesh - PSU Seasonic Focus Gx-850 -
Corsair MP600 NVME 1 Tb, Samsung 960 PRO 500 Gb & 2 Seagate Baracuda 7200 RPM 2TB in stripe -
Display two VG27AQ 2K monitor - Cooling Corsair H150 Pro - 

Keyboard G-910 W/ Romer G tactile - Mouse G 502 Hero (wired) -
Sound Logitech X-530 and Razer Tiamat headphones

Operating System Windows 10

 

 

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Solution

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

^^^^ That's my post ^^^^
<-- This is me --- That's your scrollbar -->
vvvv Who's there? vvvv

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Author
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

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×