Login Control used with existing SQL DB

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "paulmac106" <paulmac106@xxxxxxxxxxx>
Date: 28 Dec 2005 11:57:08 -0800

Hi,

I'm creating my first 2.0 web application. I want to use the login
control to validate users using my existing SQL 2000 database (using
email address and password)

I can't find a tutuorial to do this...they always seem to want me to
create this new aspnetdb database and use roles and memberships and the
like.

Can I simply just use my own database? I want them to login and then
fill in a session variable with their "id code", and I'll be good to
go.

thanks,
Paul

.

Prev by Date: Re: The parameter is incorrect error
Next by Date: Re: How can I "script" changes to .net trust levels?
Previous by thread: The parameter is incorrect error
Next by thread: Re: How can I "script" changes to .net trust levels?
Index(es):
- Date
- Thread

Relevant Pages

Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.programming)
Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.programming)
Re: Logging in irrespective of database access
... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
(microsoft.public.sqlserver.server)