Can not Generate SSPI context in SQL Server, Windows 10

Question

I'm creating a C# application which accesses a SQL Server database on another PC in the local network. I have Windows 7 running on my PC and have SQL Server installed, and Windows 10 running on the remote PC from where I am accessing the database.

I am getting an error

Cannot generate SSPI context

when I try to connect to the SQL Server remotely from SSMS on client PC.

I have installed the same SQL Server version on the client PC
I checked to allow remote connections for the SQL Server
I allow connection in firewall

I have connection string below that I am using to access the database from remote pc

<add name="FazalConstructions.Properties.Settings.ConnString"
     connectionString="Data Source=192.168.10.2;Initial Catalog=FCProject;persist security info=true"
     providerName="System.Data.SqlClient" />

What else do I have to do?

Check this question [Here](http://stackoverflow.com/questions/1812541/cannot-create-sspi-context) it might help. — Mohammed Elshennawy, Jan 22 '17 at 12:10
i have checked this and i have also tested it with Microsoft Keberos Configuration tool, it says that i have permission issues, how i can fix this issue? — Delicate Hiba, Jan 22 '17 at 12:23
Are the PCs actually joined together on a domain? It sounds like they're not, and if that's the case they can't really authenticate with each other, whcih would mean you'd have to use SQL Server logins. — Dan Field, Jan 22 '17 at 13:58

score 1 · Answer 1 · answered Jan 22 '17 at 14:00

There is really no magical answer here, the issue can be any one of the mirriad causes of this problem. Read and follow the troubleshooting steps from these links to find what causes your issue:

Can not Generate SSPI context in SQL Server, Windows 10

1 Answers1