Forum Discussion
Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context.
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
I experienced a similar problem. In my case it had to to with how the credentials were stored. I had to go in to query editor, data source settings. I cleared both the data sources in current file and the global permissions setting up the connection from beginning again.
In my case, it was the globabl permissions too. I cleared those and I was allowed to sign in normally. Thanks for pointing this out!
