« Previous Next »

• 03-11-2008, 1:12 PM

  savvyboarder Joined on 01-29-2006, 10:10 PM Posts 6

  IIS_IUSRS and SQL 2005 Reply Contact 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

  Tags: IIS_IUSRSSecuritySQL 2005

• 03-12-2008, 9:30 PM

  In reply to

  steve schofield Joined on 06-10-2002, 8:54 PM MI Posts 5,648

  Re: IIS_IUSRS and SQL 2005 Reply Contact 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.   Steve Schofield Windows Server MVP - ASP.NET / IIS http://www.iislogs.com/steveschofield http://www.IISLogs.com Enterprise Log management solution Install, Configure, Forget Questions on Microsoft SMTP Service - visit http://www.smtp.ws IIS Community Newsletter - visit http://www.iisnewsletter.com

• 03-13-2008, 12:53 AM

  In reply to

  savvyboarder Joined on 01-29-2006, 10:10 PM Posts 6

  Re: IIS_IUSRS and SQL 2005 Reply Contact 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.  steve schofield: 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.

• 03-13-2008, 1:04 AM

  In reply to

  steve schofield Joined on 06-10-2002, 8:54 PM MI Posts 5,648

  Re: IIS_IUSRS and SQL 2005 Reply Contact 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. Steve Schofield Windows Server MVP - ASP.NET / IIS http://www.iislogs.com/steveschofield http://www.IISLogs.com Enterprise Log management solution Install, Configure, Forget Questions on Microsoft SMTP Service - visit http://www.smtp.ws IIS Community Newsletter - visit http://www.iisnewsletter.com

• 03-14-2008, 8:11 AM

  In reply to

  savvyboarder Joined on 01-29-2006, 10:10 PM Posts 6	Re: IIS_IUSRS and SQL 2005 Reply Contact That worked!  Interesting for sure.  I can't beleive I didn't try that.  Thanks for the help! Cheers,

• 03-14-2008, 11:32 PM

  In reply to

  steve schofield Joined on 06-10-2002, 8:54 PM MI Posts 5,648

  Re: IIS_IUSRS and SQL 2005 Reply Contact 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 Steve Schofield Windows Server MVP - ASP.NET / IIS http://www.iislogs.com/steveschofield http://www.IISLogs.com Enterprise Log management solution Install, Configure, Forget Questions on Microsoft SMTP Service - visit http://www.smtp.ws IIS Community Newsletter - visit http://www.iisnewsletter.com