Cannot Open Port 1433

Loku John

unread,

Sep 21, 2009, 1:26:28 AM9/21/09

to

Dear Friends,

Im new to SQL and Windows Server 2003, I have configured the SQL server
2005 on Windows Server 2003 Starnderd version All the services of sql and
Windows are starting properly .I can connect to server from client pcs and
I can ping the server from client pc But I cannot open the port 1433 from
client end. How shall I Configure the port 1433 Please let me know
thanks in advance.

Loku John

John Bell

unread,

Sep 21, 2009, 1:51:32 AM9/21/09

to

"Loku John" <ks.sen...@gmail.com> wrote in message
news:%23cQVown...@TK2MSFTNGP06.phx.gbl...

Hi

This is probably your firewall that is blocking it and you would need to see
how that is configured.

You can find out which ports are being used by looking at the properties of
the protocol in configuration manager. If this is a named instance it may
not be using port 1433.

You may also want to check out http://support.microsoft.com/kb/287932

John

Loku John

unread,

Sep 21, 2009, 2:18:31 AM9/21/09

to

thanks
both sides I have disable the firewall but no luck any how thaks for ur
link I will chk that one.
Loku John

"John Bell" <jbellne...@hotmail.com> wrote in message
news:uQDxT%23nOKH...@TK2MSFTNGP05.phx.gbl...

Erland Sommarskog

unread,

Sep 21, 2009, 5:23:05 PM9/21/09

to

I'm not really sure what your problem is. If you cannot connect to the
server, then everything is working, isn't it?

There is no reason to open port 1433 on the client machines in any firewall.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

John Bell

unread,

Sep 21, 2009, 5:30:30 PM9/21/09

to

"Loku John" <ks.sen...@gmail.com> wrote in message

news:eWUGuNoO...@TK2MSFTNGP05.phx.gbl...

As Erland pointed out, the firewall on the client should not be stopping
this. Make sure that your protocols are enabled and that if you are using
SQLExpress that remote connections are configured
http://www.aspfaq.com/etiquette.asp?id=5006.

You can also try using telnet to connect to a given port on the server if
you want to make sure it is open.

John

Loku John

unread,

Sep 22, 2009, 1:06:35 AM9/22/09

to

"John Bell" <jbellne...@hotmail.com> wrote in message

news:%23HGq$KwOKH...@TK2MSFTNGP05.phx.gbl...

I Did in that way cannot telnet It says cannot open port

John Bell

unread,

Sep 22, 2009, 1:39:14 AM9/22/09

to

"Loku John" <ks.sen...@gmail.com> wrote in message

news:eF0GMK0O...@TK2MSFTNGP02.phx.gbl...

It seems I posted the wrong link for enabling remote connections it should
have been http://support.microsoft.com/kb/914277 But if you can not telnet
to the port it is not remote connections that is your initial problem. Are
you sure the firewall on the server is not blocking this?

John

Loku John

unread,

Sep 22, 2009, 4:35:25 AM9/22/09

to

I Disable the firewall (Both Ends)

"John Bell" <jbellne...@hotmail.com> wrote in message

news:%23Sn%23Fc0OK...@TK2MSFTNGP02.phx.gbl...

John Bell

unread,

Sep 22, 2009, 4:55:16 PM9/22/09

to

"Loku John" <ks.sen...@gmail.com> wrote in message

news:Otfc5%231OKH...@TK2MSFTNGP05.phx.gbl...

Hi

Did you check that port 1433 was being used by SQL Server netstat -b on the
server gives the application using the ports.

I assume nothing else is blocking this port in the middle?

John

Erland Sommarskog

unread,

Sep 22, 2009, 5:37:47 PM9/22/09

to

Loku John (ks.sen...@gmail.com) writes:
> I Disable the firewall (Both Ends)

And did you enable TCP as a protocol for SQL Server? Use SQL Configuration
Manager, and check Server Protocols. Note that if you enable a protocol,
you need to restart SQL Server.

Loku John

