System Center Virtual Machine Manager R2 installation with local SQL 2012 DB

Active Directory Setup:

  • DOMAIN\scvmmsvc SCVMM Service Account account
  • DOMAIN\scvmmadmin RunAs account for managing hosts
  • DOMAIN\sqlsvc  SQL service account
  • DOMAIN\SCVMMAdmins SCVMM Administrators security group

Prerequisites List (DPM Server):

  • Install Server 2012 R2 Operating System.
  • Join server to the domain.
  • Install all windows updates so the server is fully patched.
  • Add the “scvmmsvc” and “scvmmadmin” account to the “SCVMMAdmins” global group.
  • Add the “DOMAIN\SCVMMAdmins” domain global group and the “DOMAIN\scvmmsvc” domain account explicitly to the Local Administrators group on each SCVMM role server.
  • Ensure that the server has a minimum of 4GB of Ram.
  • Windows Assessment and Deployment Kit (ADK) for Windows 8.1

Install Windows Assessment and Deployment Kit for Windows 8.1 (ADK)

Click on the link below to download the ADK

scvmm1

  • Click on the checkbox to accept the terms for .NET and then click on the “Accept & Install” button for .NET Framework 4.5 to install.

scvmm2

  • When you get prompted to restart click the Ok button.

scvmm3

  • After the server has rebooted the installation will resume. You can choose the default option as shown above or Download the ADK to a share and run the install from there. I chose the default, click the Next Button to proceed.

scvmm4

  • Make your selection and then click the Next button.

scvmm5

  • Accept the License agreement for the installation to continue.

scvmm6

  • Only install the following options above:
  • Deployment Tools
  • Windows Preinstallation Environment (Windows PE)
  • Click the Install button.

scvmm7

  • Progress screen..

scvmm8

  • Once the installation finishes you will get the screen above. Click the close button. The ADK is now setup.

Install SQL Server (2012 SP1)

sql1

  • Double click the setup file located in the SQL 2012 SP1 Media
  • The screen above will show, click on “New SQL Server Stand-alone installation or add features to an existing installation”

sql2

  • The above screen will show, if there are any warnings or errors it will list them. Click Ok to continue.

sql3

  • Here you can enter a product key that you received from MS found on the media.
  • In this Sandbox setup we will choose “Evaluation” and then click the Next button.

sql4

  • Click the checkbox to accept the license terms and then click the Next button.
  • If there are any updates on the next screen let them download and proceed with the install.

sql5

  • Again the support rules will run, click Next to continue

sql6

  • Select the first option and click the Next button.

sql7

  • On the feature selection screen, choose the following options:
    • Database Engine Services with Full-Text and Semantic Extractions for Search
    • Reporting Services – Native
    • Management Tools and its sub-feature.

sql8

  • Click Next to continue

sql9

  • I left the instance as default, click the Next button to continue.
  • If you want to create your own instance for SCVMM then click on the radio button that says named instance.

sql10

  • Click Next to continue.

sql11

  • As this is a Sandbox environment the defaults were chosen but you will want to add in the Domain accounts that have access to SQL in a production Environment.
  • Don’t click next just yet, we need to set the Collation as with SCOM. Click the Collation Tab next to the Service Accounts Tab.

sql12

  • Click on the Customize button to change the collation.

sql13

  • Click on the radio button labelled “SQL Collation, used for backwards compatibility”
  • Scroll down until you see “SQL_Latin1_General_CP1_CI_AS”. Click on it and then click OK.

sql14

  • Add in the Current User and any other user that will be managing SQL. Remember to add in the user you created at the beginning of the document. Click Next to continue.

sql15

  • Select the option “Install Only” and then click Next. We will configure this later on.

sql16

  • Make your selection and click Next.

sql17

  • Click Next to continue.

sql18

  • Review all the options you just made, if happy click the Install button.
  • Sit back and wait for the installation to finish, it can take a while.

  Install System Center Virtual Machine Manager 2012 R2

Open up the SCVMM media and double click Setup.

vmm1

  • When the splash screen loads click on the Install Button.

vmm2

  • Select the VMM Management Server which includes the VMM Console and click Next.

vmm3

  • Enter in the following information:
    • Name
    • Organization
    • Product key
  • Click Next.

vmm4

  • Click on the check box to select the License Agreement and then click Next.

vmm5

  • Make you select and then click Next.

vmm6

  • Accept the default path or install to a different directory by clicking the browse button.
  • Click Next.

