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

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 07/29/04

  • Next message: B.S.Feldman: "Re: how to run code when Access closes" 
    Date: Fri, 30 Jul 2004 05:35:59 +1000

    Sorry, Lou.

    I can't test your combination (A2K, MSDE in a non-DC network). I use A2K2,
    full SQL Server 2000 in a network with PDC & DCs. I simply don't have that
    much time to set up everything like that for one test.

    At least you know a few work-arounds. 

    -- 
HTH
Van T. Dinh
MVP (Access)
"Lou Arnold" <Lou_Arnold@nospam.com> wrote in message
news:4108738a.2033103@nntp.flfrd.phub.net.cable.rogers.com...
> 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: B.S.Feldman: "Re: how to run code when Access closes"

    Relevant Pages

    • Getting to the bottom of MSDE network connection problems ...
      ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
      (microsoft.public.sqlserver.msde)
    • Re: VS2005: SQL Debugging "T-SQL execution ended without debugging. You may not have sufficient
      ... > account also must be a member of the sysadmin role in the target SQL ... and the Windows firewall is disabled on both client & server. ... to the remote SQL Server 2005. ... But I'm still getting the "T-SQL execution ended without debugging. ...
      (microsoft.public.vsnet.debugging)
    • RE: Getting to the bottom of MSDE network connection problems ...
      ... the way using the same installation scenario on Win2K works with no problem. ... > various versions of MSDE and Windows XP ... > and it seems the problems are due to Windows XP and not MSDE. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ...
      (microsoft.public.sqlserver.msde)
    • Re: Need help & support regarding MBSA 2.1 beta 2
      ... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows ...
      (microsoft.public.security)
    • Re: Utter madness!
      ... It is just Windows security stuff. ... You can get a trusted connection back to SQL server. ... ASP.NET account (either processModel or app pool identity depending on ...
      (microsoft.public.dotnet.framework.aspnet.security)