I am a beginer in Azure and i have been trying to accomplish below scenario task:
I have created two Virtual Machine say vm1 and vm2. Virtual Machine(vm1) where I have have installed ADDS(Active Directory Domain Service): Window server 2012 R2 Domain Name: Say: TestDomain , ip:10.0.0.79
user : [email protected]
In Virtual Machine(vm2), i have installed Ms-SQL server 2015 is ruing and have database on it. Then I have added the Domain name and configure DNS on vm2 with respect to vm1(use same domain name:TestDomain and ip:10.0.0.79) In vm2, from MS-SQL, login with windows authenticaton mode,then Security >> Logins: Right click new user then Search(user: [email protected]) then give the permission to the database for user from vm1. Search that user from entire directory, then fetch , then gave database mapping and login entire permission to that user.
User appears: TestDomaintestuser
Now when i try to login to database using
User as: TestDomaintestuser or testuser or [email protected] and using same password that was used during creating in vm1 then i could not login.
I have look several links, but could not found solution.
Thank you in advance