This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Struts and the fly likes MS SQL Server socket problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "MS SQL Server socket problem" Watch "MS SQL Server socket problem" New topic

MS SQL Server socket problem

Gigi Kent
Ranch Hand

Joined: Nov 30, 2004
Posts: 40
I'm working on a struts based aplication and a have a problem:
on my computer everithing is working juts fine, but I'm trying to deploy the application to another computer.
I've installed everithing but the big problem is that the application cannont conenct to te MS Sql server. I've installet SP3 but it' not working. The error is "Error establishing socket".
I know that this error is because sql server does not accept tcp connection, but I've installer SQL Server SP3, but the same.
In datasource in struts-config.xml it is a query validator. If I change the name of a table from my validation, the error is that the table name is wrong. So, theoreticaly the connection between my app and server is working, but if I change back with the correct name, it give me the same error .
I have Win 2000.
Please, maybe someone knows the answer to my problem.
For about 2 weeks I have this problem and I'm running out of time.
Don't get me started about those stupid light bulbs.
subject: MS SQL Server socket problem
Similar Threads active Connections issue...
MS SQL Server 2005 Authentication
access sql server database from WSAD 5.1.2
Entity beans and foreign keys
no active Connection...jdbc newbie