Re: Answer: Access creates ADP database in MSDE only with SQL Server Authentication mode

From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/29/04

  • Next message: Lou Arnold: "Re: Answer: Access creates ADP database in MSDE only with SQL Server Authentication mode" 
    Date: Thu, 29 Jul 2004 03:58:53 GMT

    Van,
    I did what you suggested some time ago....

    I created a user account (not the SA account) as a Windows
    Administrator. I created an MSDE account with the same name and
    password and made it a member of the SysAdmin role. The MSDE was set
    for Windows Athentication only. I then ran MS Access under that
    Windows user account. If failed as it always did.

    If you have any more idea, please let me know. I find my results hard
    to believe anyway.

    I don't understand why your tests worked except that you may have a
    domain controller or you have an newer version of MS Access (mine is
    2000 SP3). Please recall that using Osql and MSDE Plus, it WAS
    possible to create databases under the Windows Admin account in
    Windows Authentication mode. Only with MS Access did this fail until I
    changed to Mixed mode authentication.

    Lou.

    On Thu, 29 Jul 2004 13:22:44 +1000, "Van T. Dinh"
    <VanThien.Dinh@discussions.microsoft.com> wrote:

    >Not too sure about that, Lou.
    >
    >OK, I tested in SQL Server, not MSDE, but new ADP with *new* database on SQL
    >Server can be created using Windows authetication only.
    >
    >AFAIK, SQL Server 2K & MSDE 2K should behave the same for security, in
    >theory.
    >
    >Sorry, I don't have an MSDE 2K installed to test. However, if you want, you
    >should set your Windows logon as the SQL Server Administrator on the MSDE,
    >change the MSDE to Windows authetication only and then test see if you can
    >create a new database via new ADP.
    >
    >--
    >HTH
    >Van T. Dinh
    >MVP (Access)
    >
    >
    >
    >
    >
    >"Lou Arnold" <Lou_Arnold@nospam.com> wrote in message
    >news:410737a7.8018259@nntp.flfrd.phub.net.cable.rogers.com...
    >> I have now confirmed that MS Access will create and ADP database in
    >> MSDE2000A only when the server is placed in MIxed mode security when
    >> the SA account and password are used. It will not do so in Windows
    >> Authentication mode.
    >>
    >> Thanks to all those who helped.
    >>
    >> Lou Arnold
    >
    >

  • Next message: Lou Arnold: "Re: Answer: Access creates ADP database in MSDE only with SQL Server Authentication mode"

    Relevant Pages