How to fix a Windows NT user or group "IIS APPPOOL \ DefaultAppPool" not found?

Question

when I start SQL Server 2005:

EXEC sp_grantlogin "IIS APPPOOL\DefaultAppPool" 

I get an error message:

 Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49 Windows NT user or group 'IIS APPPOOL\DefaultAppPool' not found. Check the name again. 

How can i fix this?

Answer 1

This work is for me.

 CREATE LOGIN [IIS APPPOOL\MyAppPool] FROM WINDOWS; CREATE USER MyAppPoolUser FOR LOGIN [IIS APPPOOL\MyAppPool]; 

Answer 2

You need to make sure that the computer has a Windows IIS APPPOOL\DefaultAppPool . Launch Computer Management on the computer, go to Local Users and Groups and view the properties in IIS_IUSRS .

If there is no account called IIS APPOOL\DefaultAppPool , then you cannot add a login to SQL Server. You will only have this account on your SQL Server computer, if you also use IIS on this computer, since IIS APPPOOL \ DefaultAppPool is a local account.

This link http://forums.iis.net/t/1174325.aspx seems very similar to your problem. There are some tips on how to solve the problem, including one at the very end that looks important.

Answer 3

For lazy configuration in my IIS 7.5 development window, I use BUILTIN\IIS_IUSRS instead of the IIS APPPOOL\DefaultAppPool application pool identifier.

Because (dynamic) application pool authentication users are always members of the IIS_IUSRS group, if you rename the application pool or use another application pool, it will not violate SQL permissions.

ref, use BUILTIN \ Group to provide access to predefined Windows NT groups: http://support.microsoft.com/kb/216808

Answer 4

I had the same error message after installing SQL, etc. I found out that in fact I did not have IIS enabled / installed in Windows Programs and Features .

Search Turn Windows features on or off

IIS - Internet Information Services Mark IIS - Internet Information Services Marked

Click OK

Restarting the SQL script should complete.