How do you resolve the target principal name is incorrect Cannot generate SSPI context?

There are 3 ways to fix the problem:

Revert to using the Network Service or Local System account (NOT RECOMMENDED)
Assign the domain account to the Domain Admins group (NOT IDEAL – due to the elevated permissions)
Fix the problem by giving the domain account just the appropriate permissions in Active Directory.

What is SSPI error?

The “Cannot generate SSPI context” error is generated when SSPI uses Kerberos authentication to delegate over TCP/IP and Kerberos authentication cannot complete the necessary operations to successfully delegate the user security token to the destination computer that is running SQL Server.

How do I enable integrated security in SQL Server?

To implement SQL Server integrated security, perform the following steps:

From SQL Enterprise Manager, right-click the SQL Server name that appears in the Server Manager window and click Configure on the shortcut menu.
Click Security Options.
Select Windows NT Integrated as the Login Security Mode, and then click OK.

How do I enable a trusted account for delegation?

Choose Start > Administrative Tools > Domain Controller Security Policy.
Choose Security Settings > Local Policies > User Rights Assignment.
Right-click Enable computer and user accounts to be trusted for delegation policy.
Click Properties.
Specify the delegate username.
Click OK to add the username.

Can not connect to SQLServer?

It might be possible that SQL Server Services are disabled that created an issue while connecting to SQL Server Management Studio.

Check whether you are using right SQL Server instance name at the time of connection.

SQL Administrator does not provide permission to Allow remote connection.

Can not connect to SQL Server instance?

Things to try: Determine the port number your SQL instance is running. Try appending the port number of SQL Server to the server name using the format , portnumber and see if that works. If confirmed, add the port to Firewall exclusion list.

What is database query in SQL?

SQL is an acronym for Structured Query Language. SQL is the standard language for communicating with relational databases. Short requests, called queries, are made to an SQL-compliant database and results are returned.