vmm7

  • Enter in the Server Name.
  • If you want to use different credentials then tick the checkbox and enter in the details.
  • Specify an instance name by clicking the drop down. This will be the instance you created when you installed SQL.
  • Create a new database or use an existing one you created earlier.
  • Click Next.

vmm8

  • Enter in the Domain account and password.
  • If you want to store the information in AD then select the checkbox and enter in the location.
  • Click Next.

vmm9

  • Check the ports, if you happy click Next.

vmm10

  • You can create a new library share or use an existing one. Once you have made your choice click Next.

vmm11

  • Summary screen, click the Install button.

vmm12

  • Installation is now complete.
  • Click the close button.

Open up SCVMM, you will see the splash screen below:

vmm13

vmm14

  • Window of what SCVMM looks like.
  • Now you can go ahead and create your VM’s.

Hope it helps.

SharePoint 2013 SP1 Installation with local SQL 2012 DB

Active Directory Setup:

  • Create 3 Accounts to be used for SharePoint:
    • SPAdmin – Used to login to Central Admin
    • SPFarm – Farm Account
    • SPServices – SharePoint services account.

Prerequisites List (SharePoint Server):

Windows Features Requirement:

Import-Module ServerManager

Add-WindowsFeature Net-Framework-Features,Web-Server,Web-WebServer,Web-Common-Http,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-App-Dev,Web-Asp-Net,Web-Net-Ext,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Health,Web-Http-Logging,Web-Log-Libraries,Web-Request-Monitor,Web-Http-Tracing,Web-Security,Web-Basic-Auth,Web-Windows-Auth,Web-Filtering,Web-Digest-Auth,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Mgmt-Tools,Web-Mgmt-Console,Web-Mgmt-Compat,Web-Metabase,Application-Server,AS-Web-Support,AS-TCP-Port-Sharing,AS-WAS-Support, AS-HTTP-Activation,AS-TCP-Activation,AS-Named-Pipes,AS-Net-Framework,WAS,WAS-Process-Model,WAS-NET-Environment,WAS-Config-APIs,Web-Lgcy-Scripting,Windows-Identity-Foundation,Server-Media-Foundation,Xps-Viewer –Source D:\sources\sxs

Replace D:\ with your drive letter.

SharePoint 2013 SP1 Prerequisites:

You can download all the install files to location on your SharePoint Server and then install the files manually or run a script below to install them. (**If you want to use the GUI to download and install the prerequisites you can do so**)

Location of Files:

SQL Server 2008 R2 SP1 Native Client
http://download.microsoft.com/download/9/1/3/9138773A-505D-43E2-AC08-9A77E1E0490B/1033/x64/sqlncli.msi

Microsoft WCF Data Services 5.0
http://download.microsoft.com/download/8/F/9/8F93DBBD-896B-4760-AC81-646F61363A6D/WcfDataServices.exe

Microsoft WCF Data Services 5.6 (rename this download to WcfDataServices56.exe)
http://download.microsoft.com/download/1/C/A/1CAA41C7-88B9-42D6-9E11-3C655656DAB1/WcfDataServices.exe

Microsoft Information Protection and Control Client (MSIPC)
http://download.microsoft.com/download/9/1/D/91DA8796-BE1D-46AF-8489-663AB7811517/setup_msipc_x64.msi

Microsoft Sync Framework Runtime v1.0 SP1 (x64)
http://download.microsoft.com/download/E/0/0/E0060D8F-2354-4871-9596-DC78538799CC/Synchronization.msi

Windows Identity Extensions
http://download.microsoft.com/download/0/1/D/01D06854-CA0C-46F1-ADBA-EBF86010DCC6/r2/MicrosoftIdentityExtensions-64.msi

Windows Identity Foundation (KB974405)
http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu

Windows Server AppFabric
http://download.microsoft.com/download/A/6/7/A678AB47-496B-4907-B3D4-0A2D280A13C0/WindowsServerAppFabricSetup_x64.exe

CU 1 for AppFabric 1.1 (KB2671763)
http://download.microsoft.com/download/7/B/5/7B51D8D1-20FD-4BF0-87C7-4714F5A1C313/AppFabric1.1-RTM-KB2671763-x64-ENU.exe

Install each of these files in order except for the last 2 as AppFabric requires configuration.

Open up an elevated prompt and run the following:

  • WindowsServerAppFabricSetup_x64.exe /i CacheClient”,”CachingService”,”CacheAdmin /gac

Once that is done then install CU1 for AppFabric.

Restart your server once all this is done.

