sql connection problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

sql connection problem

Author

Topic

syazdani
Starting Member

14 Posts

Posted - 2005-09-14 : 07:14:50

i have sqlserver 2000 that runs on windows xp spk2i have jdbc connecton to this server from an other computer
and i need tcp/ip connection to this sql server
java.sql.Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.30:1433;databasename=hsp", "sa","");

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
note msqlserver service running and tcp/ip enabled
note i cant register to this server from other client sql server
can you tell me how can i solve this problem

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-09-14 : 08:36:41

it's an issue with the personal firewall in winxp sp2. i think you have to allow an exception for sql server or turn it off.

====================================================
Regards,
Sean Roussy

"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?)

syazdani
Starting Member

14 Posts

Posted - 2005-09-15 : 02:53:11

firewall is off and
there isnt no listiner on port 1433
(when i register new instance client sqlserver that connect to my server that runs sqlserver and then i use netsatat -an
i see this client connect to this server from port 445 and not on 1433
but when i change port 1433 to 445 on my datasource cannot connect to server)

syazdani
Starting Member

14 Posts

Posted - 2005-09-18 : 07:39:29

i have local network
and all firewalls is off

there is no listiner for sql server

when i use netstat -an on windows 2000 i see
tcp 127.0.0.1:1433 0.0.0.0 listening
tcp 192.168.1.6:1433 0.0.0.0 listening
and i can telnet to this windows with port 1433

but i dont see this listiner for windows xp or 2003
and i cant telnet to these windows with port 1433

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources