Forums Register Login

SQL Server - netbeans Connection problem

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
Hi,

Where are the authentication details to the server ?? You have'nt provided that in the connection string.

Try below link

http://lijinjoseji.wordpress.com/2008/03/31/possible-solutions-for-jdbc-sql-server-connection-problem/

OR

http://www.devx.com/dbzone/Article/33681

Cheers,

Ujjwal B Soni

<baroda>
<gujarat>
<india>
<919998971048>
+Pie Number of slices to send: Send
thanks ujjwal

i use windows authuntication

i add this to the connection string

integratedsecurit = true

so i maked it before

any other suggestions
+Pie Number of slices to send: Send
okay there is 2 news one is good and other is bad

the first problem solved
but a second problem aroused

the jdbc driver dosnt support the integrated authuntication
so we used the dll file comes with the installation

i'm using a netbeans IDE so i wand to cearte a new connection

but it always fail

so pleas tell me how to solve this problem

thank you


+Pie Number of slices to send: Send
Hi,

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.

Cheers!!!

Ujjwal B Soni
+Pie Number of slices to send: Send
 

ujjwal soni wrote:Hi,

You are programming in java right ? If yes then java supports jar files as libraries not DLL files.


...unless your Java code calls native code, as it does when trying to use MSSQL driver and Windows Integrated authentication.

I would second your concerns about using Windows Integrated security in the first place though.
Water proof donuts! Eat them while reading this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 14051 times.
Similar Threads
No suitable driver found for JDBC
Trouble Connectiing
com.microsoft.sqlserver.jdbc.SQLServerException is troubling me can any help please
SQL Database to Java using JDBC
SQLServerException - could not connect to the host on port 1433
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 15:33:37.