• IT Systems Engineering,  Uncategorized

    My fourth attempt at installing SCCM 2012

    ok today I am going to try to install SCCM 2012 again! Yup….this time is going to be my fourth attempt after three unscuccessful installation attempts. This time I am going to use a remote SQL server which is running on a 64bit OS. In my last attempt, I determined that the remote SQL server needs to be running on a 64bit OS. Note that I have already updated the SQL server as per the minimum requirements of SCCM 2012. Here it goes…        

  • IT Systems Engineering

    Updating SQL Server 2008 R2 for use with SCCM 2012

    ok folks…here is how I upgraded my SQL server 2008 R2 instance to the version SCCM requires SQL Server 2008 R2 with SP1 and with a minimum of Cumulative Update 6 First, lets download CU6 from here. After installing CU6 the SQL log file shows that I have this version: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2811.0 (X64) So that equates to SP1 CU #6 (2679367) Apr 16, 2012 Ok so that should satisfy the requirements of SCCM 2012.

  • IT Systems Engineering

    SQL Server for SCCM 2012

    During my testing of SCCM 2012, I determined that it needs a specific configuration of SQL server. This post tells you what needs to be done. I have a SQL server 2008 instance already installed for use with SCCM 2007. I was hoping I could use the same VM for SCCM 2012 testing. This post is in reference to that VM. Check out the official SQL server requirements list. Out of this I am listing my own experiences here: 1. Database collation: My SQL server has SQL_Latin1_General_CP1_CI_AS I also checked a few other DB servers, they already have the Database collation required by SCCM 2012 installed by default. So I did not…

  • IT Systems Engineering

    Installing updates on SQL Server 2008

    So when I was installing SCCM 2012 I found  out that I need to install patches/updates on my SQL server. To find out what version I was running I looked at this document. How to determine which version and edition of SQL Server Database Engine is running To determine the version of SQL Server, you can use any of the following methods: Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server. Method 2: Look…