When configuring Azure Active Directory (AD) Connect monitoring, you may experience SQL connection errors when TCP/IP is not enabled. Enabling TCP/IP is necessary to allow remote connections on the corresponding SQL server.
Follow this article to learn how to enable remote administration on the SQL Express server for Azure AD Connect monitoring.
Warning: this procedure does not apply to SQL Server 201x Express LocalDB version.
Configuring the SQL Server Express to accept remote connections:
- Log into your server through Remote Desktop Connection.
- Click Start - Programs - Microsoft SQL Server... and select SQL Server Configuration Manager:
- Select SQL Server Network Configuration:
- Double-click on Protocols for SQLEXPRESS:
- Right-click TCP/IP and select Properties:
- Scroll down to IPAll make sure TCP Dynamic Ports is blank and that TCP Port is set to 1433:
- Click OK.
- Make sure that port 1433 is enabled on your firewall.
You can now successfully configure your Azure AD Connect server for monitoring without SQL connection failures.
Microsoft Related articles
- How to: Configure Express to accept remote connections
- Configure the remote access Server Configuration Option