Knowledge Base
Popdock
Connector Setup
How to Find the TCP Port Number your SQL Instance is Listening on

How to Find the TCP Port Number your SQL Instance is Listening on

Published: Sep 01, 2023

Popdock
- Welcome to Popdock Documentation
SmartConnect
- Welcome to SmartConnect Documentation
- Adding Tasks to an Integration View Category
  - Creating document level run integration tasks in SmartConnect.com
  - Adding a Run Map Task
  - Adding an Email Task
- Creating an Integration Process View Category
  - Populating the Integration Details
  - Defining an Integration Source
  - Defining an Integration Target
  - Determining Source Grouping
  - Performing the Field Mapping
  - Using a Date Calculation
  - Using a Translation
  - Using a Custom Rolling Column
  - Defining Remaining Options
  - Using a Calculation
  - Using a Restriction
- Getting Started with SmartConnect.com View Category
  - Logging into the SmartConnect.com App
  - Adding Users to SmartConnect.com
  - Signing Up for a Plan
  - Determining your Subscription Tier
  - Adding an Initial User to SmartConnect.com
  - Switching Companies within SmartConnect.com
- Importing and Exporting Integrations View Category
  - Importing an Integration Process
  - Exporting an Integration Process
- Installing and Configuring SmartConnect 21 View Category
  - SmartConnect 21 Installation Steps
  - Configuring a SmartConnect 21 Instance
  - Configuring Additional SmartConnect 21 Instances
  - Updating SmartConnect 21 Configuration Options
  - Creating and Configuring the Windows Service in SmartConnect 21
  - Creating and Configuring the API in SmartConnect 21
- Maintaining Setup Options View Category
  - Setting Up Change Trigger Maintenance
  - Setting Up Integration Groups
  - Setting Up Translation Tables
  - Setting up Global Rolling Columns
  - Setting up Global Variables
- Navigating the Dashboard View Category
  - Viewing the Latest News, Links, and Videos Widgets
  - Reviewing the Login History Widget
  - Using the SmartConnect Processes Widget
  - Using the Quick Start Widget
- Setting Up Additional Functionality View Category
  - Create Integration Documentation
  - Using Error Processing to Correct Integration Process Failures
  - Scheduling an Integration Process
  - Managing Integration Schedules
- Working with Dynamics 365 Business Central View Category
  - Setting up a Dynamics 365 Business Central Connection
  - Creating a Dynamics 365 Business Central Bulk Data Source
  - Setting up an Integration to Dynamics 365 Business Central
  - Connecting to Dynamics 365 Business Central using an OAuth Token
  - Creating a Dynamics 365 Business Central Real-time Data Source
  - Creating a Dynamics 365 Business Central Change Data Source
  - Using an Odata Field Lookup
- Working with Dynamics 365 Finance View Category
  - Connecting to Dynamics 365 Finance using an OAuth Token
  - Creating a Dynamics 365 Finance Bulk Data Source
  - Setting up an Integration to Dynamics 365 Finance and Operations
  - Using a Dynamics 365 Finance Lookup
- Working with Dynamics 365 Customer Engagement / Sales View Category
  - Connecting to Dynamics 365 Customer Engagement using an OAuth Token
  - Creating a Dynamics 365 CE/Sales Bulk Data Source
  - Creating a Dynamics 365 CE/Sales Change Data Source
  - Creating a Dynamics 365 CE/Sales Real-Time Data Source
  - Setting up an Integration to Dynamics 365 CE/Sales
  - Using an Entity Lookup
  - Using a Multi Lookup
  - Using an Activity Party
  - Using an Entity Reference
  - Using a List Option Lookup
  - Using a Relationship
- Working with Dynamics CRM On-Prem View Category
  - Setting up a Dynamics CRM Connection
  - Creating a Dynamics CRM Bulk Data Source
  - Creating a Dynamics CRM Real-Time Data Source
  - Creating a Dynamics CRM Change Data Source
  - Setting up an Integration to Dynamics CRM
  - Using a MultiList Option Lookup
  - Using a List Option Lookup
  - Using a Multi Lookup
  - Using an Entity Lookup
  - Using an Activity Party
  - Using a Relationship
- Working with Dynamics NAV View Category
  - Setting up a Dynamics NAV Connection
  - Creating a Dynamics NAV Bulk Data Source
  - Setting up an Integration to Dynamics NAV
  - Using a Page Field Lookup
  - Using a Page Key Field Lookup
