Crystalreportviewer.processreponse locks mxsqlserver database account with error SSPI handshake exception

0

Crystalreportviewer.processreponse locks mxsqlserver database account with error SSPI handshake exception,

Message 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.

Message Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Message Error: 17806, Severity: 20, State: 14.

crystal-reports
asked on Stack Overflow Oct 14, 2013 by Rupesh

1 Answer

0

I've had a similar issue trying to deploy a Web Portal for Crystal Reports and the user that was connecting to the Web Portal via the browser did not have security permissions on the SQL database. For me it was as simple as adding the user to the security tab in the SQL Server management console. You might want to check that out first. If not, please check the steps outlined in this link. The troubleshooting steps in the article may help you resolve your issue.The ultimate solution for this user was to check his local security policies to see if any essential rights had been denied. He tried to connect to a share on the server. The connection to a share failed, and he realized the account did not have "access this computer from the network" rights or was missing other domain or network level permissions.

Hope that helps,

Chris

answered on Stack Overflow Oct 14, 2013 by campagnolo_1 • edited Oct 14, 2013 by campagnolo_1

User contributions licensed under CC BY-SA 3.0