If you want to use a script to install the files rather than doing it manually then run the following:

**Change the <Drive> entry to where you downloaded all the files to**

$SharePoint2013SP1Path = “<Drive>\SharePoint2013SP1Install”

Start-Process “$SharePoint2013SP1Path\PrerequisiteInstaller.exe”

–ArgumentList “/SQLNCli:$SharePoint2013SP1Path\PrerequisiteInstallerFiles\sqlncli.msi

/WCFDataServices:$SharePoint2013SP1Path\PrerequisiteInstallerFiles\WcfDataServices.exe

/WCFDataServices56:$SharePoint2013SP1Path\PrerequisiteInstallerFiles\WcfDataServices56.exe

/Sync:$SharePoint2013SP1Path\PrerequisiteInstallerFiles\Synchronization.msi

/IDFX:$SharePoint2013SP1Path\PrerequisiteInstallerFiles\Windows6.1-KB974405-x64.msu

/IDFX11:$SharePoint2013SP1Path\PrerequisiteInstallerFiles\MicrosoftIdentityExtensions-64.msi

/MSIPCClient:$SharePoint2013SP1Path\PrerequisiteInstallerFiles\setup_msipc_x64.msi”

Install SQL Server:

Double Click the setup file in the SQL install directory.

sql 1

  • Click on the Installation link/button.
  • Now select “New SQL Server stand-Alone installation or add features to an existing installation link.

sql 2

  • The Setup Support Rules screen will show, click Ok to continue.

sql 3

  • Enter your product key that you got from your MS reseller or enter your TechNet license and click Next.

sql 4

  • Accept the license terms checkbox and then click Next.

sql 5

  • Let SQL download any updates by selecting the checkbox above and then click Next.

sql 6

  • Progress screen will show while downloading and installing the updates.

sql 7

  • Splash screen will appear before the next SQL screen comes up.

sql 8

  • The Setup and Support Rules will run, if there are any failures you will need to address those before you can continue. With this installation it was only giving a warning about the windows firewall. Click Next.

sql 9

  • Choose the option above and then click Next.
  • Select the following features:
    • Database Engine Services
    • Client Tools Connectivity
    • Client Tools Backwards Compability
    • Management Tools – Basic
  • Click Next.

sql 10

  • Review the status of each option above, if there are failures then address those first before you continue. Click Next to continue.

sql 11

  • Select the default instance and click Next.

sql 12

  • On the disk space requirements page, review the summary and click next.

sql 13

  • Enter in the accounts that we setup in the beginning and then click Next.

sql 14

  • Select Mixed mode and then enter in the SA password.
  • Also click the “Add Current User” button and add in the user we created above. Click Next.

sql 15

  • If you want to send report to MS then click the checkbox and click Next.

sql 16

  • Review the installation rules and address any failures if there are and click Next.

sql 17

  • Click the Install button to start the installation.

sql 18

  • Installation of SQL complete. Click the close button.
  • Login to SQL Management Studio now and grant the SPAdmin the DB_Creator and Security_Admin Rights.
  • Close SQL Management Studio.

Install SharePoint 2013:

Open up Explorer and go to the SharePoint ISO and double click the setup file. We are going to install SharePoint server.

sp1

  • Enter in your product key and wait for it to be verified. Click the Continue button.

sp2

  • Accept the license agreement and click the Continue button.

sp3

  • Select Complete as we are going to be doing a full installation. Click the Install Now button.

sp4

  • The installation takes a little while, depending on your hardware.

sp5

  • Finalization screen.

sp6

  • Setup is now complete. Click the Close button.

Configure SharePoint 2013

sp7

  • Press the windows key and the click on SharePoint 2013 Products Configuration.

sc1

  • Click Next to start the configuration wizard.

sc2

  • The splash screen above will show, click yes to stop the services and continue the setup.

sc3

  • Accept the default settings or enter in a database server (I removed my name from the screen shot)
  • Select the first option “Do no disconnect from this server farm” and click Next.

sc4

  • You can specify a port number as above or accept the one assigned. Select your Security settings and then click Next.

sc5

  • Review your selection and then click the Next button to start the configuration/installation.

sc6

  • Installation progress.
  • Step 2 takes a few minutes and then the rest of the steps go pretty quickly.
  • Step 9 and 10 also take some time. Just be patient for the install to finish.

sc7

  • Configuration successful. Copy the URL for Central Administration and paste it in a web browser to start the configuration of SharePoint 2013 in your environment.

Advanced configuration SharePoint 2013

