That assumes that: a) every user of your web app belongs to the domain hosting the app -- fine on an intranet, otherwise not useful b) you have created logins for the domain users or appropriate group c) you have set your database permissions properly to the domain users or appropriate group d) you don't want to take advantage of connection pooling e) you want to grant logged-in user permissions to your web app -- not a recommended practice.
If you you are creating a public website that needs to use SQL Server it is a much better practice to create a single account that will access the database. Makes your admin easier and allows the app to use connection pooling effectively. If desired, you could still use integrated security and impersonate a specific user account. You could also avoid using integrated security and set up your connection to simply use a SQL Server account. On 8/5/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Quoting the Visual Studio .Net Walkthrough Book: > Page 158 > > To Use SQL Server in Web Applications, configure the security settings to > work with Integrated Security: > > 1. Turn off Anonymous Access in IIS Manager > a. Start IIS Tool from Admin Tools > b. Expand the node for our server > c. Right-click the Default Web Site and Choose Properties from the Context > Menu > d. Click Directory Security tab > e. Click EDIT button in the Anonymous Access and Authentication Control > section > f. Clear the Anonymous Access check box > g. Make sure the Integrated Windows Authentication is checked > 2. In your applications's Web.Config file, make these changes: > a. Change > <authentication mode="None" /> > to > <authentication mode="Windows" /> > b. Insert the following attribute after the <System.Web> tag: > <indentity impersonate="true" /> > > Dallas > > > > > > Yahoo! Groups Links > > > > > > > -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h1pb87v/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123279291/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
