Forum Discussion

hadase's avatar
hadase
Frequent Visitor
10 months ago
Solved

Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context.

I have a .pbix file where I have a table that connects to a SQL Server database - the IP was changed yesterday , and since then it couldnt refresh in the Power Bi Service. In the .pbix file in Pow...
Need Help
  • v-priyankata's avatar
    v-priyankata
    9 months ago

    Hi hadase 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    VijayP Thanks for the inputs.

    In addition please try below points. Try using the SQL Server’s hostname instead of its IP address, or turn on Trust Server Certificate, this usually restores the connection and resolves the SSPI error.

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Thanks.

v-priyankata's avatar
v-priyankata
Community Support
9 months ago

Hi hadase 

Thank you for reaching out to the Microsoft Fabric Forum Community.

VijayP Thanks for the inputs.

In addition please try below points. Try using the SQL Server’s hostname instead of its IP address, or turn on Trust Server Certificate, this usually restores the connection and resolves the SSPI error.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Thanks.

  • v-priyankata's avatar
    v-priyankata
    Community Support
    9 months ago

    Hi hadase 

    I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

     

    • v-priyankata's avatar
      v-priyankata
      Community Support
      9 months ago

      Hi hadase 

      Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.