Remote Connection 1

[DanJR]

I have developed a client-server application which the server side is MS SQL Server 2000 and the client app is developed in Java.

At home, I have Office XP developers version installed on my machine and my java app can connect to ms sql server fine - using localhost or my computer name as the server name. Interestingly, when i specify my ip address as the server name the connection fails. When I put the app on another computer on my home network it wouldn't connect to the sql server on my machine. Both computers are on the same subnet.

I did a port scan from my computer and port 1433 was 'visible', but when I did a port scan from the other computer on the same subnet, port 1433 (on my computer) was not visible - why?

What settings(?) could possibly be making the port 1433 'invisible' to other computers on the same subnet???

Any help would be much appreciated...

...or, is this just a sign of lack of sleep?

cheers,
dan

 

[JamesLean]

The usual cause is some kind of firewall in the way. Are you running one on your machine (or anywhere on the network)? If you're using Win XP have you got the native firewall enabled on your LAN connection?

--James

 

[DanJR]

oops, i'm rather imbarrassed here - i made a mistake in the application when reporting errors to the user - the reason for the application not being able to connect was because the app could not find the jdbc driver, which occured because I missed it out of my build.xml file! It worked on my local machine because i was testing the jar within the same directory as my source code! It all works now. Not sure why the port scanner didn't pick up 1433.

thanks for spending time on this james.

cheers,
dan