Re: Sevice Pack 3A for SQL

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 10/22/04


Date: Fri, 22 Oct 2004 08:25:32 +0200


> The edition where this ocurred is the enterprise edition.. Will review
the
> articles you mentioned. Would the fact that I installed sql, applied svc
> pack 3a, installed analysis services and then attempted to install its svc
> pack in this sequence make a difference?

This order I usually use, and it works ok

> Is there a way to determine if the svc pack was applied like a version?

To identify which version of the SQL Server 2000 database engine or MSDE
2000 you have installed, use SELECT @@VERSION or
SERVERPROPERTY('ProductVersion') in Query Analyzer. Versions of SQL 2000
are:
8.00.194 RTM
8.00.384 SP1
8.00.534 SP2
8.00.760 SP3 or SP3a

To identify which version of Analysis Services you have installed, in the
Analysis Manager tree, right-click the Analysis Servers node, click on the
server, and then click Help - About Analysis Services. Versions:
RTM 8.0.194
SP1 8.0.382
SP2 8.0.534
SP3 or SP3a 8.0.760

> What vulerabilities do I open myself up to if I don't apply this patch?

Many - SP3 is security oriented.

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com


Relevant Pages

  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... "maintaining a failover cluster" for recovery from failure scenario 1. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)