In azure i created 3 VMs.

1. Name: DC-VM, it’s the domain controller
2. DB-VM, it have sql server and SSMS
3. APP-VM, it have sharepoint server

I set up the DNS for all of them and configure a domain called ama.

I can ping all the VM from each other.

But when the time came to connect the sharepoint server to the data base i get an error :-

Cannot connect to database master at SQL at DB-VM the database might not exist, or the current user does not have permission to connect to it.

The user has all the permission need it to access this data base and I disabled the firewall in all VMs.

The user is configured in DC-VM (in Active Directory VM) and i add it to the data base users in DB-VM (data base VM).

In DB-VM i made sure that all protocols is enabled in sql server configuration manager and the keep Alive for TCP/IP is 1433

And all services under sql server services are running.

Note:
The 3 VMs are running when i try to connect.
In server permissions under security i selected SQL Server and windows Authentication mode
And under connections I selected Allow remote connections to this server

I’m stuck I don’t know where i have to go

Note:
The 3 VMs are running when i try to connect.
In server permissions under security i selected SQL Server and windows Authentication mode
And under connections I selected Allow remote connections to this server