Re: Riddle me this error ADODB.Recordset (0x800A0E7A)

From: Ray Costanzo [MVP] (my)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 12:08:36 -0500

Authenticating your users is fine, but when you're doing that, yes, it will
not let anyone in who doesn't have permissions, well, since, that's what
permissions are used for.

Are you saying that people who ARE authorized also cannot connect?

Does SQL Server need to know who is accessing your intranet? I use
integrated authentication all over my intranet, but I've yet to have the
need to pass that person's credentials for SQL login purposes.

Ray at work

"Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:%238x1Sm0wEHA.3612@tk2msftngp13.phx.gbl...
> We are using Windows Integrated Auth. because this on an Intranet. I
> thought the same thing, but it doesn't let anyone who doesn't have
> permissions in.
>
> Thanks,
> Drew
>
> "Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
> message news:%23VDzmh0wEHA.2316@TK2MSFTNGP15.phx.gbl...
>> You're using a trusted connection, meaning it's going to pass the
>> credentials that the page is running under. Is that your intent? ASP
>> apps typically use a SQL login. So, if you are not authorized to that
>> database and your site authenticates you and connects as you, you will be
>> denied access. It makes sense that an admin wouldn't.
>>
>> Ray at work
>>
>> "Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> w

Relevant Pages

  • RE: Using AD to grant page and directory accesss
    ... For intranet development.. ... authenticating users/pages against AD groups to determine what pages, ... AD rather than just testing the security of the windows user and AD ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: security/strong name/zones clarification needed
    ... Was this also true in the Intranet Zone? ... >child code-group with full permissions granted to any ... >> needs to host the CLR, it creates an AppDomain, but due ... All my assemblies are strong named. ...
    (microsoft.public.dotnet.security)
  • Re: The call to Server.CreateObject failed while checking permissions. Access is denied to this obje
    ... > give your IUSR account the rights to access and launch the component. ... >> The application consists of a single DLL which does all the hard work, ... >> I designed it this way in the hope that I could also build an intranet ... >> permissions, I thought I'd post here and find out what I am missing. ...
    (microsoft.public.inetserver.asp.general)
  • single sign on - why not trust AD?
    ... For intranet development.. ... authenticating users against AD groups to determine what pages, menus, ... point in the session? ... to authenticate in an intranet site while windows is authenticated as ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Reading data
    ... Connection object, it will use the security context of the currently logged ... If you're authenticating to your Intranet (i.e. using Integrated ...
    (microsoft.public.windows.server.active_directory)