unread,

Sep 23, 2009, 3:03:24 AM9/23/09

to

"John Bell" <jbellne...@hotmail.com> wrote in message

news:%23BYJ9b8...@TK2MSFTNGP02.phx.gbl...

Its Not there... What shall I Do?

John Bell

unread,

Sep 23, 2009, 5:38:33 PM9/23/09

to

"Loku John" <ks.sen...@gmail.com> wrote in message

news:eLRURwB...@TK2MSFTNGP02.phx.gbl...

That sounds like SQL Server is either not running or the protocol isn't
enabled. I did ask you to check the protocols in my first reply!

John

kjhgfreae

unread,

Dec 2, 2009, 4:58:40 AM12/2/09

to

For SQLServer 2008, I found settings in the "Sql Server Configuration Manager" tool. Look under the "SQL Server Network Configuration" branch for "Protocols for <SQLEXPRESS>" and change your install to not use dynamic ports (clear out the default "0" entries and add 1433 to the static port fields).

Erland Sommarskog wrote:

Re: Cannot Open Port 1433
25-Sep-09

Loku John (ks.sen...@gmail.com) writes:

And did you enable TCP as a protocol for SQL Server? Use SQL Configuration
Manager, and check Server Protocols. Note that if you enable a protocol,
you need to restart SQL Server.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Previous Posts In This Thread:

On Monday, September 21, 2009 1:26 AM
Loku John wrote:

Cannot Open Port 1433
Dear Friends,

Im new to SQL and Windows Server 2003, I have configured the SQL server
2005 on Windows Server 2003 Starnderd version All the services of sql and
Windows are starting properly .I can connect to server from client pcs and
I can ping the server from client pc But I cannot open the port 1433 from
client end. How shall I Configure the port 1433 Please let me know
thanks in advance.

Loku John

On Monday, September 21, 2009 1:51 AM
John Bell wrote:

Re: Cannot Open Port 1433
Hi

This is probably your firewall that is blocking it and you would need to see
how that is configured.

You can find out which ports are being used by looking at the properties of
the protocol in configuration manager. If this is a named instance it may
not be using port 1433.

You may also want to check out http://support.microsoft.com/kb/287932

John

On Monday, September 21, 2009 2:18 AM
Loku John wrote:

thanksboth sides I have disable the firewall but no luck any how thaks for

thanks
both sides I have disable the firewall but no luck any how thaks for ur
link I will chk that one.
Loku John

On Monday, September 21, 2009 5:30 PM
John Bell wrote:

Re: Cannot Open Port 1433

As Erland pointed out, the firewall on the client should not be stopping
this. Make sure that your protocols are enabled and that if you are using
SQLExpress that remote connections are configured
http://www.aspfaq.com/etiquette.asp?id=5006.

You can also try using telnet to connect to a given port on the server if
you want to make sure it is open.

John

On Tuesday, September 22, 2009 1:06 AM
Loku John wrote:

Re: Cannot Open Port 1433

I Did in that way cannot telnet It says cannot open port

On Tuesday, September 22, 2009 1:39 AM
John Bell wrote:

Re: Cannot Open Port 1433

It seems I posted the wrong link for enabling remote connections it should
have been http://support.microsoft.com/kb/914277 But if you can not telnet
to the port it is not remote connections that is your initial problem. Are
you sure the firewall on the server is not blocking this?

John

On Tuesday, September 22, 2009 4:35 AM
Loku John wrote:

Re: Cannot Open Port 1433

I Disable the firewall (Both Ends)

On Tuesday, September 22, 2009 4:55 PM
John Bell wrote:

Re: Cannot Open Port 1433
Hi

Did you check that port 1433 was being used by SQL Server netstat -b on the
server gives the application using the ports.

I assume nothing else is blocking this port in the middle?

John

On Wednesday, September 23, 2009 3:03 AM
Loku John wrote:

Re: Cannot Open Port 1433

Its Not there... What shall I Do?

On Wednesday, September 23, 2009 5:38 PM
John Bell wrote:

