Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.

share|improve this answer

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



share|improve this answer

Your Answer


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.