The target principal name is incorrect. Cannot generate SSPI context. Azure SQL Database

Question

I am getting the error the target principal name is incorrect. Cannot generate SSPI context when trying to access a database that is in an Azure SQL Database when using Power BI Desktop

Has anyone else encountered this?

Management studio can connect to the database (once logged into my Azure account)

I have ensured that I am signed into Power BI with an account that has access to the database

I have ensured that the client machine IP address is allowed access to the database via the firewall on the database server in Azure

The database server also allows access to Azure services

Paul

Second question - did you happen to recently change SQL service from using a local system account over to a domain account? — T-Heron, Nov 30 '17 at 13:27

score 1 · Answer 1 · answered Dec 01 '20 at 18:20

1

Try to connect over TCP port and not by instance name. Type into "Server" field: {SQL-server-IP},{SQL-server-port}, example 192.168.1.5,54222. It's worked for me.

answered Dec 01 '20 at 18:20

Dmitry

388
3
4

score 0 · Answer 2 · answered Oct 13 '17 at 19:35

0

Please try to change the compatibility level of the database to 130. I have found some users experimenting a similar error here.

ALTER DATABASE database_name   
SET COMPATIBILITY_LEVEL =  130;

answered Oct 13 '17 at 19:35

Alberto Morillo

13,893
2
24
30

score 0 · Answer 3 · answered Apr 12 '19 at 13:01

Make sure that "Named Pipes" are enabled from "SQL Server Configuration Manager".

Open "SQL Server Configuration Manager".
Expand "SQL Server Network Configuration", from the list on the left.
Select "Protocols for [Your Instance Name]".
Right click on "Named Pipes", from the list on the right.
Select "Enable"
Restart your Instance service.

The target principal name is incorrect. Cannot generate SSPI context. Azure SQL Database

3 Answers3