 | |
Cannot Open Port 1433
microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Cannot Open Port 1433 -
09-23-2009
, 02:03 AM
|
"Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote in message news:Otfc5%231OKHA.4700 (AT) TK2MSFTNGP05 (DOT) phx.gbl... I Disable the firewall (Both Ends) "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message news:%23Sn%23Fc0OKHA.5108 (AT) TK2MSFTNGP02 (DOT) phx.gbl... "Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote in message news:eF0GMK0OKHA.5128 (AT) TK2MSFTNGP02 (DOT) phx.gbl... "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message news:%23HGq$KwOKHA.3192 (AT) TK2MSFTNGP05 (DOT) phx.gbl... "Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote in message news:eWUGuNoOKHA.1236 (AT) TK2MSFTNGP05 (DOT) phx.gbl... 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 in message news:uQDxT%23nOKHA.3192 (AT) TK2MSFTNGP05 (DOT) phx.gbl... "Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote in message news:%23cQVownOKHA.508 (AT) TK2MSFTNGP06 (DOT) phx.gbl... 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 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 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 I Did in that way cannot telnet It says cannot open port 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 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 |
#12
| |||
| |||
|
|
"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message news:%23BYJ9b8OKHA.1796 (AT) TK2MSFTNGP02 (DOT) phx.gbl... "Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote in message news:Otfc5%231OKHA.4700 (AT) TK2MSFTNGP05 (DOT) phx.gbl... I Disable the firewall (Both Ends) "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message news:%23Sn%23Fc0OKHA.5108 (AT) TK2MSFTNGP02 (DOT) phx.gbl... "Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote in message news:eF0GMK0OKHA.5128 (AT) TK2MSFTNGP02 (DOT) phx.gbl... "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message news:%23HGq$KwOKHA.3192 (AT) TK2MSFTNGP05 (DOT) phx.gbl... "Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote in message news:eWUGuNoOKHA.1236 (AT) TK2MSFTNGP05 (DOT) phx.gbl... 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 in message news:uQDxT%23nOKHA.3192 (AT) TK2MSFTNGP05 (DOT) phx.gbl... "Loku John" <ks.senanayake (AT) gmail (DOT) com> wrote in message news:%23cQVownOKHA.508 (AT) TK2MSFTNGP06 (DOT) phx.gbl... 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 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 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 I Did in that way cannot telnet It says cannot open port 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 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 Its Not there... What shall I Do? That sounds like SQL Server is either not running or the protocol isn't |
John
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.