用户“"登录失败 [英] Login failed for user ''

问题描述

我有一个ASP .Net MVC网站，在本地测试时可以正常工作.

I have a an ASP .Net MVC website which works fine when testing locally.

我已将网站放到Windows Server 2008计算机上的IIS 7上.

I have put the website onto IIS 7 on our windows server 2008 machine.

该网站使用.net成员资格提供程序，当我尝试登录时收到以下错误:

The website uses .net membership provider and when I try to login I receive the following error:

Login failed for user ''.

这是成员资格连接字符串:

This is the membership connection string:

data source=(local);Integrated Security=SSPI;Initial Catalog=db

该站点在其自己的应用程序池中的IIS中运行，托管管道设置为集成，其身份为LocalSystem，身份验证设置为匿名身份验证.

The site is running in IIS in its own app pool with managed pipeline set to integrated and its Identity is LocalSystem, and authentication is set to Anonymous authentication.

这与我们以.net会员身份运行的其他工作网站相同.

This is the same as other working sites we have running with .net membership.

有什么想法吗?

推荐答案

Login failed for user ''是由于您说正在使用集成(Windows)身份验证而导致SQL Server无法读取NT登录令牌导致的错误. .net成员资格提供程序

Login failed for user '' is an error caused by no NT login token for SQL Server to read when you say you're using integrated (windows) authentication. It's nothing to with .net membership provider

因此，您拥有"Integrated Security=SSPI;"，但SQL无法读取它.这可能是由于:

So, you have "Integrated Security=SSPI;" but SQL can't read it. This can be caused by:

• 组策略(无网络登录权限)
• 从非Windows连接
• 防火墙等
• 同一登录更改中的最近密码更改(过期令牌)
• 等

在这种情况下，我想不出为什么将Web + SQL放在同一个盒子上.我以为在同一个盒子上没有令牌会很困难.我可以说出原因，但抱歉不知道如何解决.

In this case, I can't think why if Web + SQL are on the same box. I thought it would have been difficult to have no token on the same box. I can tell why why but don't know how to fix it sorry.

请向我们提供您的设置的完整详细信息...

Please give us full details of your setup...

这篇关于用户“"登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！