SSPI handshake failed with error code 0x8009030c...Someone help please

Question

Post reply

SSPI handshake failed with error code 0x8009030c...Someone help please

talk2charles2day

Say Hey Kid

Points: 687
More actions
March 13, 2012 at 5:11 am

#269996

a new instance of SQL Server 2008 was installed and it would only allow you enter with Windows authentication. When you try sa logon it fails. Please what's the issue? I saw this error in the Event viewer log, thought it might be connected:
SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: 192.168.43.69].
Any solutions?
Charles.
October 6, 2017 at 9:42 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 1

have u had a look at this

http://www.secretgeek.net/boring_sql_one.asp

Have u tried connecting to the server any other way?

Jayanth Kurup[/url]

talk2charles2day Say Hey Kid Points: 687 More actions · Answer 2

Hi

Jayanth_Kurup,

I discovered I could connect via Widows Authentication, but when I changed the password it still didn't work.

So I checked the error log and found that the installation was not configured to accept mixed mode authentication.

So I got in again via Windows Auth and changed the settings.

http://msdn.microsoft.com/en-us/library/ms188670.aspx.

It's Okay now. Thanks.

wondermorris8 SSC Veteran Points: 217 More actions · Answer 3

Hi Jaynath,

I am a newbie. Now I found answer for this problem. How do I find out user name. Since the logs just gives me [Client: 00.000.00.00]. And I work from a remote location. So If you could guide me that would be great help.

Thanks in advance

ARC211 Ten Centuries Points: 1283 More actions · Answer 4

@wondermorris8

I am experiencing the same issue... Did you figure out how to find the user\account?

wondermorris8 SSC Veteran Points: 217 More actions · Answer 5

Hi Arc211, yes I found solution on how to find user by IP address.

In cmd prompt type ping -a youripaadress

This will let you know user machine.

Sorry didn't check this mail earlier. Hope this can still help.

ARC211 Ten Centuries Points: 1283 More actions · Answer 6

I was actually talking about the SQL SERVER Login.... I can see the computer that is trying to make the connection but not the account.

ARC211 Ten Centuries Points: 1283 More actions · Answer 7

I'm experiencing the same issue again, but I still don't know how to determine which user account is the culprit.... Can anyone help?

mubashir.hashmi Old Hand Points: 361 More actions · Answer 8

I've faced the same issue, but i solved.

Issue:

SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: xxx.xxx.xx.xx]

Solution

Domain controller not behave correctly , multiple gateway some time dis-join or redundancy on single network. change and correct DNS address.

Run -- > type --> ncpa.cpl --> click Ethernet--> properties --> IP V4--> Check primary / Secondary DNS IP address.

connect SQL through window authentication, it will work.

Regards

Mubashir