|
|
|
SSC Veteran
 
Group: General Forum Members
Last Login: Monday, March 15, 2010 10:02 AM
Points: 244,
Visits: 746
|
|
Does anyone have any experience of using this? Microsoft have a 32bit version for SP1 and SP2 but nothing for SP3 (which we have installed at our place). Can anyone tell me if the SP2 will work fine under SP3?
Any information regarding the above or anyones experiences using it regarding performance and what you can acutally get from it would be greatly appreciated!!
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 1,760,
Visits: 1,014
|
|
There is a 32 bit version and a 64 bit version for SQL Server 2005 SP2 and for SQL Server SP3. Is this what you are asking? this is the link to download SP3 http://www.microsoft.com/downloads/details.aspx?FamilyId=AE7387C3-348C-4FAA-8AE5-949FDFBE59C4&displaylang=en
These Service pack are enhancements to the base version of SQL 2005. If you are using a 32 bit version of SQL you install 32 bit version of SP3. If you are using the 64 bit version of SQL you download the 64 bit version of SP3.
Francis
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 15, 2010 10:02 AM
Points: 244,
Visits: 746
|
|
erm, not quite. I already have sql server 2005 SP3 installed (patched to CU5) on the server, what i'm asking is whether the "Common Criteria Certification" profile will work under sql server 2005 SP3 as there is only a download for a SP1 and SP2 profile.
What i'm asking is whether the SP2 version of CCC will work on a server patched to SP3.....?
In fact, just opened the trace file and it says this:
-- If the version is not SP2 version 9.0.3068.00 then do not run the script
IF SERVERPROPERTY(N'ProductVersion') <> '9.00.3068.00'
BEGIN
RAISERROR('You can run this script only on SQL Server 2005 SP2 version 9.00.3068.00', 20, 127) WITH LOG
END
Could it be that its just that this has not been updated since SP3 came out?
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 1,760,
Visits: 1,014
|
|
Sorry for missunderstanding the question.  The code sure looks like it hasn't been updated to accomodate SP3. I can't answer for sure. I did find info on SQL 2005 SP1 and SP2 but not SP3. See http://www.microsoft.com/sql/commoncriteria/certifications.mspx
So maybe SP3 is just missing or unsupported. This may be worth a call to Microsoft support.
Francis
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 7:29 AM
Points: 2,019,
Visits: 1,653
|
|
Definitely call MS support about this. As far as I know Microsoft have not published any advice that CCC support is restricted to specific fix levels, so it should apply to all fix levels.
Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2005, 2008, and 2008 R2. 24 February 2010: now over 9,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
|
|
|
|
