i'm trying to have a connection my abblication through netbeans and SQL server Express 2008
1- i downloaded the sqlserver JDBC drivers
2- i added it to the IDE 3- i checked my firwall and opend the port 1433
4- checked the sql configurion and enabled the TCPIP protocol
5- by using the msconfig command i checked the sql server service is running
and at last there is and exception
SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
i'm trying to solve it
i really dont remember the number of actions i did to solve this problem
i wish i could find help
You are programming in java right ? If yes then java supports jar files as libraries not DLL files. And, using windows authentication in SQL server is dangerous in terms of security concerns. So, i would suggest that you install the SQL Server in mixed mode authentication.
Ujjwal B Soni
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"