Tomcat & SqlServer2000 connection?

[Pourang Emami]

I have a struts-based application running under the following environment:

OS: Win XP-Pro
Application Server: Tomcat
DBMA: SQL Server 2000

It always worked fine, till I installed WinXP-Pack2 and McAfee Stinger. Now the application can not establish a socket to the DBMS, and I get SqlException.

1-Could pack2 be the reason?
2-What should I do?

Any help would be highly appreciated.

Thank You,
Pourang Emami(SCJP, SCBCD)

[Jeanne Boyarsky]

Pourang,
My guess is that the service pack closed a port that used to be open. Check to see if you can ping the port that the database is on.

[Pourang Emami]

You are right. It is a common problem with WinXP-SP2 and SqlServer. I followed the instructions given in the following link, but my problem is still unsolved!?
Any help would be appreciated.

http://www.docs.com/HelpFiles/WindowsXPServicePack2Fix.htm


Thank You

[Mark Spritzler]

Not sure which would be the correct forum for this question. But since, it has been answered, I am just going to close this thread instead.

Please refrain from posting off-topic questions. This forum is for Servlets questions only. Your question is specific to Windows and SQLServer, and not Servlets.

Thanks

Mark