Authenticating domain users

From: Yaron (Yaron_at_discussions.microsoft.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 12:37:05 -0800

Hi,

I am writing a program that will require a user to log in using their domain
account which will then take the information to a SQL Server database stored
on the server and try to log in using that information.

Several questions:

1) What class should I use once I have the username / password to
authenticate the account on the domain?
2) Is there any way for me to use Windows' authentication dialog? This is
the dialog that always comes up when you try to access something that you
need to login to. IE uses it, as well as Windows Explorer. I'd much rather
use this dialog somehow than create one of my own.
3) Slightly unrelated question... Lets say the user authenticated correctly
against the domain, and now I want to access the database. I currently have
it set so that I have database roles assigned to user types on the domain.
So, when I login to the database using SqlConnection, should the username and
password be set to the the user's domain username and password?

Thanks for all help!

Yaron

Relevant Pages

  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: DTS Package fails when Scheduled
    ... Apparently I was unable to pass on the database password when runninig the ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • Problems with WebParts
    ... The connection string specifies a local SQL Server Express instance using a ... database location within the applications App_Data directory. ... server account must have read and write access to the applications directory. ... logged-in user needs the dbcreator privilege in the appropriate SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: sa password was inadvertently changed. With a kicker...
    ... Use some other account that the client has (any domain admin should have ... Did around there install package, and see if the sql script that changed ... Put the database files back where they should ... > I have a SQL Server 7 Standard edition server running in a ...
    (microsoft.public.sqlserver.security)
  • Re: does sql user need to be an admin?
    ... User accounts need to be granted access to SQL Server in order to ... file permissions do not control database access. ... This account is a member of the ... Grant a Windows account access to SQL Server: ...
    (microsoft.public.sqlserver.security)