August 15, 2006 at 6:18 pm
I've installed MS SQL 2000 on my laptop running xp professional and for some reason my java application can't connect to the db. When i try telnet localhost 1433 the connection is refused. Norton came loaded on the laptop so I removed that, I've also disabled the windows firewall.
I since installed AVG antivirus and did a complete scan and no viruses. I've doublechecked the installation of SQL and TCP/IP is enabled on default port 1433. I tried changing that to 21433, restarting SQL service and still nothing.
Anyone have any suggestions?!?!
p.s. I'm able to run query analyser and enterprise manager without any probs.
August 16, 2006 at 2:28 am
You also have to tell SQL Server which port to listen on. The same port you use for SQL server, must be opened in the firewall Norton provide.
N 56°04'39.16"
E 12°55'05.25"
August 17, 2006 at 9:57 am
Disabling the Windows Firewall is a bad idea if the laptop is ever out of your corporate environment, where you are protected by the firewall at the perimeter. However, if it is disabled, you should be able to connect without a problem. You need both TCP and UDP protocols enabled on that port.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
August 17, 2006 at 8:06 pm
I had the same problem and found out that the port number in the registry was not set. There is a KB article regarding this issue. Sorry, can't remember the KB number. After setting the port number manually, my Java app has no more issue with MSDE.
rgds
BH Ong
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply