Friday, February 10, 2012

CONNECTION PROBLEM ON WIN2003

hi
i have sqlserver that running on windows 2003
i have connecton to this server from an other computer
and i need tcp/ip connection to this sql server
but i cant connect to this sql with this port
when i use netstat -an i dont see this port(1433) on protocal list and
also
icant telnet to this server with this port
can you tell me how can i solve this problem
* note : tcp/ip protecol is enabledIs there a firewall between you and the server? If so, make sure port
1433 is open, most firewall setups these days block that port for
security.|||Perhaps, it is not listening on 1433. Go to the errorlog for the SQL
instance and verify the TCP port it is listening on, or use TcpView.exe from
www.sysinternals.com, though TcpView doesn't always display the port number
of a listening server.
Also from this other computer, to be sure, I'd try (or use whatever the
listening port):
cmd>osql.exe -Stcp:<IP address>,1433 -Uuser -Ppassword
If it doesn't work, remote desktop to the server, and try the above locally.
Linchi
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:uuP7jp$0FHA.3892@.TK2MSFTNGP12.phx.gbl...
> hi
> i have sqlserver that running on windows 2003
> i have connecton to this server from an other computer
> and i need tcp/ip connection to this sql server
> but i cant connect to this sql with this port
> when i use netstat -an i dont see this port(1433) on protocal list
> and also
> icant telnet to this server with this port
> can you tell me how can i solve this problem
> * note : tcp/ip protecol is enabled
>
>|||I asked my ISP and they said there is no firewall or blocking on this port..
They also said they cant reach on this port and something wrong with sql
set up.. On my local pc i wrote netstat (there is no problem on my local
sql) i didnt see 1433 port.. Therefore i checked my port number from server
utilities from sql server it was 1433.. What can it be ?
"Savas Ates" <savas@.indexinteractive.com>, haber iletisinde unlar
yazd:uuP7jp$0FHA.3892@.TK2MSFTNGP12.phx.gbl...
> hi
> i have sqlserver that running on windows 2003
> i have connecton to this server from an other computer
> and i need tcp/ip connection to this sql server
> but i cant connect to this sql with this port
> when i use netstat -an i dont see this port(1433) on protocal list
> and also
> icant telnet to this server with this port
> can you tell me how can i solve this problem
> * note : tcp/ip protecol is enabled
>
>

No comments:

Post a Comment