Re: Windows Authentication

From: Alvin Zhao[MSFT] (alvinzh@online.microsoft.com)
Date: 01/02/03 

From: alvinzh@online.microsoft.com (Alvin Zhao[MSFT])
Date: Thu, 02 Jan 2003 09:35:08 GMT

Hi Mike,

Per your post, you have one user log into the Windows and another user log
into an application running on that machine. You want to connect to SQL
Server from the application with the second user's credential. If my
understanding is wrong, please point me out. When connecting to SQL Server
with Windows authentication mode, SQL Server uses the credentials of the
user that log on to Windows to validate the user. So it is not possible to
use the second user to connect to SQL Server while using Windows
authentication mode.

Sincerely,

Alvin Zhao
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: Permission problem
    ... SQL Server has two Authentication mode: ... mixed mode (Windows and SQL Server). ... One of my costumers have a program that connects to a servers MSDE ...
    (microsoft.public.sqlserver.msde)
  • Answer: Access creates DB in MSDE in SQL Server Authentication mod
    ... I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. ...
    (microsoft.public.sqlserver.msde)
  • Re: Questions about SQL on SBS Premium
    ... Changing the authentication from Windows to Mixed mode will not ... Just make sure you secure this SQL Server ... The authentication mode needs to be set to mixed mode (it is currently ...
    (microsoft.public.windows.server.sbs)
  • Re: Trusted Sql Server Connection
    ... Usually, when one gets this message, it means that you have your SQL Server instance in Windows Authentication mode, rather than in Mixed Authentication mode. ...
    (microsoft.public.sqlserver.security)
  • Re: Prevent winlogon before a specific program starts from a service
    ... Are you aware that this won't work on Terminal Services or when Windows ... What you should do is fixing your "launch from a service" system so ... now if the user log off and another user log on? ...
    (microsoft.public.win32.programmer.kernel)