Forum Discussion
Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context.
I have the same issue but only to one Databse. After I check all the settings of this compared to other with no differences.
So I tried my luck by rename the database to shorter one (from 13 characters length name to 8 characters length name), then this was solved.
Hope this helps
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!
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
