Asp membership database question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nathan Laff - 24 Jul 2007 20:18 GMT

I have a SQL Express 2005 db which a WinForm application connects to.
I've chosen to use the ASP SQL Membership provider to manage application
users and roles.

Currently, I run the aspnet_regsql tool on my existing database. Does it
make sense to create a seperate database just for users and roles? What is
the "best practice" scenario in this case?

Thanks

Reply to this Message

Nathan Laff - 24 Jul 2007 20:31 GMT

Oh, also. What is the recommended use of SQL Server authentication when
using the asp membership provider?

Should I "mirror" users created with ASP.NET into my SQL Server users? Or
just create one SQL server user and hard code it into my application for the
database login?

Thanks for any help!

>I have a SQL Express 2005 db which a WinForm application connects to.
> I've chosen to use the ASP SQL Membership provider to manage application
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...