Archive for the ‘Uncategorized’ Category

Sequencing virtual machines startup script

Friday, January 17th, 2014

Whether it's for disaster recovery, maintenance or for your home lab, it's nice to be able to start-up machines in a specific order without having to do it manually. You can do it with vApps, but there are operational drawbacks in doing so, from those pesky warnings when you shutdown/startup ...

SCCM 2012 R2 Installation Script (Part 2)

Monday, December 30th, 2013

Here are the SQL scripts and the VBS. EnableMicrosoftUpdate.vbs Set ServiceManager = CreateObject("Microsoft.Update.ServiceManager") ServiceManager.ClientApplicationID = "My App" 'add the Microsoft Update Service by GUID Set NewUpdateService = ServiceManager.AddService2("7971f918-a847-4430-9279-4a52d1efe18d",7,"") This is the SQL Configuration File SQL2012-ConfigurationFile.ini [OPTIONS] IACCEPTSQLSERVERLICENSETERMS="True" SAPWD="Welcome!" ACTION="Install" ENU="True" QUIET="False" QUIETSIMPLE="True" UpdateEnabled="True" FEATURES=SQLENGINE,SSMS,ADV_SSMS UpdateSource="MU" HELP="False" INDICATEPROGRESS="False" X86="False" INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server" INSTALLSHAREDWOWDIR="D:\Program Files (x86)\Microsoft SQL Server" INSTANCENAME="MSSQLSERVER" INSTANCEID="MSSQLSERVER" SQMREPORTING="False" ERRORREPORTING="False" INSTANCEDIR="E:\SQLInst" AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" AGTSVCSTARTUPTYPE="Automatic" COMMFABRICPORT="0" COMMFABRICNETWORKLEVEL="0" COMMFABRICENCRYPTION="0" MATRIXCMBRICKCOMMPORT="0" SQLSVCSTARTUPTYPE="Automatic" FILESTREAMLEVEL="0" ENABLERANU="False" SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" SQLSYSADMINACCOUNTS="BUILTIN\Administrators" SECURITYMODE="SQL" SQLBACKUPDIR="F:\SQLBack" SQLUSERDBDIR="E:\SQLData" SQLTEMPDBDIR="E:\SQLTemp" ADDCURRENTUSERASSQLADMIN="False" TCPENABLED="1" NPENABLED="0" BROWSERSVCSTARTUPTYPE="Disabled" And last, the SQL script to set the memory sizes (didn't ...

SCCM 2012 R2 Installation Script (Part 1)

Monday, December 30th, 2013

Well, as promised here is the script to setup all the pre-reqs for SCCM 2012 R2. To run this, you need to copy the files in the D: drive. You need: An SQL configuration file (SQL2012-ConfigurationFile.ini) An SQL script to set the memory sizes (SetSQLMemory.sql) A VBS script to enable the Windows Update feature (EnableMicrosoftUpdate.vbs) WUInstall ...

SCCM, SQL and PowerShell

Friday, December 27th, 2013

I also got involved with pretty much every aspect of the new environment (it's a consolidation project), with Active Directory, SQL Server, SCCM 2012, etc... Having last worked with SMS 2003 R2, I decided to start playing with SCCM 2012. Foundations are the same as SMS so far, so nothing too ...

State of things…

Friday, December 27th, 2013

I have lost a little of my drive to study in the past year, I guess I gave too much the year before with the CCNP, CCNA Security, and the MCSE 2012 :) Soooo... I'm trying to get back into it a bit. I have moved to a new mandate, doing ...

Summertime!

Thursday, August 1st, 2013

It's been a while since my last update! My current mandate is almost over, what started as a 3 week replacement for a sysadmin lasted almost 2 years overhauling the entire infrastructure, going from a room full of standalone physical servers on 100mbps network with cabling issues, to a modern ...