Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Using Sql Server 2000 Username/Password/Roles with ASP.Net 2.0 ?

Reply
Thread Tools

Using Sql Server 2000 Username/Password/Roles with ASP.Net 2.0 ?

 
 
Luqman
Guest
Posts: n/a
 
      11-24-2006
I want to use Sql Server Roles, Sql Server Logins/Passwords with ASP.Net
2.0, instead of saving One username/password in Connectionstring of
Web.Config, is it possible ?

I don't want to save the Username/Password in Connectionstring of
Web.config.

Further, I need forms Authentication as my users are on Internet and not on
my Local Windows Domain.

Any example will be highly appreciated ?

If the sql Server user has the particular role, he can access that table
data other wise not.

Best Regards,

Luqman


 
Reply With Quote
 
 
 
 
Cowboy \(Gregory A. Beamer\)
Guest
Posts: n/a
 
      11-24-2006
You can use full SQL Server security, but realistically, you have to have
domain users to do it. In these cases, use impersonation and allow the
windows identity to pass through.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
"Luqman" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I want to use Sql Server Roles, Sql Server Logins/Passwords with ASP.Net
> 2.0, instead of saving One username/password in Connectionstring of
> Web.Config, is it possible ?
>
> I don't want to save the Username/Password in Connectionstring of
> Web.config.
>
> Further, I need forms Authentication as my users are on Internet and not
> on my Local Windows Domain.
>
> Any example will be highly appreciated ?
>
> If the sql Server user has the particular role, he can access that table
> data other wise not.
>
> Best Regards,
>
> Luqman
>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 2000 vs SQL Server Express Grey Alien ASP .Net 6 07-09-2007 09:40 AM
Uploading Data From MS Acess 2000 ti SQL server 2000 =?Utf-8?B?Z2F1cmF2?= ASP .Net 2 01-09-2006 02:42 PM
Do the Self-Paced Training Kits: Microsoft SQL Server 2000 include Eval copy of SQL Server? Brian Whiting Microsoft Certification 2 12-29-2005 04:24 AM
sql server express vs sql server 2000 code Daves ASP .Net 1 06-13-2005 12:24 PM
Microsoft Exchange 2000 Server OR Microsoft SQL Server 2000 Sam MCSE 11 06-03-2005 08:29 PM



Advertisments