Easier than what, classic ASP? It is, and much more powerful. Does it have some overhhead, yes.
What's hard about setting a connection string? On 8/5/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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 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=12heeoro0/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123280200/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/
