Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am trying to add a anonymous IIS user [IUSR] to a SQL SERVER 2008 r2 database.

But I am getting the following error:

'notebook/iusr' is not a valid login or you do not have permission.

I think permission is not the issue because I am logged with the 'sa' account. Also I tried only 'iusr' as a username and I get the same error?

Does anyone have some idea on how to add the IIS7 anonymous account to a sql server 2208 r2 database?

share|improve this question
    
Could not find a work around for that. I´ve just set iis7 app pool to run under local user administrator. –  Guilherme Nov 29 '12 at 17:13

2 Answers 2

This is called a managed service account (MSA).You have to add a dollar sign ($) after the username when creating the login. The format is DOMAIN\ACCOUNTNAME$. I believe you'll have to script this login out, as the GUI search feature won't find it.

CREATE LOGIN [DOMAIN\MACHINENAME$] FROM WINDOWS
share|improve this answer

IUSR is a built-in local account for Windows Server 2008 and higher.

Instead of NOTEBOOK\IUSR

Use BUILTIN\IUSR

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.