People Driven Software

by **Kris McClarnon** on Wed Mar 18, 2009 9:38 am

How to Find the Microsoft SQL Server Express TCP Port

Overview

The PDS Live Kiosk and PDS Live Desktop can connect to a local database on another computer provided that:

· The computer exists on the same network.

· The computer has been configured for offline access and has synchronized at least once.

· You know the name of the computer and the IP Port used be SQL server.

This document describes how to find the IP Port number.

1. On the computer that has been configured to work offline, go to Start: Run and enter SQLServerManager.msc and press OK.

2. Expand the SQL Server 2005 Network Configuration node.

3. Click Protocols for PDSOFFLINE.

4. In the right-pane, double-click TCP/IP.

5. Click the IP Address tab.

6. Scroll to the bottom and look for the TCP Port under the IPALL node.

7. Write this number down for use later.

Last Updated 8/21/2008
by Rick Ritts