Introduction
In the company I work for we build hundreds of new SQL instances each year, I was asked to develop a fully automated way to install SQL, with the aim to speed up the build process and standardize all SQL builds for all SQL install features (RDBMS, SSAS, SSIS, SSRS. Clustered and Standalone), I googled it and found nothing on this subject, it appears nobody has done this before, or at least not documented yet anyway. This Blog will highlight the process in as much detail as I get time to document; its a very big process but once implemented requires only a very small amount of human interaction. Here we go..........Prerequisites
An SCCM management server that is currently managing your server environment, access to create collections, adverts, task sequences.Powershell skills.
Active Directory read access.
SQL installation skills, with a knowledge of the config.ini for silent installs.
Quick view of the end-to-end process
That diagram is a work of art and some nice pointers there since I have to install SQL 2008 R2 SP1 myself tomorrow. Nice blog mate.
ReplyDeleteThanks Colin. The technical details/scripts will follow shortly, however I submitted it to SQLservercentral.com also, they want to publish it in a technical article, so I'm currently documenting it fully. It will either appear here or on their website when it gets published. I will update this when I know more.
ReplyDelete