LDAP: Access Frontend and SQL Server Backend

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

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: SQL Express MDF file moved from 1 computer to another - auth f
    ... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Express MDF file moved from 1 computer to another - auth f
    ... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
    (microsoft.public.sqlserver.connect)
  • Re: Trusted connections??
    ... implement role or user based security at the SQL Server. ... If the ASP.Net app controls what the user can request of the database then I ... I implement user authentication at the application and the application ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Security question ..
    ... What I want to prevent is any access to the database accept through our ... application unless you have elevated permissions. ... Authentication, if he is smart enough to create an NT Auth ODBC connection ... passes through to the database or to use SQL Server authentication. ...
    (microsoft.public.sqlserver.server)
  • Replication with join filter failure
    ... I have a SqlCE subscriber connecting via IIS to a SQL Server 2005 database. ... The database publisher/distributor and the web server are on different machines and I want to avoid the use of Kerberos delegation to share priviledges on the snapshot folder. ... I used a DB authentication on the SQL Server database. ...
    (microsoft.public.sqlserver.replication)