Re: How do you connect to SQL server using SQL users with Windows Auth? help

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: bruce barker (nospam_brubar_at_safeco.com)
Date: 06/08/04 

Date: Tue, 8 Jun 2004 13:14:39 -0700

if you want to connect to sqlserver as the same user as the browser:

1) turn of anonymous
2) enable basic, digest (if sqlserver not on same box as iis, turn on
credential forwarding), or windows (only supported if sqlserver is on the
iis box)
3) in web config: <identity impersonate="true" />

if you want to connect to sqlserver as a known user:

1) in web config: <identity impersonate="true" userName="domain\user"
password="mypass" />

-- bruce (sqlwork.com)

"Reza" <reza> wrote in message
news:E6CFBE22-60E8-4C35-BA87-E7B25BAEF4BA@microsoft.com...
> Hello,
>
> I am trying to resolve this for a week and pretty much tried everything,
Windows authenticatio, Forms authentication, none of .net, but still get a
message of. Login failed for user, 'username'.
> I am able to connect with the same user but with SQL Authentication
access, but this is not an option though due to company policies.
>
> I was searching on site of microsoft, looks like this used to be an old
bug, has this ever fixed?
>
> Thanks in advance for your help,
>
> Reza

Relevant Pages

  • RE: Error installing (KB 921896)
    ... account of SQLServer 2005 Express... ... logon with this default account. ... insulates the user from having easy access to change this authentication ... the SQL Server Instance is set to Mixed Authentication ...
    (microsoft.public.windowsupdate)
  • Re: VS Authentication (mixed mode)
    ... The book I have that walks me through setting up sqlserver does not show me ... It starts off running the install then says to run ... So it uses the windows authentication. ... > explains a (mixed mode) where you can do both types of projects and get ...
    (microsoft.public.dotnet.framework.aspnet)
  • IIS (ASP) -> SQLServer Authentication Issue
    ... IIS 6 machine serving ASP pages, integrated authentication, machine ... I want the ASP pages to access the SQLServer machine using the ... When researching this issue again on the Internet I did not find many people ...
    (microsoft.public.sqlserver.security)
  • Registering from Enterprise Manager
    ... I have a sqlserver SQLA which I have registered in EM with a sqlserver ... authentication with a uid and password and that connection works fine. ... sending windows authentication requests at the same time. ...
    (microsoft.public.sqlserver.setup)
  • Registration from Enterprise Manager
    ... I have a sqlserver SQLA which I have registered in EM with a sqlserver ... authentication with a uid and password and that connection works fine. ... sending windows authentication requests at the same time. ...
    (microsoft.public.sqlserver.connect)