November 18, 2009 at 10:43 am
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!!
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
November 18, 2009 at 3:01 pm
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
November 19, 2009 at 3:06 am
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?
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
November 19, 2009 at 8:28 am
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
November 23, 2009 at 3:46 am
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.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply