Hi Folks, I am getting error while connecting to SQL server using window authentication...

1 year ago 3 Replies
NB
Neeraj Bhandari 4 years ago

Hi Folks,

I am getting error while connecting to SQL server using window authentication...

Target principal name is incorrect. Can not generate SSPI context (Microsoft SQL server).

Please suggest...

1 Like

Replies

Rahul Trehan 4 years ago

Did u recently change ur windows account password.If yes close existing connections n login again

0 Likes
Vijay Rajput 4 years ago

use this https://www.microsoft.com/en-in/download/details.aspx?id=39046

0 Likes
Sagar Yadav 4 years ago

Install kerberos file and fix spn issues

0 Likes
Relate Discussions
• Hi Friends, When i am trying to Connect a SQL Server 2005 from a .Net Exe, i am getting this Error "Cannot generate SSPI context " , i am giving Complete Stack Trace details 1 Replies
• The error get-out of sql script for Sqlcmd: Microsoft Odbc driver 11 for sql server:can't generate SSPI context. 4 Replies
• I am receiving "cannot generate sspi" error when I try to connect a sql instance remotely. 22 Replies
• Hey guys! Can someone help me with the following error: TITLE: Connect to Server Cannot connect to SERVER01. 4 Replies
• what information need pass in the SSMS window? 6 Replies
• Hi Guys, How to connect ms sql server from cmd for default,named instance in windows authentication ,sql authentication. 1 Replies
• Hi Folks, Can we configure Distributed AlwaysOn Availability Group between 2 SQL Cluster instances which are part of different Window Server Failover cluster and hosted in different locations ? 4 Replies
• Hi folks , I am trying to install SQL Server 2008 enterprise evaluation edition on a Windows 7 machine ( x64). 2 Replies
• Is firewall boundaries should be enabled? 9 Replies
• Hi All, My SQL service is not coming online on 2nd node and running fine on 1st node. 18 Replies
Logo