Re: MSDE 2000 Release A: Windows Authentication Mode or Mixed Mode



Hi there,
I can't answer your first question (still looking :-) but here's what you
should do to solve the error message you received:
You should run setup from the command line (or modify the setup.ini file) as
follows:
setup sapwd="yourpassword" [....] (there are other arguments if you want to
use them)
That's what it meant by setting a strong password for the SA account (took
me a while to figure it out too)...

"SHC" wrote:

> Hi David, Thanks for your response.
> I removed the "named" instance of MSSQL$CAMBRIDGESOFT from my PC. I just
> want to install the MSDE 2000 Release A as a "default" instance to be used in
> Access 2003. I read all the documents you suggested and I still can not
> install the MSDE 2003 Release A in my PC. I clicked on the setup.exe
> (Microsoft SQL Server Setup) in my C:\MSDERelA folder. First, I saw the
> message "Please wait while Windows configures Microsoft SQL Server Desktop
> Engine", and then "A strong SA password is required for security reasons.
> Please use SAPWD switch to supply the same. Refer to readme for more details.
> Setup will now exist." I am completely lost in this matter of installing
> MSDE 2000 Release A. Please help and tell me how I can use SAPWD switch to
> supply the strong SA password during the setup.
> Thanks again,
> SHC
>
>
> "David Lloyd" wrote:
>
> > Below are some KB articles on MSDE security that may be useful:
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;325022
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;319930
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;814463
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;306881
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;318816
> >
> > --
> > David Lloyd
> > MCSD .NET
> > http://LemingtonConsulting.com
> >
> > This response is supplied "as is" without any representations or warranties.
> >
> >
> > "SHC" <SHC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:111D3862-95D1-4BF6-BB05-72C7A9D530FD@xxxxxxxxxxxxxxxx
> > Hi all,
> > I have Windows XP Pro on Microsoft NT 4 LAN System and there is a "named"
> > instance of the early version of MSDE (MSSQL$CAMBRIGESOFT) already installed
> > in my Windows XP Pro.
> > I need to download Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
> > Release A and install it in my Windows XP Pro as a "default" instance to be
> > used in Microsoft Access 2003 in my PC. I read MSDE 2000 Release A
> > Installation Examples, but I do not understand what "Windows Authentication
> > Mode", "Mixed Mode" and "AStrongSAPwd" are. Can someone explain them to me?
> > Should I use Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release
> > A's
> > "Windows Authentication Mode" or "Mixed Mode" for my "default" instance to
> > be
> > used in Microsoft Access 2003? Please help and advise.
> > Thanks in advance,
> >
> > SHC
> >
> >
> >
.



Relevant Pages

  • Re: Installing MSDE from VB.NET
    ... The same hanging behavior occurs when I run MSDE setup ... When I do that, the install hangs, and I use task manager to kill it. ... > How to use MSDE Merge Modules in VS.Net Setup project ...
    (microsoft.public.sqlserver.setup)
  • Re: SP3 for MSDE 2000
    ... When I ran setup from the gui, it just quit complaining about strong ... then it just created a new default instance w/ the SP3 ... > My computer also insists that there is an MSDE ... >> How do I install this over the MSDE version that comes with the .NET ...
    (microsoft.public.sqlserver.security)
  • Re: SP3 for MSDE 2000
    ... When I ran setup from the gui, it just quit complaining about strong ... then it just created a new default instance w/ the SP3 ... > My computer also insists that there is an MSDE ... >> How do I install this over the MSDE version that comes with the .NET ...
    (microsoft.public.security)
  • RE: Office Enterprise 2007 will not install under Vista
    ... It just hangs during the setup or do you get an error message? ... > Patrick Schmid [OneNote MVP] ... >> It does not look like MS has a way of supporting install problems with Office. ...
    (microsoft.public.office.setup)
  • RE: EIF Installation Error 1722
    ... I am getting the same error message. ... > It looks to be failing to install the main EnterpriseInstrumentation.dll. ... A program run as part of the setup did not ... > | Verbose Log File: Following is the portion of verbose log file reflecting ...
    (microsoft.public.vsnet.enterprise.tools)