Did Microsoft promise that ASP.Net would be easier web development environment?
Quoting Dean Fiala <[EMAIL PROTECTED]>: > 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 Links > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h0018su/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123279833/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/
