System.Data.SqlClient.SqlException：用户登录失败XXX [英] System.Data.SqlClient.SqlException: Login failed for user XXX
问题描述
我在IIS 7.5部署Web应用程序，Web应用程序有三种自行车供用户选择（山地自行车，公路自行车和旅游自行车）的。当我点击每一个就可以了，我有一个问题
I'm deploying a web application on IIS 7.5, that web app has three kind of bikes for user to choose (Mountain Bikes, Road Bikes, and Touring Bikes). When I click each on it, I got a problems
System.Data.SqlClient.SqlException：登录失败，用户XXX
System.Data.SqlClient.SqlException: Login failed for user XXX
和这里是我的连接字符串
<connectionStrings>
<add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=aspnet-AdventureCycle-20140110145435;Integrated Security=SSPI" />
<add name="AdvenBikesEntities" connectionString="metadata=res://*/Models.BikesDB.csdl|res://*/Models.BikesDB.ssdl|res://*/Models.BikesDB.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AdventureWorks2012_Data.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework;User Instance=True"" providerName="System.Data.EntityClient" />
<add name="AdventureBikesDataEntities" connectionString="metadata=res://*/Models.CategoriesBikesDB.csdl|res://*/Models.CategoriesBikesDB.ssdl|res://*/Models.CategoriesBikesDB.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AdventureWorks2012_Data.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework;User Instance=True"" providerName="System.Data.EntityClient" />
<add name="AdventureBikeDataEntities" connectionString="metadata=res://*/Models.AdventureBikeDB.csdl|res://*/Models.AdventureBikeDB.ssdl|res://*/Models.AdventureBikeDB.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AdventureWorks2012_Data.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework;User Instance=True"" providerName="System.Data.EntityClient" />
<add name="AdventureBikesDBEntities" connectionString="metadata=res://*/Models.AdventureBikesEntities.csdl|res://*/Models.AdventureBikesEntities.ssdl|res://*/Models.AdventureBikesEntities.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AdventureWorks2012_Data.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework;User Instance=True"" providerName="System.Data.EntityClient" />
<add name="AdventureBikeDBEntities" connectionString="metadata=res://*/Models.AdventureBikeDB.csdl|res://*/Models.AdventureBikeDB.ssdl|res://*/Models.AdventureBikeDB.msl;provider=System.Data.SqlClient;provider connection string="data source=TRUNGGEORGE-PC\MSSQLSERVER2012;initial catalog=AdventureWorks2012;Integrated Security=True;User ID=trung;Password=tuoi312;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" /></connectionStrings>
能否请你帮我出吗？谢谢你这么多你的时间：）
Could you please help me out of this? Thank you so much for your time :)
推荐答案
由于格雷格提到，集成安全性= SSPI意味着它使用Windows帐户是设置在IIS匿名用户。无论是三种情况之一，你需要做来解决此问题：
As Greg has mentioned, Integrated Security=SSPI means that its using the windows account which is setup for the Anonymous User in IIS. Either one of three things you will need to do to correct the issue:
1）添加使用的工作进程到SQL数据库的用户，并分配相应的权限。
1) Add the user used by the worker process to the SQL database and assign the appropriate permissions.
2）更改连接字符串使用predefined用户名和密码。使用 http://connectionstrings.com ，以找出如何改变这种状况。
2) Change the Connection String to use a predefined user name and password. Use http://connectionstrings.com to find out how to change this.
3）改变了工作进程中使用的匿名身份验证凭据或凭据。
3) Change the Anonymous authentication credentials or the credentials used by the worker process.
如果您需要帮助完成1或3，让我们知道，会有人能够引导您完成它。
If you need help completing either 1 or 3, let us know and someone will be able to walk you through it.
这篇关于System.Data.SqlClient.SqlException：用户登录失败XXX的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