sc8

  • Select the option that suites you and click Ok.

sc9

  • Central Administration Webpage.
  • Now you can setup your search services, user profile services and creating or managing your websites.

Hope it helps.

System Center Operations Manager 2012 R2 Installation with local SQL 2012

SCOM is quite a big installation and I thought I would put something together to help the community out, here is the guide:

Active Directory Setup:

Create the following accounts/Groups in Active Directory.

  • DOMAIN\OMAction           (Action account)
  • DOMAIN\OMData              (Data Access service account)
  • DOMAIN\SQLUser              (SQL service account)
  • DOMAIN\OMAdmins          (Operations Manager Administrators security group)

Add the “OMData” and Action account to the “OMAdmins” Group.
Add your account or any other member that is going to administer SCOM to the “OMAdmins” group.

Prerequisites List (SCOM Server):

  • Install Server 2012 OS
  • Join server to the domain
  • Install all windows updates so the server is fully patched.
  • Install SQL 2012.
  • Install Microsoft System CLR Types for SQL Server 2012.
  • Install the Report Viewer controls.
  • Add the “OMAdmins” domain global group to the Local Administrators group.

Download links for Report viewer and System CLR Types:

Windows Features Requirement:

Run the following from Powershell (run as Administrator):

  • Add-WindowsFeature NET-WCF-HTTP-Activation45,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Http-Logging,Web-Request-Monitor,Web-Filtering,Web-Stat-Compression,Web-Mgmt-Console,Web-Metabase,Web-Asp-Net,Web-Windows-Auth -Source D:\sources\sxs –Restart
  • Replace D:\ Above with your servers drive letter that has the Server Media.

Install SQL Server

SQL Server 2012 Setup - SCOM

  • Install the features as selected above, optionally you can install the Management tools.
  • **NB** Make sure you Collation is set correctly or SCOM will not install.
  • Collation: SQL_Latin1_General_CP1_CI_AS
  • Once installed make sure that you set the Maximum Server Memory (you need SQL Management tools), you need need a minimum of 2GB of Ram, Recommended is 4GB or higher.
  • Also ensure that your SQL Server Agent service is started.

Install Microsoft CLR Types for SQL Server 2012 SP1

clr1

 

  • Click Next and then Finish.

Install Report Viewer Controls

report viewer

  • Click Next and then Finish.

Install System Center Operations Manager R2 (SCOM)

SCOM start page

  • Right click the Setup file in the installation directory and choose “Run As Administrator”. A screen as shown above will come up.
  • Make sure that the option “Download the latest updates to the setup program” is ticked and then click Install.

scom online updates

  • Screen comes up when you check for online updates.

operations manager setup

  • Select the top 3 features as shown above, do not install the Reporting Server yet.
  • Click the Next button.

operations manager proceed with setup

  • If any warnings or errors appear they will show under Management Server.
  • Click Next to continue the setup.

operations manager group setup

  • Enter a Management Group name that is Unique. I used SLabTest as my name.

operations manager operational database

  • Enter the Server Name and Instance, the setup will display a green wheel while it’s thinking, once it has found and verified the name click Next. If there is a problem it will give you an error about the instance name.

operations manager web console

  • Choose the web site, I leave it default. If you want SSL then click the checkbox “Enable SSL” and then click Next.

scom authentication mode

  • Choose the authentication mode and then click Next.

scom manager accounts

  • Enter in the accounts you created in beginning with their passwords and click Next.

scom domain account warning

  • You will get the following warning if you used a Domain Administrator Account. This is a lab so I used an account with full access.

scom customer experience

  • Make your choice and click Next.

scom manager setup summary

  • Summary of configuration (some info removed), click the Install button to proceed.

SCOM installation progres

  • Installation in progress. Sit back and relax.
  • When finished all the options will show a green tick. If not you will get a warning/error and you need to review the logs for failure.

After the installation do a reboot.

Make sure that all SQL services are started and all SCOM services.

Launch SCOM you will see this screen:

scom startup splash

Install Reporting Server for SCOM.

scom reporting feature

  • Double click the setup file again and go through the initial steps. Once you get to the Feature section only select Reporting Server and click Next.

scom specify management server

  • Type in Management Server name and click the Next button.

scom sql server instance RS

  • Select an instance from the drop down and click Next.

scom RS accounts

  • Enter the details of the account you created earlier or an account that has access to reporting.

scom RS summary

  • Installation Summary, some information removed but it will display the Management Server, Reporting Server and its instance and the Data Reader Account.

