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...
thiagomsbueno's avatar
thiagomsbueno
New Member
8 years ago

Hello Guys, 

 

The Error started to occur in my Power BI, in one day everything worked, in the other "Can not generate SSPI context."

My connection was always made through the Server Name \ Instance as MACHINE-NAME \ INSTANCE-NAME

 

So I decided to test access directly through the IP of the SQL server, and I succeeded in access!

I was successful accessing the server directly by ip which in my case is local and is on the same network as 192.168.1.1 \ instance-name

 

So it worked!

 

Anyone who is using the server on the same network can try to access over IP

 

I hope to help,

Regards from Brazil

gregwitkamp's avatar
gregwitkamp
New Member
5 years ago

This worked for me, but I had to initially create the excel file with the query on a different pc than mine and I could do it with using the server name instead of the IP address. After I did that, I could then open the query editor on my machine and change the source to the server IP address. 

 

I cannot create a new database connection on my machine using the IP address. I must create it on a different machine first. Anyone have an idea as to why that would happen?


Thanks,

Greg