Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
port number of SQL Server

In SQL Server - What ports need to be opened on the firewall to get access

share|improve this question

migrated from Sep 18 '10 at 12:24

This question came from our site for professional and enthusiast programmers.

marked as duplicate by Chris S Feb 16 '12 at 15:10

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Belongs on Server Fault. Is this default or named instance? – Martin Smith Sep 17 '10 at 11:48

By default, MS SQL Server doesn't have the TCP/IP protocol enabled. You have to open Sql Server Configuration Manager, enable the TCP/IP protocol, customize port if needed (default is 1433), and restart the service.

share|improve this answer

Since you didn't specify much information, I'll go with the half-a-second Google route:

Leads to:

share|improve this answer

Try to specify tcp/ip port 1433

share|improve this answer

By default, TCP port 1433 is used.

share|improve this answer

I think by default the SQL server instances run on port number 1433. But I think it can be configured to run on other ports too.

You can find on which port your sql instance is running by following this -

Using the GUI: In SQL Server 2005, you can use the SQL Server Configuration Manager. Look under SQL Server 2005 Network Configuration and look at the TCP port for the TCP/IP protocol.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.