www.gsx.com | log in | register

Last update: . Author: Christian Stokes .

How to Enable Remote Administration for Azure Active Directory Connect Monitoring

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.

SQL Express

Instructions

Warning: this procedure does not apply to SQL Server 201x Express LocalDB version.

Configuring the SQL Server Express to accept remote connections:

  1. Log into your server through Remote Desktop Connection.
  2. Click Start - Programs - Microsoft SQL Server... and select SQL Server Configuration Manager:
    SQL_Server_Configuration_Manager.gif
  3. Select SQL Server Network Configuration:
    SQL_Server_Network_Config.gif
  4. Double-click on Protocols for SQLEXPRESS:
    Protocols_for_SQLEXPRESS.gif
  5. Right-click TCP/IP and select Properties:
    TCP-IP_Properties.gif
  6. Scroll down to IPAll make sure TCP Dynamic Ports is blank and that TCP Port is set to 1433:
    Set_TCP_Port_to_1433.gif
  7. Click OK.
  8. 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



Not finding what you are looking for?

Have more questions? Submit a request


Was this article helpful?

0 out of 0 found this helpful