Re: SP 4 Uninstallation

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

Enterprise Manager > Server Properties. That will tell you the SP version

Else "select @@version" in Query analyzer (2039 = SP 4 and 2040 are SP4 with
AWE Hotfix)

Make sure that you installed the SP and not just extracted it.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"LL" <LL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF09AB0D-A9E0-43F9-8C0B-28EA4DB4AEEC@xxxxxxxxxxxxxxxx
> We are trying to install sql server reporting on an installation of sql
> server 2000.
>
> Can anyone tell us how we can confirmed that service pack 4 is installed
> on
> it?
> We apparently have installed SP4, but when we install sql server
> reporting,
> the setup says it requires sql server 2000 with service pack 3a, and
> refuse
> to install.
>
> So is our only solution to remove the whole sql server again and install
> the
> original cd of sql server 2000 with sp3a, then sql reporting, then sql
> server
> 2000 sp4 and sql reporting sp2?
>
> "Mike Epprecht (SQL MVP)" wrote:
>
>> Hi
>>
>> No. Due to changes in the way SP's and Hotfixes are done, it is a one way
>> upgrade. Downgrade is not possible.
>>
>> The SP4 readme describes how to uninstall, but that is with fully
>> re-installing SQL Server.
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> IM: mike@xxxxxxxxxxxx
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Gopi" <gopigopi@xxxxxxxxxxx> wrote in message
>> news:evwESHpwFHA.3252@xxxxxxxxxxxxxxxxxxxxxxx
>> > Is there any way to install SP4, and keep the existing configuration.
>> >
>> > Regards
>> > Gopi
>> >
>>
>>
>>


.

Relevant Pages

  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... The DSRestore Filter failed to connect to local SAM server. ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... Can I reinstall the files from another SBS2003 server I manage? ... On my install of SLQ2005, I told it to upgrade all instances. ... Installing SQL Server 2005 WorkGroup Edition in Windows Small Business ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: Installed VS 2005 want to Manage SQL 2005 Server
    ... I Guess I didn't copy it to the Install Source on the Server. ... To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. ... The Following Components that you chose to install are already installed onthe machine. ...
    (microsoft.public.sqlserver.setup)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > Server, doesn't have the right to grant DB access to Domain Groups. ... I didn't know that an SQL Server login as ... > I did the install about a month ago as Domain Admin (default install - mixed ... > site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)
  • Re: New Event Log Errors!
    ... Somehow along those lines I'd also installed the Certificate Authority ... Did you apply the last Server Pack for SBS Server? ... Please install Windows Support Tools on the win2k3 sp1 problematic ... Microsoft is providing this information only as a convenience to you: ...
    (microsoft.public.windows.server.sbs)