Windows Authentication

From: Mike Beltran (mbeltran@semprautilities.com)
Date: 12/30/02 

From: "Mike Beltran" <mbeltran@semprautilities.com>
Date: Mon, 30 Dec 2002 13:22:17 -0800

Can anyone tell me if this is possible using VB6 and SQL
2000?

I am using Windows Authentication in SQL so that I don't
have to create logins. All the domain users in my domain
are created as a single login. The Public group has no
permissions. Individual users from the domain are created
and placed in a user group that has permissions to the
database.

My dilemma is this. I want a user to be able to login to
my application from a workstation that they are not
currently logged into. I already know how to validate the
user's Windows login and password. But I believe SQL's
Windows Authentication doesn't care about my VB user, it
cares about the user that is logged onto that workstation.
Is it possible for me to connect the user to the database
using Windows Authentication and the user id of the user
logging into my app?

Thanks

Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: How to implement Windows Authentication?
    ... the login should be created outside the ... Candidate 2 may have no or limited SQL knowledge. ... the Windows groups/users who will run the application. ... using Windows Authentication or SQL Authenticaton. ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie: guest account with SSPI
    ... you need to add a SQL login for MYDOMAIN/johnd ... However, may I suggest you create a Local Group on the SQL Box, add domain ... > 1) Is this a Windows Authentication problem or an SQL server problem? ...
    (microsoft.public.sqlserver.server)
  • Re: How to implement Windows Authentication?
    ... but why would you want that app creates a login? ... using Windows Authentication or SQL Authenticaton. ... If the application is configured to use SQL Authentication (SQL Server is ...
    (microsoft.public.sqlserver.security)
  • Re: ASP 2.0, C#, LDAP Login, and Forms impersonation?
    ... Or, I could just start over with a windows authentication login, and after ... FormsAuthenticationTicket fat = fi.Ticket; ... I do not set any dwFlags. ...
    (microsoft.public.dotnet.framework.aspnet.security)