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 Power BI desktop, the table doesnt connects to the data.

I changed the server to the new IP but it has this messege:

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

 

I dont understand why - because the windows credentials are the same.

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.

6 Replies

    • hadase's avatar
      hadase
      Frequent Visitor
      10 months ago

      Hey,

      Its an mssql databse with server in aws not azure

      • hadase's avatar
        hadase
        Frequent Visitor
        10 months ago

        They moved to cloud server of AWS

        And i tried to put the new IP or the server name

        With the current windows credentials and it doesnt connect.

  • 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.