Security

Fed · December 3rd, 2009, 10:13 AM

Hi Imar,

How did you set up the Administrator Id and password in the app? I figured it out by going into the tables themselves and copying the data but how do those aspnet_ tables get created and those aspnet_ stored procedures get created?

Thanks

Fed

Imar · December 3rd, 2009, 10:30 AM

You can use aspnet_regsql (found in C:\Windows\Microsoft.NET\Framework\v2.0.50727) to create the necessary database objects.

Once the database is configured you can use Web Site | ASP.NET Web Site Configuration (or something like that) in Visual Studio to manage your users.

Alternatively, you can use IIS 7 or up to manage them, create users programmatically (http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=472) or build your own tools. The latter is explained in the BugBase chapter.

Cheers,

Imar

Fed · December 15th, 2009, 03:44 PM

Hi Imar,

Was wondering if you could recommend a book for learning SQL Server 2008. I looked online and there are literally hundreds. I was looking for something along the lines of your beginning asp.net 3.5 style. Where you basically teach, and I learn, by example.

Thanks and Cheers,

Fed

Imar · December 16th, 2009, 05:24 AM

You may want to take a look at Beginning SQL Server 2008 or Professional SQL Server 2008.

http://www.wrox.com/WileyCDA/WroxTit...470257016.html
http://www.wrox.com/WileyCDA/WroxTit...470257024.html
I haven't read the Beginning book myself, but I have always enjoyed Rob Vieira's books.... I learned a great deal of tricks from his (now ancient) Professional SQL Server 7.0

Cheers,

Imar

Fed · December 16th, 2009, 10:34 AM

Ok thanks man,

Cheers!