SQL SERVER HYBRID CONNECTION SETUP GUIDE

todo.txt

================================================================================
SQL SERVER HYBRID CONNECTION SETUP GUIDE
Port 1435 Configuration for Modern Web Apps (ODBC 17/18)
================================================================================

OVERVIEW
--------
- Target: Configure SQL Server to accept connections on port 1435 for hybrid connections
- Default port 1433: Used by web apps in same environment (ODBC 11)
- Port 1435: Used by modern web apps via hybrid connection (ODBC 17/18)
- Challenge: Modern apps (ODBC 17/18) connecting to older SQL Server (ODBC 11)


================================================================================
STEP 1: CONFIGURE SQL SERVER TO LISTEN ON PORT 1435
================================================================================

Using SQL Server Configuration Manager:

1. Open SQL Server Configuration Manager

2. Navigate to:
   SQL Server Network Configuration → Protocols for [Your Instance Name]

3. Right-click TCP/IP → Properties

4. Go to the IP Addresses tab

5. Scroll to IPAll section at the bottom:
   - TCP Dynamic Ports: Clear any value (make it blank)
   - TCP Port: Add both ports: 1433,1435

6. Click OK

7. IMPORTANT: Restart SQL Server service for changes to take effect
   - Open Services (services.msc)
   - Find SQL Server ([Instance Name])
   - Right-click → Restart


================================================================================
STEP 2: CONFIGURE WINDOWS FIREWALL
================================================================================

1. Open Windows Firewall with Advanced Security

2. Click Inbound Rules → New Rule

3. Configure the rule:
   - Rule Type: Port
   - Protocol: TCP
   - Specific local ports: 1435
   - Action: Allow the connection
   - Profile: Check all (Domain, Private, Public) as needed
   - Name: SQL Server Port 1435 - Hybrid Connection
   - Description: Allow hybrid connection traffic on port 1435

4. Click Finish


================================================================================
STEP 3: TEST THE NEW PORT CONFIGURATION
================================================================================

Option 1 - Using Telnet:
telnet [server-name-or-ip] 1435

Option 2 - Using PowerShell:
Test-NetConnection -ComputerName [server-name-or-ip] -Port 1435

Option 3 - Using SQL Server Management Studio:
- Server name: [server-name-or-ip],1435
- Authentication: SQL Server Authentication or Windows Authentication
- Click Connect


================================================================================
STEP 4: SET UP AZURE HYBRID CONNECTION
================================================================================

IN AZURE PORTAL:

1. Go to your App Service (the modern web app)

2. Navigate to: Networking → Hybrid connections

3. Click "Add hybrid connection" or "Configure your hybrid connection endpoints"

4. Create new hybrid connection:
   - Name: SQL-Server-1435 (or descriptive name)
   - Endpoint Host: Your SQL Server hostname or IP address
   - Endpoint Port: 1435
   - Service Bus Namespace: Select existing or create new
   
5. Click OK

INSTALL HYBRID CONNECTION MANAGER ON SQL SERVER:

1. In Azure Portal, after creating the hybrid connection, download the 
   Hybrid Connection Manager (HCM) installer

2. Run the installer on the machine hosting SQL Server

3. Sign in with your Azure credentials when prompted

4. Select the hybrid connection(s) you created

5. Verify the connection status shows as "Connected" in:
   - Azure Portal (Hybrid connections page)
   - Hybrid Connection Manager UI on the server