scom RS complete

  • Once the installation is complete you will get this screen above.
  • Next, it is time to configure reporting.

If you open up SQL Reporting Services you can setup the account with access, the reporting URL etc.

Once you click on the Reporting URL you will be shown the following page.

sql reporting services webpage

  • If SQL Reports are working correctly the screen above will show.

If we launch SCOM now and go to the reports console you should see reports.

scom reports console

Hope it helps.

DPM 2012 SP1 Installation with SQL 2012 (Local)

DPM 2012 SP1 Installation with local SQL 2012 DB.

 Active Directory Setup:

  • Create 2 groups, one for your DPM admins and one for SQL.
  • Add the user account that is going to administer DPM and SQL to the groups you created above.

Prerequisites List (DPM Server):

  • Install Server 2012 OS
  • Join server to the domain
  • Install all windows updates so the server is fully patched.
  • Add the DPM Admin group that you created above to the Local Administrators Group on the DPM server.

Windows Features Requirement:

  • You need to install .NET 3.5, you can do so by selecting using the GUI of Server Manager or running it from powershell, remember you need to select a source. Replace D:\ with your drive letter.

Add-WindowsFeature NET-Framework-Core –source D:\sources\sxs

Install SQL Server

SQL feature selection

  • Install the features as selected above, optionally you can install the Management tools.

SQL Instance configuration

  • Select a Named Instance, I choose to give it a name that is easily identified, for example HODPM (I removed the name from the screenshot)

SQL Server Configuration

  • Here you need to specify a domain account to use, if this is sandbox installation then a local account is fine. E.G. for the Account name: Domain\username

SQL Database Engine Configuration

  • Select your Authentication method, if you want to use Mixed Mode then to provide a password for the SA account (from experience if this server is hosted on the internet, rather create another account and set a strong password as SA accounts on the Internet are vulnerable)
  • Add in your account or the account that will administrator SQL (as created in Step 1 when the AD accounts and groups were setup)

 Install DPM 2012 SP1

  • Mount the DPM media.
  • I normally right click the install and select “Run As Administrator”

DPM pre check

  • Select “Use an existing instance of SQL Server” and then type in the name of your SQL Instance: YourDPMServerName\YourSQLInstance, click on Check Again.
  • If the connection was successful the “Next” button is not greyed out anymore as shown below.
  • If there are any warnings it will show in the details section. You might get warnings for memory or firewall etc.

DPM pre check with next button

DPM installation settings

  • On the installation Settings screen you can modify where DPM will be installed or accept the defaults and then click the Next button.

DPM Summary of settings

  • Review the Summary and then click Install.

dpm installation complete

  • Once the installation completes it will show as above.

 **Bug with the install ?**

dpm error

  • If you get the above error just re-launch the setup and it will be fine.

Hope it helps.

DPM 2012 SP1 Backing up SQL 2012 Database Error

I migrated SharePoint to a new server with SQL 2012 SP1 and setup backups with DPM.

The initial setup went fine as DPM could see the Farm, however after the protection group was setup the backups failed immediately with the following error:

  • Unable to Configure Protection

Not a problem, what I have seen from documents seems like a bug in DPM 2012 trying to backup SQL 2012.

To fix this, open up SQL Management Studio, Navigate to Security, expand logins and locate the following account:

  • NT Authority\SYSTEM

Right click on this account and select properties. Go to server roles and tick “sysadmin”. Apply these changes. Now go back to DPM and do a consistency check. It should now backup the databases.

If that fails, delete the protection group and create it again.

Hope it helps

SQL Server Reporting Services Error

Last week I upgraded one of my test servers from Windows Server 2012 to Windows Server 2012 R2. The upgrade went successfully except for one service. The SQL Server Reporting Services. I wanted to pull a report and the app I was using reported the service wasn’t started.

I clicked start only to get the famous error that some services stop and start if they have nothing to do. Okay, time to check the logs. Here was the error reported:

Service cannot be started. System.IO.FileLoadException: Could not load file or assembly ‘ReportingServicesNativeServer, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail. (Exception from HRESULT: 0x800736B1)
File name: ‘ReportingServicesNativeServer, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ —> System.Runtime.InteropServices.COMException (0x800736B1): The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail. (Exception from HRESULT: 0x800736B1)
at Microsoft.ReportingServices.Library.ServiceAppDomainController..ctor()
at Microsoft.ReportingServices.Library.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedM…

Quite a long error. I simply opened up Programs and Features and ran a repair on SQL. After that the service started without any issues.

Hope it helps