I having the following error message:
Cannot open database "SmallBakery" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\MyAppPool'
How can correct this? I am using windows 7 Enterprise Edition and Sql server 2012.
Sql-server – Login failed for user ‘IIS APPPOOL\theAppPool
asp.netiis-7sql server
Related Solutions
SQL Server 2005 onwards:
IF EXISTS(SELECT 1 FROM sys.columns
WHERE Name = N'columnName'
AND Object_ID = Object_ID(N'schemaName.tableName'))
BEGIN
-- Column Exists
END
Martin Smith's version is shorter:
IF COL_LENGTH('schemaName.tableName', 'columnName') IS NOT NULL
BEGIN
-- Column Exists
END
SQL Server was not configured to allow mixed authentication.
Here are steps to fix:
- Right-click on SQL Server instance at root of Object Explorer, click on Properties
- Select Security from the left pane.
Select the SQL Server and Windows Authentication mode radio button, and click OK.
Right-click on the SQL Server instance, select Restart (alternatively, open up Services and restart the SQL Server service).
This is also incredibly helpful for IBM Connections users, my wizards were not able to connect until I fxed this setting.
Related Topic
- Sql-server – Add IIS 7 AppPool Identities as SQL Server Logons
- IIS AppPoolIdentity and file system write access permissions
- IIS7 Permissions Overview – ApplicationPoolIdentity
- C# – Login failed for user ‘IIS APPPOOL\ASP.NET v4.0’
- IIS 500.19 with 0x80070005 The requested page cannot be accessed because the related configuration data for the page is invalid error
- Config Error: This configuration section cannot be used at this path
- Sql-server – Cannot Connect to Server – A network-related or instance-specific error
- Sql-server – Cannot open database “MyDatabaseName” requested by the login. The login failed. Login failed for user ‘IIS APPPOOL\MyAppName
Best Answer
If you don't change, each app pool has it's own identity. In your case, just add a new user to your database
SmallBakerywith the nameIIS APPPOOL\MyAppPoolusing SQL Management Studio. You find the users list in the "Security/Users" subnode of your database. This should look something like that:For testing, let the user be member of the
db_ownerrole. If that works, remove this role and just let it be member ofdb_datareaderanddb_datawriter.This way, each app pool (perhaps each website, if they all use their own app pool) only has access to the corresponding database.