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

[hadase]

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.

[v-priyankata · Accepted solution]

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]

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]

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.

[VijayP]

@hadase 

Hope below thread might help you!

https://learn.microsoft.com/en-us/answers/questions/1368194/microsoft-sql-the-target-principal-name-...

Let me know if this still not resolved

[hadase]

Hey,

Its an mssql databse with server in aws not azure

[hadase]

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.