Forum Discussion

Rohanbhowmick's avatar
Rohanbhowmick
Regular Visitor
1 year ago
Solved

SQL Server error while connecting

Hello , I need help while trying connecting to SQL server from powerbi desktop below error is throwing So I am trying to connect the RDS string that is connected with SQL server , and that ...
  • tharunkumarRTK's avatar
    1 year ago

    Rohanbhowmick 

    Are you using Service principal authentication? if yes then does that SPN has permissions to access the db that you are trying to connect? 

     

    Have you tried connecting to that db from other client tools like SSMS, excel and data studio etc? if yes then were you able to connect?

     

    Gateway instllation is not required in your case. 

     

     

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!