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...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi hba_powerbi,

Based on your description, you are connecting  to Azure SQL rather than SQL Server on Azure VM, right?

If that is the case, what authentication do you use in SSMS and in Power BI Desktop? The above error occurs when you use integrated Security to connect to SQL Server, for more details, please review this KB article.

In your scenario, when connecting to Azure SQL Server from the Power BI Desktop, please ensure firewall rules for the database are configured to "Allow access to Azure services", and you would need to set up a firewall rule to allow Power BI to make a connection. Also make sure you choose Database authentication mode in Power BI Desktop, and enter server admin account and password rather than AD account to connect to the database.


Thanks,
Lydia Zhang

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Did you find resolution for this? If Yes, please let me know what steps you have taken to resolve. 

     

     

     

    marumsdax wrote:

    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