Solved

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

Posted on 2008-10-24
2
628 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
Comment Utility
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
Comment Utility
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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Lync server 2013 Backup Service Error ID 4049 – After File Share Migration
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now