Hi , while connecting to sql server from databricks notebook with service principal as auth , im getting this error once every week .95% of the time , im not seeing this error but want to understand why im facing this and how i can resolve this ?

Hi , while connecting to sql server from databricks notebook with service principal as auth , im getting this error once every week .95% of the time , im not seeing this error but want to understand why im facing this and how i can resolve this ?

Hello @SekharmattaGuna-1084,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Hello @SekharmattaGuna-1084,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .
Thanks
Himanshu
Hello @SekharmattaGuna-1084,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is is to know the reason for the above error .
I see that you are that this is login failure error , which means that the server is up , but the server is unable to connect to the database . I could try to get more data on .
Is the error in the same time window every week , if yes then we should move the focus on the sink database server and get more info on what is happening .
If the error is on random time window , may be we will have to drill more on the SQL side again , as the error clearly says that databrick connection request is reaching to the require server .
Please do let me if you have any queries.
Thanks
Himanshu
Please don't forget to click on
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
27 people are following this question.