Тёмный

Connect SQL Server to Java | JDBC | TCP/IP Error | SSL Error | Authentication DLL Error | All fixed 

Last Minute Coders
Подписаться 5 тыс.
Просмотров 21 тыс.
50% 1

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!

Опубликовано:

 

13 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 104   
@lastminutecoders
@lastminutecoders Год назад
Do Subscribe to support me. Thankyou!
@SangramBiswal-fl8gg
@SangramBiswal-fl8gg Год назад
Thank you , solving all the errors one can face during the connection.
@lastminutecoders
@lastminutecoders Год назад
Most welcome 💫
@fernandocardozo4008
@fernandocardozo4008 2 года назад
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.
@lastminutecoders
@lastminutecoders Год назад
Haha💫.... Best commet so far.. thanks for your kind words,🙌
@fights1300
@fights1300 Год назад
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
@lastminutecoders
@lastminutecoders Год назад
Thanks for the compliments💫
@sagarbs5833
@sagarbs5833 2 года назад
Really great man 🤟🏻 tried hell lot of methods but you helped me out in a single go thanks much 🎉
@lastminutecoders
@lastminutecoders Год назад
Happy to help
@kamrunkanta4696
@kamrunkanta4696 8 месяцев назад
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.
@lastminutecoders
@lastminutecoders 8 месяцев назад
Most welcome💫
@alwahabmalik
@alwahabmalik 7 месяцев назад
Thank You Bro for making such an informational error. God bless You Aameen.........
@lastminutecoders
@lastminutecoders 7 месяцев назад
Welcome brother 💫
@nprajwal420
@nprajwal420 Год назад
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.
@lastminutecoders
@lastminutecoders Год назад
Glad it helped
@anuragyadav7869
@anuragyadav7869 Год назад
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.
@lastminutecoders
@lastminutecoders Год назад
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✅💯
@nprajwal420
@nprajwal420 Год назад
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
@lastminutecoders
@lastminutecoders Год назад
Glad helped you twice😁
@andrewstudy-ji2vt
@andrewstudy-ji2vt Год назад
after 2 hours of searching u helped me so much thanks man , i was getting sick form ssl socket error!!!
@lastminutecoders
@lastminutecoders Год назад
Glad I could help 💫💫
@ndkhanhs_m01
@ndkhanhs_m01 Год назад
all problems are here, thank u so much
@lastminutecoders
@lastminutecoders Год назад
Happy to help
@SaifKhan-gx9lf
@SaifKhan-gx9lf 9 месяцев назад
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...
@lastminutecoders
@lastminutecoders 9 месяцев назад
Are bhai 😅 rulaoge kya🤣🫂... Best comment💯
@singh7shibs
@singh7shibs 11 месяцев назад
ThankYou so much !!! Really Helpful
@naeemrmaity5760
@naeemrmaity5760 Год назад
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!!
@lastminutecoders
@lastminutecoders Год назад
Most welcome buddy💫
@KapilDhapkale
@KapilDhapkale Год назад
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
@florencioaquije1422
@florencioaquije1422 2 года назад
I was looking to solve the problems I had. Thank you very much, very good video and explanation.
@lastminutecoders
@lastminutecoders Год назад
Great to hear!
@ashu_the_0ne
@ashu_the_0ne 2 года назад
thank you so much, it solved my problem . keep helping people
@annguyenhuu4035
@annguyenhuu4035 2 года назад
That's great. you are like a savior to help me out of this mess. Thank you so much
@lastminutecoders
@lastminutecoders Год назад
Glad to help💫
@darshshah5365
@darshshah5365 2 года назад
How to implement after connected to database? Like how to get/alter data in tabels from eclipse
@MadihaMirza-bc7xb
@MadihaMirza-bc7xb 4 месяца назад
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
@kiranjotkaur4414
@kiranjotkaur4414 5 месяцев назад
It is bit urgent ! where to paste mssql-jdbc_auth-12.6.1.x64.dll file in mac
@purnimagupta8181
@purnimagupta8181 2 года назад
Getting Error : "Caused by: org.hibernate.exception.SQLGrammarException: Unable to open JDBC Connection for DDL execution" while using MS SQL
@Petukthakur
@Petukthakur Год назад
thanks boss you are brilliant too much really applaud
@lastminutecoders
@lastminutecoders Год назад
So nice of you
@ErinJerbil
@ErinJerbil 7 месяцев назад
im getting this error Error: This driver is not configured for integrated authentication. ClientConnectionId:1eb15706-194f-47a3-80a8-aee15c67ec29 can you help?
@trb_rangababu5040
@trb_rangababu5040 Год назад
How to resolve connection reset We are facing this issue every time in the application end. Please advise
@lastminutecoders
@lastminutecoders Год назад
Sorry, I have no idea.
@acrohorn
@acrohorn 4 месяца назад
THANK YOU SO MUCH, I DID IT WITH YOUR HELP
@jitendralovekar1
@jitendralovekar1 2 года назад
Would you like to try this on Java 8 instead. Not sure if it will work.
@lastminutecoders
@lastminutecoders Год назад
Will try
@AnkitSingh-rz2pf
@AnkitSingh-rz2pf Год назад
Thanks dude! It really helped me a lot.
@lastminutecoders
@lastminutecoders Год назад
💫🫂
@IamTejuPerala
@IamTejuPerala 29 дней назад
I am getting this error : "Integrated authentication failed. ClientConnectionId:4216ea9f-5cd9-4314-b6a3-dcbecc25b4e7"
@SrikanthSM-i3u
@SrikanthSM-i3u Год назад
Thanks Man, Its working.
@lastminutecoders
@lastminutecoders Год назад
Welcome buddy 💫
@RanveerSingh-ug6lu
@RanveerSingh-ug6lu Год назад
Thank you for solving this error.
@lastminutecoders
@lastminutecoders Год назад
Welcome💫
@KamranKhanmba
@KamranKhanmba Год назад
how to fix ssl error with sql server auth on local machine
@Doum4n
@Doum4n 8 месяцев назад
Thank you very much
@lastminutecoders
@lastminutecoders 8 месяцев назад
Most welcome,💫
@harpreetkaurlnu1543
@harpreetkaurlnu1543 2 года назад
Hi, I still got an error message " Login failed for user ''. ClientConnectionId:6e03e4fb-60e5-45b7-920d-fd433ab7e115" can you help me out? kinda urgent
@lastminutecoders
@lastminutecoders 2 года назад
Please try again with all the steps shown in this video
@ainaomer
@ainaomer 2 года назад
i am still having ssl handshake exception
@cutepuffpaws4420
@cutepuffpaws4420 Год назад
servlet se kaise connect kare? driver not found exception aa raha hai ....jar file add kar di
@sagarsoni985
@sagarsoni985 5 месяцев назад
I am too getting the same error for servlet connection
@Mahmoud_Nabil_2003
@Mahmoud_Nabil_2003 6 месяцев назад
thanks alot
@ManikandanS-go1tn
@ManikandanS-go1tn Год назад
Thanks for the help..
@lastminutecoders
@lastminutecoders Год назад
💫
@tulasapokhrel9189
@tulasapokhrel9189 2 года назад
Worked for me. Thanks
@lastminutecoders
@lastminutecoders Год назад
You're welcome!
@nikhilk516
@nikhilk516 2 года назад
Brother how to fix this error in MAC OS?
@lastminutecoders
@lastminutecoders Год назад
Sorry man, I am not sure
@Milizaus
@Milizaus 2 года назад
thx!! you are my savior!!
@lastminutecoders
@lastminutecoders Год назад
Any time💫
@rheawilkins3413
@rheawilkins3413 2 года назад
You saved me THANK YOU!
@lastminutecoders
@lastminutecoders Год назад
You're welcome!
@leaotanthanh5244
@leaotanthanh5244 2 года назад
Your are my angel!!!!!!!!!!!!!!!!!!!
@lastminutecoders
@lastminutecoders Год назад
So nice of you 💫
@Артем-х7п6с
@Артем-х7п6с 2 года назад
YOU SO AWESOME THANK YOU SOOOO MUCH
@lastminutecoders
@lastminutecoders Год назад
Welcome and thanks, 💯
@ellimington6210
@ellimington6210 5 часов назад
if only you could explain in English your videos would be more popular
@hoangvo9974
@hoangvo9974 Год назад
thank u man, u have saved me
@lastminutecoders
@lastminutecoders Год назад
You are welcome!
@sonalisalave7566
@sonalisalave7566 Год назад
SQL server Exception
@cutepuffpaws4420
@cutepuffpaws4420 Год назад
thankyou man!
@lastminutecoders
@lastminutecoders Год назад
Happy to help!
@bsbarkathulla8120
@bsbarkathulla8120 2 года назад
Thanks you bhai
@lastminutecoders
@lastminutecoders Год назад
Welcome!!
@kanisfatimachaity8892
@kanisfatimachaity8892 Год назад
thanks a lot bro
@lastminutecoders
@lastminutecoders Год назад
Always welcome
@goldentitan311
@goldentitan311 2 года назад
ty very much
@lastminutecoders
@lastminutecoders Год назад
Welcome!
@Aly_Qamar
@Aly_Qamar 2 года назад
Thanks bro ✨❤️
@lastminutecoders
@lastminutecoders Год назад
Any time
@sonalisalave7566
@sonalisalave7566 Год назад
Still it's giving error
@lastminutecoders
@lastminutecoders Год назад
May be uninstall and then try again
@mudassarali1999
@mudassarali1999 2 года назад
thanks bro
@lastminutecoders
@lastminutecoders Год назад
Any time
@halildurmaz8516
@halildurmaz8516 Год назад
you really helped me a lot, you are amazing man, thank you so much. I admire you. ❤❤❤
@lastminutecoders
@lastminutecoders Год назад
Thankyou so much ,for you kind words💫
@testEngineer02
@testEngineer02 Год назад
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?
@lastminutecoders
@lastminutecoders Год назад
Thanks for the compliment, but sorry, the only things I know are in this video.
@PavithraMahalingam-cg8wm
@PavithraMahalingam-cg8wm Год назад
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;
@kowsalyahebsheebha868
@kowsalyahebsheebha868 2 года назад
thank you so much 😃
@lastminutecoders
@lastminutecoders Год назад
You're welcome 😊
Далее
Java Database Connectivity | JDBC
20:34
Просмотров 295 тыс.
7 Days Exploring An Underground City
20:35
Просмотров 46 млн
What is a Protocol? (Deepdive)
18:14
Просмотров 174 тыс.
NGINX Tutorial - What is Nginx
14:32
Просмотров 212 тыс.
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Redis за 20 минут
23:22
Просмотров 146 тыс.
the right way to organise your code
17:33
Просмотров 199 тыс.