- Working with Dynamics NAV OData On-Prem View Category
  - Setting up a Dynamics NAV OData Connection
  - Creating a Dynamics NAV OData Bulk Data Source
  - Setting up an Integration to Dynamics NAV OData
  - Using an OData Field Lookup
- Working with Dynamics NAV Soap On-Prem View Category
  - Setting up a Dynamics NAV Soap Connection
  - Setting up an Integration to Dynamics NAV Soap
  - Creating a Dynamics NAV Soap Bulk Data Source
  - Using a Page Field Lookup
  - Using a Page Key Lookup
- Working with File Options View Category
  - Creating a Text Folder Data Source
  - Creating an XML Folder Data Source
  - Using a File Destination
  - Creating a XML File Source
  - Creating a Text File Source
  - Creating an Excel Source
  - Setting up a FTP Server Connection
  - Creating an Excel Folder Data Source
- Working with Generic Connections View Category
  - Creating an OLEDB Bulk Data Source
  - Creating an ODBC Bulk Data Source
  - Setting up an ODBC Connection
  - Setting up an OLEDB Connection
  - Troubleshooting ODBC Data Source Errors
- Working with Microsoft Graph View Category
  - Setting up a Microsoft Graph Odata Connection
  - Using Outlook as a Data Source
  - Using OneDrive as a Data Source
  - Using SharePoint as a Data Source
  - Creating a Teams Task
- Working with NetSuite View Category
  - Setting up a SuiteQL Lookup
  - Creating a SuiteQL Query Data Source
  - Setting up a NetSuite Connection
  - Creating a NetSuite Bulk Data Source
  - Creating a NetSuite Real-Time Data Source
  - Setting up an Integration to NetSuite
  - Setting up a Multi Lookup
  - Setting up a Reference Lookup
- Working with Popdock View Category
  - Setting up a Popdock Connection
  - Creating a Popdock Bulk Data Source
- Working with Pre-Defined Connectors View Category
  - Setting up a HubSpot Connector
  - Setting up a Magento Connector
  - Setting up a ShipStation Connector
  - Setting up a Shopify Connector
  - Setting up a Stripe Connector
  - Setting up a WooCommerce Connector
  - Setting up a Xero Connector
  - Setting up a Zendesk Connector
- Working with Salesforce View Category
  - Setting up a Salesforce OAuth Connection
  - Setting up a Salesforce Token Connection
  - Creating a Salesforce Bulk Data Source
  - Creating a Salesforce Change Data Source
  - Creating a Salesforce Real-Time Data Source
  - Setting up an Integration to Salesforce
  - Using an Entity Lookup
- Working with Slack View Category
  - Setting up a Slack Connection
  - Creating a Slack Task
- Working with SQL Server View Category
  - Setting up a SQL Server Connection
  - Creating a SQL Server Bulk Data Source
  - Creating a SQL Server Real-Time Data Source
  - Creating a SQL Server Change Data Source
  - Setting up an Integration to SQL Server
- Working with the REST Connector View Category
  - Configuring Base Settings
  - Configuring Service Entities for Data Sources
  - Creating a REST Service Definition
  - Adding a REST Service Connection
  - Configuring Exchange Token Authentication
  - Configuring OAuth2 Authentication
  - Creating a Service Data Source Definition
  - Adding a Bulk Service Data Source
  - Configure Data Source Paging
  - Creating a Service Destination Definition
  - Setting up an Integration to a REST Service
  - Creating a Service Lookup
  - Using a Service Lookup
  - Using Service Variables
  - Using Error Handling
- Working with Trello View Category
  - Setting up a Trello Connection
  - Creating a Trello Task
Zendesk Apps
- Zendesk Salesforce Connector View Category

How to Find the TCP Port Number your SQL Instance is Listening on

Published: Sep 01, 2023

By default SQL Server listens on TCP port number 1433, but for named instances the TCP port is dynamically configured. There are several options available to get the listening port for a SQL Server named instance.

Here is one way to get this information.

SQL Server Configuration Manager

1. Go to Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager.

2. Go to SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for <your Database>.

3. Right click on TCP/IP and select Properties.

4. In the TCP/IP Properties dialog box, select the IP Addresses tab and scroll down to the IPAll group.

If SQL Server is configured to run on a static port, the port number will be available in the TCP Port box. If it is configured on a dynamic port, the current port number will be available in the TCP Dynamic Ports box.

In the above example, the instance is listening on port number 49299.

If your port is configured with a dynamic port, once your SQL Instance is restarted it will create a new port so you will lose connection with Popdock and will need to reconnect your connector using the new port number.

Content

SQL Server Configuration Manager

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.

Get support