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

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" <pearlsoft@xxxxxxxxxxxx> wrote in message news:%23Aa9b4AEHHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Problem joing RHEL4 to Windows Server 2003 Active Directory using winbind
    ... I have been trying to get my RHEL4 client to join on a Windows domain, ... i still cant retrieve a list of domain users from the domain ... passwd: files winbind ...
    (RedHat)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)