RE: LDAP: Access Frontend and SQL Server Backend

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

Use the windows authentication mode in your SQL server (check the SQL Help
-Books Online for more details, not the Access help), your users will be
authenticated the moment they login to the network and as soon as they open
your access front end, only the rights granted inside SQL server will be
effective for that user

--
jl5000
<a href="http://www.joshdev.com";></a>


"Can" wrote:

> I want to set up LDAP Integration for authentication but I have no idea where
> to start. It will be for several databases with a MS Access Frontend and SQL
> Server Backend. None of the security features in MS Access are being used,
> all the security is done on the SQL server.
>
> Presently I have a MS Access form pop up when the database is opened, you
> need to type in a username and password for the SQL server to continue, you
> can also change the user's SQL server password. It works great and does what
> it's suppose to do.
>
> I need to set up the LDAP Integration for authentication so that the user's
> sql server password is the same as their novell login, etc. When a user
> opens a database I want a login pop-up screen to appear. I have no idea
> where to begin.
>
> Any thoughts?
>
> Candace
>
>
.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: I dont want to re-invent the Login/Login Wheel - Help with utilities
    ... Yes, if you use .NET1.1, there isn't built-in login control, and more importanltly there isn't ready-to-use membership component to use. ... the membership provider uses SQL Server or SQL Server Express. ... We feel that having the capability to force password change would be a better benefit in securing our application and data access. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ...
    (microsoft.public.vstudio.general)
  • RE: IIS (ASP) -> SQLServer Authentication Issue
    ... I understand that you'd like to use IIS Intergration authentication in the ... and ASP "impersonates" authencitaed users to access SQL Server on ... only kerberos authentication allows double-hops from clients ...
    (microsoft.public.sqlserver.security)
  • Re: SBS Premium Edition .. what way is SQL licenced
    ... Another thing to note in using your SQL Server as a backend database is the ... concept of Forms-based authentication and Integrated Windows authentication. ... thereby requiring individual CALs to access SQL Server. ... Chad A. Gross - SBS MVP ...
    (microsoft.public.windows.server.sbs)
  • Unable to Serialize.
    ... I have a remote Sql Server Instance locally. ... Unable to serialize the session state. ... session state store in 'Custom' mode. ... This section sets the authentication policies of the ...
    (microsoft.public.dotnet.framework.aspnet)