Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

State 28000 Error 18542

Status
Not open for further replies.

anon1971

Programmer
Aug 9, 2008
88
US
Help!!!! We have a Access Front-end and an sql backend that are getting the following error. State 28000 Error 18452 Not from a Trusted Connection <---- Shows this on the workstation running Vista.

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.0.103] <--- Shows this in the event log.

This workstation was working fine for over a year until one day I restarted Windows 2011 server to process updates and forgot the workstation was still up and when I realized this I forced the connection closed and restarted both computer and bam this error started. I tried renaming the computer, reinstalling vista everything but I have a feeling its going to be with the Domain Control on the server somehow because I followed the instruction of a post that stated to have the user change the password on the server from the workstation on the next login and it fixed it for him. The thing is when I do it says the old password is incorrect. I even changed it on the server and it still says it. Something has got to have been corrupted. Oh and it does not do it with XP I installed it and it works fine only vista. Vista is a must for our scanning software.

Please Any help?

 
Fixed it! I when to Data Source (ODBC) configured it for Name Piping then went to SQL Server Configuration Manager and disabled TCP/IP. Restarted the SQL Server and Server Browser Walla worked! I then re-enabled the TCP/IP settings restarted server 2011 and the troubled workstation running vista and all is well...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top