Re: Cannot Open Port 1433
That sounds like SQL Server is either not running or the protocol is not

enabled. I did ask you to check the protocols in my first reply!

John

On Friday, September 25, 2009 10:40 PM
Erland Sommarskog wrote:

Re: Cannot Open Port 1433
Loku John (ks.sen...@gmail.com) writes:

I am not really sure what your problem is. If you cannot connect to the
server, then everything is working, is not it?

There is no reason to open port 1433 on the client machines in any firewall.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

On Friday, September 25, 2009 10:40 PM
Erland Sommarskog wrote:

Re: Cannot Open Port 1433
Loku John (ks.sen...@gmail.com) writes:

And did you enable TCP as a protocol for SQL Server? Use SQL Configuration
Manager, and check Server Protocols. Note that if you enable a protocol,
you need to restart SQL Server.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

On Wednesday, December 02, 2009 4:57 AM
kjhgf reae wrote:

For SQLServer 2008
For SQLServer 2008, I found settings in the "Sql Server Configuration Manager" tool. Look under the "SQL Server Network Configuration" branch for "Protocols for <SQLEXPRESS>" and change your install to not use dynamic ports (clear out the default "0" entries and add 1433 to the static port fields).

Submitted via EggHeadCafe - Software Developer Portal of Choice
Silverlight Developer Poll
http://www.eggheadcafe.com/tutorials/aspnet/9496fdd4-2364-4b7d-b2ba-4460c2623342/silverlight-developer-pol.aspx

kjhgfreae

unread,

Dec 2, 2009, 4:57:58 AM12/2/09

to

For SQLServer 2008, I found settings in the "Sql Server Configuration Manager" tool. Look under the "SQL Server Network Configuration" branch for "Protocols for <SQLEXPRESS>" and change your install to not use dynamic ports (clear out the default "0" entries and add 1433 to the static port fields).

Erland Sommarskog wrote:

Re: Cannot Open Port 1433
25-Sep-09

Loku John (ks.sen...@gmail.com) writes:

And did you enable TCP as a protocol for SQL Server? Use SQL Configuration
Manager, and check Server Protocols. Note that if you enable a protocol,
you need to restart SQL Server.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Previous Posts In This Thread:

Loku John

John

I Disable the firewall (Both Ends)

On Tuesday, September 22, 2009 4:55 PM
John Bell wrote:

Re: Cannot Open Port 1433
Hi

Did you check that port 1433 was being used by SQL Server netstat -b on the
server gives the application using the ports.

I assume nothing else is blocking this port in the middle?

John

On Wednesday, September 23, 2009 3:03 AM
Loku John wrote:

Re: Cannot Open Port 1433
Its Not there... What shall I Do?

On Wednesday, September 23, 2009 5:38 PM
John Bell wrote:

Re: Cannot Open Port 1433
That sounds like SQL Server is either not running or the protocol is not
enabled. I did ask you to check the protocols in my first reply!

John

On Friday, September 25, 2009 10:40 PM
Erland Sommarskog wrote:

Re: Cannot Open Port 1433

Loku John (ks.sen...@gmail.com) writes:

I am not really sure what your problem is. If you cannot connect to the
server, then everything is working, is not it?

There is no reason to open port 1433 on the client machines in any firewall.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

On Friday, September 25, 2009 10:40 PM
Erland Sommarskog wrote:

Re: Cannot Open Port 1433
Loku John (ks.sen...@gmail.com) writes:

And did you enable TCP as a protocol for SQL Server? Use SQL Configuration
Manager, and check Server Protocols. Note that if you enable a protocol,
you need to restart SQL Server.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Submitted via EggHeadCafe - Software Developer Portal of Choice

VB.Net DB-Enabled Xml Caching Tooltip DropDownList
http://www.eggheadcafe.com/tutorials/aspnet/71eabdac-1d08-415b-b7ff-6c7b89d33e7a/vbnet-dbenabled-xml-cac.aspx