Share
Report
144Hello,
we are trying to connect to the SQL Server on a Dynamics 365 for Finance and Operations 8.1 Virtual Machine. The VM was deployed online on azure over LCS.
We tried to connect to the Server from several other servers in different networks by ODBC (with ODBC Driver for SQL Server Version 12.00.5000, with SQL Server Native Client 11.0 and with SQL Server SQLSRV32.DLL Version 10.00.17134.01) and with SQL Management Studio. Error: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections"
We followed the instructions on this doc: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-connect
That means we:
1. Enabled the TCP/IP protocol in the SQL Server 2016 Configuration and made sure the sql server listens on port 1433
2. Configured a firewall rule for inbound TCP port 1433
3. Enabled SQL Server Authentication in the SSMS and allowed remote connections
4. Configured the network security group on the Azure portal of the VM to allow inbound traffic on port 1433
Has anyone tried to connect to a D365FO-VM-SQL-Server before and found a solution for this?
Thank you for any help,
Tino
All responses (
Answers (
