Which TCP/IP Port Numbers Are Used by Imorgon?
What Exceptions Do I need to Create in Microsoft Firewall
Discovering and/or Fixing the SQL Imorgon Instance Port Number (Dynamically Assigned)
- From the Start menu, Go to "Microsoft SQL Server 2005", "Configuration Tools" and open "SQL Server Configuration Manager"
- From the SQL Server Configuration Manager on the left panel, find SQL Server 2005 Network Configuration. Click to reveal additional configurations inside this "tree."
- Find Protocols for Imorgon. Click it, and all supported protocols will appear on the right.
- Be sure that TCP/IP is enabled.
- Click the TCP/IP protocol icon to reveal its configuration.
- Select the "IP Address" Tab.
- Scroll all the way down to this dialogbox, you will find IPAll section. Check in "TCP Dynamic Ports" and read off the port number. This is the port number that Imorgon SQL Instance listens to. To fix this port number to something consistent blank out the Dynamic port number and type in our default choice of 3441 there and restart the SQL service. Telnet to the port 3441 remotely to make sure that it is now active.
How To Diagnose the SQL Browser Port Blocking Issue
To diagnose if the SQL browser port is being blocked, you can use Microsoft ODBC configuration to test this. Please also know the port number of the Imorgon Instance as described above.
- Go to Control Panel: Administrative Tools.
- Open Data Sources (ODBC)
- Under the User DSN tab, press "Add..."
- Under the Create New Data Source window, scroll all the way down and select SQL Server. Press Finish.
- Under the Create a New Data Source to SQL Server window type in IMORGON in the name field, Imorgon Test in the Description Field and type in the name or the IP address of the Imorgon principal server a \ and IMORGON (e.g. IMSERVER\IMORGON) in the Server field.
- Press Next
- Select "With SQL server authentication using a login ID and password entered by the user."
- In the Login ID field type in sa
- In the Password filed type in searidge2 (or appropriate password)
- If at this point the screen goes to the next page (with Change the default database field) right away then it can find the instance using the SQL Browser. If it hangs, you have either forgotten to type in the "\IMORGON" in the server field of the first screen, or the SQL Browser is blocked.
- To make sure that actual SQL Connection works, go to the first page where you typed in the Server and instance name and specify the port number directly. To do this you type in the Sever name, a comma, and the port without leaving any space. For example instead of of typing in IMSERVER\IMORGON, you would type in IMSERVER,3411 provided that the server instance is using the port 3411.
UDP Port 1434 Blocked Issue: Microsoft Detection Tool
It is not uncommon for UDP traffic on port 1434 to be blocked for security reasons. When this is the case, SQL Browser does not return the dynamic port number and static ports should be used instead.
Troubleshooting can be difficult depending on where UDP 1434 is blocked. If blocking is done at the router between subnets, SQL Browser will work if the remote machine is on the same subnet, but not if it is across the router boundary on another subnet.
Microsoft has a free tool called PortQry for troubleshooting ports. It is available for download fromhttp://www.microsoft.com/downloads/details.aspx?FamilyID=89811747-C74B-4638-A2D5-AC828BDC6983&displaylang=en. Run PortQry from a command prompt using syntax similar to this:
portqry -n ipAddressOrMachineName -e 1434 -p UDP
If 1434 is blocked, the last line returned from PortQry looks like this:
UDP port 1434 (ms-sql-m service): FILTERED
If a static port is assigned to a named instance, a client alias can be used instead of putting the static port number into connection strings.
TCP Port 135 Block Issue For SQL Server Management Studio Accessing "Other" Server
If the port 135 is blocked and if you try to use Microsoft SQL Server Management Studio, you will get the following error message. SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified.