This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
Can you connect to the DB using the exact same code from a desktop application?
I haven't tried this...
have you enabled TCP/IP support on your server instance
I have read the manuals about How to manually enable TCP/IP on Windows XP sp 2 for SQL Server 2000 I added an open TCP port 1433 and name it SQL Server. I also added an open UDP port 1434 and name it SQL Server UDP.. However, the problem remains.. When I open command prompt and type netstat -an, both ports are not on the listening list. I also open the browser and go to the application..it throws the same error..
Have you configured your server to allow SQL Server authentication?