Re: 2000 Developer Edition & Windows Advanced 2003 Server - options?

Tech-Archive recommends: Fix windows errors by optimizing your registry

At the risk of beating a dead horse :)....

1. I installed this on the D:/ ....which had more physical space...is this
okay - no unintended consequences?

2. I chose windows authentication mode and selected 'local' account...is
this okay? Is it possible to change configuration later...should I be using
different settings?

Thanks
Jason


"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:%236I1SwKEGHA.1816@xxxxxxxxxxxxxxxxxxxxxxx
> Clustering is only one element of High Availability. One huge part is
> proper upgrade planning, testing, and implementation. If your stand-alone
> systems are running SP3a, then stick with it until you can test SP4. If
> you are already comfortable with SP4, then start there. If this is a
> totally new and independent SQL deployment, you should be using SQL Server
> 2005, but that is another issue.
>
> You are welcome.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> <jason@xxxxxxxxxxxxxxx> wrote in message
> news:OgxDQoKEGHA.2708@xxxxxxxxxxxxxxxxxxxxxxx
>> Awesome!
>>
>> Stupid question: Why bother at all with (3) or (3a) and not just go
>> directly to service pack 4?
>>
>> Again, many thanks
>> Jason
>>
>> "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
>> news:erP%23zQJEGHA.1288@xxxxxxxxxxxxxxxxxxxxxxx
>>> There is no specific service pack for each edition. SP3a and SP4 work
>>> with all editions (except MSDE).
>>>
>>> SQL 2000 SP3a:
>>> http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
>>>
>>> If you decide to go with SP3a, I strongly urge you to apply the
>>> following security hotfix (MS03-31):
>>> http://www.microsoft.com/downloads/details.aspx?FamilyID=9814ae9d-bd44-40c5-add3-b8c99618e68d&DisplayLang=en
>>>
>>> SQL 2000 SP4:
>>> http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
>>>
>>> If you have more than 4GB of physical RAM, you will need this hotfix for
>>> SP4:
>>> http://www.microsoft.com/downloads/details.aspx?familyid=7C407047-3F1F-48B8-9E4C-DC32875E1961&displaylang=en
>>>
>>> While you are downloading, go ahead and get the updated BOL. It is not
>>> included in any service pack.
>>> http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en
>>>
>>>
>>> --
>>> Geoff N. Hiten
>>
>>
>
>


.

Relevant Pages

  • SQL Server 2000 Service Pack 4
    ... applications to run on 64-bit platforms using the Windows on Windows ... SP4 addresses specific issues discovered in SQL Server ... SP4 is also the first service pack to service the ...
    (NT-Bugtraq)
  • Re: Microsoft SQL Server 2000 SP4 is open for Public Beta
    ... And we'll be hosting a public chat on the contents of Service Pack 4 on ... > Microsoft SQL Server 2000 SP4 is open for Public Beta Testing ... SQL Server 2000 SP4 is now open for public beta testing. ...
    (microsoft.public.sqlserver.clients)
  • Microsoft SQL Server 2000 SP4 is open for Public Beta Testing
    ... Microsoft SQL Server 2000 SP4 is open for Public Beta Testing ... Sign up to test drive the newest service pack for SQL Server 2000 give us ...
    (microsoft.public.sqlserver.clustering)
  • Microsoft SQL Server 2000 SP4 is open for Public Beta Testing
    ... Microsoft SQL Server 2000 SP4 is open for Public Beta Testing ... Sign up to test drive the newest service pack for SQL Server 2000 give us ...
    (microsoft.public.sqlserver.connect)
  • FTP location is randomly stopping
    ... Okay, you could depends on this with the promise it will be "cured" ... within a service pack or something. ... Long story short, we were far from cool, the "bug" (I called bug ... because it results with no apparent reason, ...
    (microsoft.public.biztalk.general)