windows authentication between host and VM

Question

I have created a VM (using Hyper V) that has Sql Server installed (win server os).

I want my host (or possibly another VM) to be able to access the SQL Server using windows authentication (sql server authentication works).

Can someone give me a jump start/guide for what I need to do to achieve this?

Answer 1

To make this really work as you have planned you should have on active directory setup. So host machine and VM would be part of same AD domain.

I am very sorry but I don't have time create full instruction for this but in general steps would be:

1. Both VM's in same network with static IP settings
2. select local domain name, ex. test.local
3. setup AD & DNS on clean VM, this will be your domain controller (DC)
4. Create new VM for SQL server -server. Join in to test.local domain before installing SQL server
5. Install SQL server in SQL server VM using domain account