Login to SQL using AD account without logging into AD?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Okay, this is probably a stupid question which I suspect I already know the
answer to, but....

Here's the situation: I work for a consulting company. Many of our users
don't log into the organization's AD domain; instead, they log directly into
the client's system. They all have AD accounts however, and their AD account
is used when logging into our IIS 6 web application server (using Basic
Authentication, so the users are always prompted for their username and
password).

Some users require access to our SQL Server machine. And herein lies my
problem. I would LIKE to use their AD account to control their access to SQL
Server, however, if they're not logged into AD, there is no way they can use
a "trusted connection" to connect. So, I am forced to create another account
(a SQL Server login) for them to log into SQL Server. (This is unlike using
IIS 6 which will prompt them for a username/password and I can use their AD
account).

So, my question is: Is there any way to use an AD account when logging into
SQL Server without being logged into the domain? I suspect the answer is
"No."


Thanks,
Andre


.

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • 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: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • 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)