Connecting VMs to SQL

I have several VMs on my computer which I want to connect to the SQL installed on my laptop.  Is that possible?  my computer is joined to my company's domain, but the VMs are not.  The issues I am experiencing appear to be related to authentication.
red_75116Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if the VM/SQL is not joined to the domain, you HAVE to create and use a SQL login that is NOT based on windows authentication.
explanation: the VM /Windows cannot "check" your domain windows account (as it's not joined to the domain)

so: create in the SQL Server Security a non-windows based login (with password), and use that for the login.
0
 
radcaesarCommented:
Is the VMs instance of SQL Server are exposed to public using a static IP?

If Yes, You can connect to that instance using SQL Server authentication.

Another option is, You need to tunnel your VMs to your company's domain using VPN and then you can connect.
0
 
Kobe_LenjouCommented:
The VM's are on your network right?
0
 
red_75116Author Commented:
No, my laptop is on my network joined to the domain and the VMs are not.  I supposed another option would be to have a VM that is only sql and let the other VMs connect to that.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.