SQL connect error from Data bricks notebook

Sekhar matta, Guna 1 Reputation point
2022-02-25T13:38:39.433+00:00

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 ?

177902-image.png

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,921 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
.NET Machine learning
.NET Machine learning
.NET: Microsoft Technologies based on the .NET software framework.Machine learning: A type of artificial intelligence focused on enabling computers to use observed data to evolve new behaviors that have not been explicitly programmed.
150 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,376 Reputation points Microsoft Employee
    2022-03-01T00:51:48.07+00:00

    Hello @Sekhar matta, Guna ,
    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 .

    1. 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 .
    2. 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 130616-image.png or upvote 130671-image.png 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
    0 comments