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…
-
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…
-
Installing SCCM 2012
Here are my notes for installing SCCM 2012: I have already been using SCCM 2007 for a couple of years now. It has been working fine. Now SCCM 2012 has come out so we have to upgrade. Note that my domain controllers are still Windows 2003 R2 SP2. I am following this very useful website which describes how to do an SCCM 2012 install. My running commentary as I go through the steps described in the web-page above.
-
Find account’s disable date and more in AD
First of all, please note that there is no disabled time stamp attribute in AD. Having said that, here are some tips to find when an account was disabled in Active directory: You can use ADSIedit to look at an account’s properties. Scroll all the way down and look at the Attribute called “whenChanged”. This will tell you when the account was disabled.
-
Windows 7 & 2008 blocks stuff downloaded from internet
So I found a very interesting fact about how Windows may tag a script/executable you downloaded from the Internet as “blocked”. So when you try to execute that script on a command line it won’t work. Yup, a very interesting ‘feature’ of Windows OSes. I have confirmed this on Windows 7 and Windows 2008R2 Check it out here: