Integrated security sspi login failed for user null

View all posts by Sri. This site uses Akismet to reduce spam. Learn how your comment data is processed. To further investigate the error, we examined the security logs in Event Viewer on the SQL Server box at the time of the problem: An account failed to log on.

The authentication information fields include precise details about this logon request. Transited services show which intermediate services were involved in the login request. The package name identifies which NTLM protocol sub-protocol was utilized. The length of the created session key is indicated by key length. If no session key was requested, this value will be 0. Inference: We had a lot of data to process from the Security log. Error: , Severity: 20, State: Share this: Tweet.

Like this: Like Loading Leave a Reply Cancel reply. Collectives on Stack Overflow. Learn more. Ask Question. Asked 8 years, 10 months ago. Active 2 years, 10 months ago. Viewed 1k times. P a u l P a u l 7, 15 15 gold badges 57 57 silver badges 92 92 bronze badges. The answer to your question is "No". However, it's impossible to offer any advice on what the problem might be, because you didn't tell us what the problem is - "I'm having issues testing" without telling us what the issues are is meaningless.

Please edit your question to provide more information. As it is now, it's not a real question. Ken -- added additional information. Add a comment.

Active Oldest Votes. David W David W 9, 32 32 silver badges 59 59 bronze badges. New Post. I know this question has been posted in many places, but I have not been able to solve our current problem. The developers in my office are all new to C. We have been developing an application using Visual Studio. Up until this point each developer has used a local copy of IIS and connected to sql server on a remote server without any problems.

Next week we have a demo, and I have tried to deploy our solution to the IIS 6 on the remote server which also hosts the SQL server we have been using. Now we all get the 'Login failed for user null The web. On the remote server, Sql server is set to use both windows and sql server authentication IIS is set for Integrated Windows authentication.

We cannot use active directory and therefore do not have Kerberos enabled. Any help would be greatly appreciated.

Thanks Sherri. Follow Post Reply. Mark Rae. You've also told ASP. NET not to run under its default account, but to impersonate a different account instead. So, have you set up the account that ASP.

Kris Lankford. IIS can not pass the Windows user token to another machine on the network.