Connect SQL Server to Java | JDBC | TCP/IP Error | SSL Error | Authentication DLL Error | All fixed
Вставка
- Опубліковано 16 вер 2024
- Connecting #Microsoft_SQL_Server to #Java using #JDBC.
All the steps are explained.
JDK Download link: www.oracle.com...
JDBC Download link: docs.microsoft...
Tried to fix below issues/ error.
1. No suitable driver found for jdbc error fixed.
2. The Server sqlexpress is not configured to listen with TCP/ IP Error fixed.
3. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) Encryption error fixed.
4. Unable to load authentication DLL mssql-jdbc_auth-10.2.0.x64 Error Fixed.
5. The connection to the host (server name), named instance sqlexpress failed error fixed.
If this video helped you, then don't forget to subscribe.
Thankyou!
Do Subscribe to support me.
Thankyou!
this man is the glory and the fucking god. I really tried to solve this problem, literally i spend 5 hours trying and i did not get anything and with the help of this video i managed to get my web application working.
Haha💫.... Best commet so far.. thanks for your kind words,🙌
Best video for handling these errors, actually got me all the way to the end until integrationSecurity wasn't working for me, so I had to put manual user and password into the connection string along with encrypt = false and it worked
Thanks for the compliments💫
araay subscribe bhai sab kr dya like comment share sab yr tum na hotaai tu hamari koi aukaat nahi yr love you bro love you...
Are bhai 😅 rulaoge kya🤣🫂... Best comment💯
Thank you , solving all the errors one can face during the connection.
Most welcome 💫
Really great man 🤟🏻 tried hell lot of methods but you helped me out in a single go thanks much 🎉
Happy to help
Thank you! You helped me a lot! God bless you. Please make more video on how we can execute the query from the database and how to validate stored data.
Most welcome💫
all problems are here, thank u so much
Happy to help
your awesome sir, you explained things with versions matching, i have been looking for this type of video where you explained by showing the versions used and errors one by one, but i could not find like this anywhere else, thankyou so much, i have been working for this connection establishment from past 3 to 4 days. now it is connected.
Glad it helped
Thank You Bro for making such an informational error. God bless You Aameen.........
Welcome brother 💫
after 2 hours of searching u helped me so much thanks man , i was getting sick form ssl socket error!!!
Glad I could help 💫💫
ThankYou so much !!! Really Helpful
once again thankyou sir, i am refering this video twice, after long gap i reset my pc and for setup ssms this video helped me
Glad helped you twice😁
ERROR
java.sql.SQLException: I/O exception while talking to the server, java.io.EOFException Unable to connect, please check your server's version and availability.
PC-Configuration
1) Operating System - Windows 11
2) Microsoft SQL Server Enterprise Core-based Licensing (64-bit) 2019
3) SQL Server Management Studio v18.0 - 15.0.18369.0
4) JDK - jdk1.8.0_181
5) JRE - jre1.8.0_181
6) Apache Tomcat - apache-tomcat-9.0.44
7) STS (Spring Tool Suite) - Latest Version
Please help me
Thanks Man, Its working.
Welcome buddy 💫
That's great. you are like a savior to help me out of this mess. Thank you so much
Glad to help💫
thank you so much, it solved my problem . keep helping people
I was looking to solve the problems I had. Thank you very much, very good video and explanation.
Great to hear!
THANK YOU SO MUCH, I DID IT WITH YOUR HELP
Thank you very much
Most welcome,💫
Thanks dude! It really helped me a lot.
💫🫂
thanks boss you are brilliant too much really applaud
So nice of you
thanks alot
Thank you for solving this error.
Welcome💫
i cant thank you enough been struggling with all these errors all day! and thanks for the English captions helped a lot to understand have an amazing day sir!!
Most welcome buddy💫
t establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]. ClientConnectionId:e5f9379f-732c-4684-accb-c57c0e1d40c0
BUILD SUCCESSFUL (total time: 0 seconds) mera yeh a raha kaya kero
I am getting this error : "Integrated authentication failed. ClientConnectionId:4216ea9f-5cd9-4314-b6a3-dcbecc25b4e7"
Thanks for the help..
💫
It is bit urgent ! where to paste mssql-jdbc_auth-12.6.1.x64.dll file in mac
Thank you very much it worked. But I want to bring one point, Is it necessary to set TCP/IP port. I didn't set any and connection is established for me.
Your most welcome✅💫..... I got the error at that time so I had to set.... May be now there is no need anyways this video is more than a year old.... Tech changes✅💯
Worked for me. Thanks
You're welcome!
Getting Error : "Caused by: org.hibernate.exception.SQLGrammarException: Unable to open JDBC Connection for DDL execution" while using MS SQL
im getting this error
Error: This driver is not configured for integrated authentication. ClientConnectionId:1eb15706-194f-47a3-80a8-aee15c67ec29
can you help?
How to implement after connected to database?
Like how to get/alter data in tabels from eclipse
You saved me THANK YOU!
You're welcome!
thx!! you are my savior!!
Any time💫
SQL server Exception
Your are my angel!!!!!!!!!!!!!!!!!!!
So nice of you 💫
How to resolve connection reset
We are facing this issue every time in the application end.
Please advise
Sorry, I have no idea.
YOU SO AWESOME THANK YOU SOOOO MUCH
Welcome and thanks, 💯
thank u man, u have saved me
You are welcome!
Hi, I still got an error message " Login failed for user ''. ClientConnectionId:6e03e4fb-60e5-45b7-920d-fd433ab7e115"
can you help me out? kinda urgent
Please try again with all the steps shown in this video
how to fix ssl error with sql server auth on local machine
i am still having ssl handshake exception
Would you like to try this on Java 8 instead. Not sure if it will work.
Will try
Thanks you bhai
Welcome!!
Thanks bro ✨❤️
Any time
thankyou man!
Happy to help!
ty very much
Welcome!
servlet se kaise connect kare? driver not found exception aa raha hai ....jar file add kar di
I am too getting the same error for servlet connection
thanks a lot bro
Always welcome
thanks bro
Any time
Brother how to fix this error in MAC OS?
Sorry man, I am not sure
Still it's giving error
May be uninstall and then try again
you really helped me a lot, you are amazing man, thank you so much. I admire you. ❤❤❤
Thankyou so much ,for you kind words💫
Really thank you for the video. I'm using Windows Authentication but the java program is running from the Linux VM. The connection string is as follows:
jdbc:sqlserver://:1433;databaseName=DB;authenticationScheme=JavaKerberos;trustServerCertificate=true;integratedSecurity=true;domain=;
But getting the following error
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot login with Kerberos principal saawn.joritzswddb, check your credentials. Kerberos Login failed: Integrated authentication failed. ClientConnectionId:6a499405-641f-4ee3-bf27-469c569e0820 due to javax.security.auth.login.LoginException (KrbException: Cannot locate default realm)
Can you help on this?
Thanks for the compliment, but sorry, the only things I know are in this video.
This driver is not configured for integrated authentication. ClientConnectionId:5a093b36-6172-4ef3-9831-ef883af486a2--- ed by: java.lang.UnsatisfiedLinkError: Unable to load authentication DLL mssql-jdbc_auth-11.2.1.x64 already copied file in jdk bin folder but still getting error
jdbc:sqlserver://DESKTOP-*******\SQLEXPRESS;encrypt=true;trustServerCertificate=true;databaseName=data1;integratedSecurity=true;
thank you so much 😃
You're welcome 😊