Everything-Virtual

Category: SQL2012

  • Microsoft SQL 2012 Installation Video for SCCM 2012 R2

    Quick video to show a SQL 2012 Installation to use with SCCM 2012 R2

     

    Microsoft SQL 2012 Installation Video for SCCM 2012 R2 from Everything-Virtual.com on Vimeo.

  • Microsoft SCCM 2012 R2 – Pre-Requisite Installs Part 2

    In Part 1 of this multi-part post I detailed the Active Directory requirements for installing SCCM 2012 R2, in this post is the SQL Installation. In my lab I am going to be running this from an already existing SQL 2012 instance and I just needed to add the Reporting Services component to my installation, however the installation routine for adding the Reporting Services is somewhat similar for a new SQL installation and where it’s different I will let you know.

    I know I said that Part 2 would contain the Windows OS requirements for the SCCM 2012 R2 installation but this has proven to be a bit longer than I expected.

    (more…)

  • Creating vCenter and VUM 5.5 databases.

    As a precursor to installing vCenter 5.5 in my 2012R2 lab at home I needed to create the vCenter and VUM databases in SQL 2012 and make sure that everything was setup correctly before the vCenter installation.

    To make things easier I used the SQL Scripts below to create two DBs (VC55 and VUMDB) as well as creating the vc_user account and password.

    [code lang=”sql”]USE MASTER;
    GO
    CREATE DATABASE [VC55] ON PRIMARY(
    NAME=’VC55′,
    FILENAME=’D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\VC55.mdf’,
    SIZE=5000KB,
    FILEGROWTH=10%)
    LOG ON
    (NAME=’VC55_log’,
    FILENAME=’E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\VC55.ldf’,
    SIZE=1000KB,
    FILEGROWTH=10%)
    COLLATE SQL_Latin1_General_CP1_CI_AS
    GO
    [/code]

    (more…)