pass through authentication

From: "Bad Beagle" <maxwelli@xxxxxxxxxxxxxxxx>
Date: Fri, 3 Feb 2006 09:04:50 -0700

I have a Windows 2003 member server that has SQL on it. I have a remote XP
machine in a workgroup that does have an account in the domain but does not
login to the domain (only used for OWA). Is it possible for this machine to
pass its authentication (same username and password) to the SQL server? I
used to be able to do this when the SQL server was on a domain controller.
Is there anyway to force this authentication through SQL?

Thoughts of ways for me to accomplish this???????

.

Follow-Ups:
- RE: pass through authentication
  - From: Warner wang

Prev by Date: Re: SQL 2005 connectivity error
Next by Date: RE: connection failure
Previous by thread: Re: SQL 2005 connectivity error
Next by thread: RE: pass through authentication
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL account rights
... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
(microsoft.public.sqlserver.security)
RE: MP Install issue
... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
(microsoft.public.sms.setup)
RE: Confusion on standard security methodologies.
... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
(microsoft.public.inetserver.iis.security)
Re: SQL Express Fails with Hardware Error
... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
(microsoft.public.sqlserver.setup)
Re: IIS6 Authentication Problem with SQL Server 2000
... They're not accessing SQL directly right? ... > a) if you are using a Windows 2000 Domain, ... > backend SQL Server. ... You need to use Kerberos authentication for this (not ...
(microsoft.public.inetserver.iis.security)