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

"Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote


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

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" <jbellnewsposts (AT) hotmail (DOT) com> wrote

Loku John (ks.senanayake (AT) gmail (DOT) com) writes:
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, esquel (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

"Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote

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

"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

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

"Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote

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

I Disable the firewall (Both Ends)


"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

"Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote


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

Loku John (ks.senanayake (AT) gmail (DOT) 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, esquel (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx