Combine aspnetdb with the applications database

I have tried to find all the threads related to this topic. At this point I would like to find out what the best practices are for doing this.

I plan to use Membership, Roles, and the login controls to handle my authentication and permissions issues. I want to use the same database for my application data as for Application Services, using a standard SQL Server.

So far, the easiest way to set this up that I can think of is to:

1. Use aspnet_regsql.exe to create the Application Services Database schema

2. Edit the "LocalSqlServer" entry in <connectionStrings> to point to the above database

3. Add the tables, views, stored procedures, etc., that I need for my application into the database created in step 1

Is there any more configuration I need to do to get Membership and Roles working? When I did the Walkthrough, step 2 seemed to be the only requirement for getting Membership and Roles to work.

Will I run into any trouble using LocalSqlServer for my application data updates?

I would be interested in any other approaches to setting up a combined database, including opinions why and why not to do it.

There should be no other problem if you've configrue the application to connect to the right database using login which has proper permissions on that database. You cna take a look at Scott's article if you haven't read it yet:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

color combinations

Where can I find some good looking examples of reports and charts that
showcase good looking design practices (my efforts leave a lot to be
desired:). I can find lots of examples for FrontPage and PowerPoint,
anything out there for SSRS?
TIA
deanHi Dean,
I'll preface this by saying that following comments are just my arrogant
opinion... good report design is something of an art (combining business
analysis chops, database handiness, and an eye for the aesthetic).
I would recommend sticking with a monochromatic color palette in two tones
and using gainsboro, silver, and the other grays to augment. My personal
favorite is the steelblue/lightsteelblue combination, but whatever
complements your companyâ's logo is best.
I would stick with black text â' except where you want to conditionally show
something good (green), possibly problematic (orange) or bad (red). Then use
the color sparingly (on a sinle field instead of the whole line). Use
palegoldenrod to highlight entire lines instead of yellow which is really
bright.
Iâ'm fond of dimgray for line borders instead of blackâ?¦ I just think it looks
more modern and softer on the eyes.
All of that said, those same themes you looked at for powerpoint can be
replicated if you like one in particular. Sorry I donâ't know any sites to
take a look at samplesâ?¦ Good luck!
One site to take a look at is:
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx. It shows how to do some pretty cool tricks.
Cheers,
Kathy
"Dean" wrote:
> Where can I find some good looking examples of reports and charts that
> showcase good looking design practices (my efforts leave a lot to be
> desired:). I can find lots of examples for FrontPage and PowerPoint,
> anything out there for SSRS?
> TIA
> dean
>
>|||Some of the samples provided by MS is a good starter for you. You can see
some best practises from microsoft site itself. There is a PDF document which
gives you the best practises.
Amarnath
"Dean" wrote:
> Where can I find some good looking examples of reports and charts that
> showcase good looking design practices (my efforts leave a lot to be
> desired:). I can find lots of examples for FrontPage and PowerPoint,
> anything out there for SSRS?
> TIA
> dean
>
>