SQL 2012 hosted database, losing connection on client
Posted on 2014-09-16
I have a remote server which includes MS SQL 2012 on it.
I am hosting a database for a client, that he connects to with a remote Access app.
Recently he has reported multiple disconnections from the database per day, which occur from all sites using the database, so it sounds like the server end rather than the client end.
Looking in the SQL Server Logs in management studio, I see a lot of entries like:
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: ***.***.***.***]
(There is an actual IP address in the message, which I have removed!)
Any ideas how I can fix this?