Solved

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

Posted on 2008-10-24
2
637 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

726 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