Re: Windows Authentication

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 12/31/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 30 Dec 2002 22:12:14 -0700

I'm not real clear on your security model but if you want to
use Windows Authentication, then the Windows user logged in
is what SQL Server is going to use to authenticate the
login. Maybe you are looking for something like an
Application Role. You can find more information on using
these in Books Online.

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

>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: 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: Q: Named pipes and Windows (integrated) authentication
    ... >By the way, if you don't have SQL Enterprise Manager, there's an MSDE ... >>>his windows authentication to connect to the server. ... >>>Creating databases is only acomplished after you've already connected. ...
    (microsoft.public.sqlserver.connect)
  • Windows Authentication
    ... Can anyone tell me if this is possible using VB6 and SQL ... I am using Windows Authentication in SQL so that I don't ... I want a user to be able to login to ... Windows Authentication doesn't care about my VB user, ...
    (microsoft.public.sqlserver.security)
  • RE: MELL and SQL
    ... At this point I'm logged in as admin and since ... have the necessary permissions for the installation. ... > Most third party apps don't use Windows Authentication, they use SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Authentication
    ... I'm sorry to hear you are having some troubles with SQL authentication. ... can I would love to persuade you to use Windows authentication if at all ... > With VSTO using Visual Studio 2005, has anyone manage to use SQL Server ...
    (microsoft.public.vsnet.vstools.office)