Solved

Haivng problem connecting IUSR to SQL database without giving sysadmin permissions.

Posted on 2008-10-24
2
636 Views
Last Modified: 2008-11-14
IIS 6.0--SQL 2005
I am trying to allow IUSR to access an sql database.  The error message is Login failed for user and error
18456, severity level 14 and state 11 in the SQL server log.  If I assign the IUSR account sysadmin roll then everything works.  I know that is not secure.  I added IUSR to the database security and gave it datareader and writer.  I have tried all kinds of combinations for the permissions on the database and also at the table but when I take away the sysadmin role IUSR then prompt the error message and the user can no longer access the database via the web form.  Any help would be greatley appreciated.
0
Comment
Question by:kdschool
2 Comments
 
LVL 37

Accepted Solution

by:
meverest earned 500 total points
ID: 22838945
Hi

that is not a good idea.  better to make a new domain user for IIS and then give permission in SQL server to access the relevant database/s

cheers.
0
 

Author Comment

by:kdschool
ID: 22840679
I am not a member of a domain.  Should I make a new windows user or a sql server user and then
use that userid and password to connect to the database?  Then would I just give IUSR permissons at the folder level so it can access the html forms?
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What is an ISAPI filter?   •      It's an assembly (.dll file) that can add or change the way IIS works.   •      They can be enabled globally for your web server or on a site-by-site basis.   When the IIS server receives a request, enabling the ISAPI fi…
Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question