CODEWITHSUNDEEP
c#sql-serverremote-accesssspi
Delicate Hiba
Delicate Hiba

Reputation: 63

Can not Generate SSPI context in SQL Server, Windows 10

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.

  1. I have installed the same SQL Server version on the client PC
  2. I checked to allow remote connections for the SQL Server
  3. 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?

Upvotes: 0

Views: 7024

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294407

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:

Upvotes: 1

Related Questions