Forum Discussion

hba_powerbi's avatar
hba_powerbi
New Member
9 years ago

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

Hello all:   I have an Azure SQL server instance up and running-- I can connect just fine to it using SSMS. When trying to connect via Power BI Desktop to the same database instance, I'm presented...
marumsdax's avatar
marumsdax
Regular Visitor
9 years ago

Hi,

 

I do have same issue but happening for only one user. Any idea to resolve this issue.

 

Granted permissions to SQL Server , Power BI gateway and Data Connections and able to see power BI gateway from https://app.powerbi.com/ and data connections looks good but not sure why below error message pops up when trying to connect it from Power BI Desktop. 

 

Unable to connect

We encountered an error while trying to ocnnect.

Details: Microsoft SQL: the target principal name is incorrect.

Cannot generate SSPI context."

 

I would like to let you know what and all steps i tried; Unistall and installed powerBI dataway but no luck.

Operating system - Windows 10 upto date. Even i am using windows 10 but able to connect Power BI dekstop successfully with my login but unable to login from his/her credentials. 

 

 

Thanks,

Maru

CAKCy's avatar
CAKCy
New Member
9 years ago

Hi,

 

For what it's worth I solved my problem by logging in to Windows 10 terminal with a local account (which is exactly the same as the account of the user on the server hosting the SQL server). I have to mention that the setup is a standalone server i.e. no domains.

 

Hope this helps someone!

 

Regards.

  • afabiano's avatar
    afabiano
    Frequent Visitor
    8 years ago

    I have the same issue here - but it comes and goes as it pleases... Ive been refreshing an SQL on a remote server fine for 6 months, then tonight  i get this message.... Tomorrow it will work fine.