当用日志监听SqlConnection.Open()时获取抛出的数据库访问异常,如下:
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DB.MDF" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\www.XXX.net'.
描叙:
我用Win7+VS2010+sql server 2008 r2 本地测试正常,部署到服务器上出错
服务器环境:
Windows server 2008 r2 Stander + IIS7.5 + sql server 2008 express
连接字符串:
<add name="ConnectStr" connectionString="Data Source=.; Database=DB.MDF; Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
分析:
访问权限问题
解决方法:见