IIS_IUSRS and SQL 2005

Question

User105165299 posted

Hi all-

I am trying add the IIS_IUSRS group to the security of my SQL 2005 database under W2K8 and IIS 7 and SQL 2005 doesn't recognize the user, but it is active and installed.  I'm guessing there is some sort of issue with switching from IIS_WPG to IIS_IUSRS in version 7.  Is there any work around to get SQL Server to recognize this group? I'm also guessing it will be fixed when SQL 2008 comes out, but we can't wait until Q3 to deploy our new webservers, which is the anticipated release of SQL 2008. 

Any suggestions would be helpful. 

Thanks,

BW


 

Answer 1

User1073881637 posted

i'm assuming iis 7 and sql 2005 are on the same box.  Go to sql management studio, click security, right click on logins, select new login, click search, when the object picker pops up, in object types, make sure Groups is selected.

 

Answer 2

User105165299 posted

Thanks for the reply.  Yes they are on the same box, but that's the thing.  You can't add the login like you can with the IIS_WPG group or any other groups.  It doesn't recogonize the group when you select it. 

i'm assuming iis 7 and sql 2005 are on the same box.  Go to sql management studio, click security, right click on logins, select new login, click search, when the object picker pops up, in object types, make sure Groups is selected.

Answer 3

User1073881637 posted

Interesting.  I got an error when I tried to add 'MACHINENAME\IIS_IUSRS but when I typed BUILTIN\IIS_IUSRS, it allowed me to add it.  Try that and see if it works.

Answer 4

User105165299 posted

That worked!  Interesting for sure.  I can't beleive I didn't try that.  Thanks for the help!

Cheers,

 

Answer 5

User1073881637 posted

Cool!  This is one of those tidbits that others will be looking for.   Hope you don't mind, I added a post on my blog.

http://weblogs.asp.net/steveschofield/archive/2008/03/14/iis-7-post-63-add-iis-iusrs-group-to-sql-2005-local-security.aspx