Jan 232015

In my previous post, I walked you through the installation of a SQL 2012 Server. Today, I’ll explain how to install SQL 2012 for Operation Manager Data Warehouse. This long-term data warehouse database is used by the OpsMgr 2012 SP1 Reporting Server. Once SQL installation is completed, we’ll configure the SQL Reporting Services and validate that it’s functioning correctly.

How to Install SQL Server 2012

This installation is similar to SQL Server installation: you select the same options you did for the SQL Server, and then select the reporting service. Once the service is installed, you’ll configure it.

Open a session with Administrator on MTLRS01 Server (or whatever name you’ve given to your server) and add the OMAdmins group in the Administrators local group of the server. You can also add any other groups or user that you would like to give admin rights to.

Administrators Properties - OMAdmins

Close the session and open a new one with the OMAdmin user or any user that is an administrator of the reporting server. Click Setup and Installation. Once you’re in the SQL Server Installation Center, click New SQL Server stand-alone installation or add…

New SQL Server stand-alone installation

In Setup Support Rules, click Show Details. Validate that all statuses are passed and click OK.

Setup Support Rules - show details

If you have an evaluation or a serial number, select Specify a free edition, then select Evaluation or Serial Number. Then select Enter the product key, type your product key and click Next. Select I accept the licence terms. If you want to send usage data to Microsoft, also select Send feature usage data to Microsoft and click Next.

Product Key

If you want to install the product update, select Include SQL Server Setup Update. The update will automatically download and install. Again, click Show Details to ensure that all statuses are passed before you click Next.

Product Updates

In the Setup Role section, select SQL Server Feature Installation and click Next.

This server will be used only by the Operations Manager Reporting Database (data warehouse) and is the long-term database. Select the following: Database Engine Services, Full-Text and Extraction…, Reporting Services – Native, Management Tools Basic and Management Tools – Basic. This will install all the tools required to manage the SQL Server. Replace the C: path by D: or any other disks and click Next.

Feature Selection

Click Show Details and validate all statuses are passed before you click Next.

 Installation Rules

In the Instance Configuration section, enter OpsMgrRS in the Name instance field. You can also install SQL without any instance. Change the Path to D: and click Next. You’ll then access the Disk Space Requirements window. Click Next.

Instance Configuraion

For both SQL Service Agent and SQL Server Database Engine, select SRVCSQL user. This is only a domain user and it has no Administrators right on the SQL Server. Make sure to set the Startup Type to Automatic for both services. For the SQL Reporting Services, select OMDWR user. Then select the Collation tab.

Server Configuration

You can use the default which is SQL_Latin1_General_CP1_CI_AS, or choose another supported collation. Then click Next.

Note: The Collation cannot be changed after SQL installation: it‘s very important to select the collation that is supported.

In the Database Engine Configuration window, select Windows Authentication Mode click Add and select the OMAdmins group or admin user needed to install the reporting server. Click Next.

Database Engine Configuration

In Reporting Services Configuration, select Install Only and click Next. Click Next Again in Error Reporting until you get to the Installation Configuration Rules. Then select Show details. Once you’ve ensured that all statuses are passed, click Next.

Installation Configuration Rules

When you get to the Ready to Install section, click Install and wait until all statuses read Succeeded before you click Close.

SQL Server Completion

Validate that SQL is working

On MTLRS01 server, your session is open with OMAdmin user. Press the Windows Key and select SQL Server Management Studio.  Then select Server Name MTLSQL01\OPSMGRRS and click Connect.

Pop-up window - Connect to server

Once you are connected, expand the Server, Databases and System Database. Then validate that the 4 databases are created and mounted. The SQL Reporting Server Database are not created yet.

Expand Server, Databases and System Database

Configuring SQL reporting Services

In this section, we’ll configure and create the SQL reporting Service Database, which will be used to save all OpsMgr Reports.

On MTLRS01 Server, your session is open with OMAdmin user or any other user you used to install the Reporting Server. Press the Windows Key and select Reporting Services. If the Reporting Services is not there, ensure you pin it to the Start menu.

Start menu

Connect to the server and click Service Account. Validate that the current domain user is an administrator of the Reporting Server.. Click Web Service URL to accept the default URL and click Apply. Then validate that the URL was created and click Database and Change Database.

Web Source URL

Select the Create a new report Database and click Next. Double-check the Server Name field corresponds to MTLRS01 \OpsMgrRS and click Test Connection. You will get the confirmation message Test Connection Succeeded to confirm the connection is working properly. Click OK.

Report Database Configuration WizardDouble-check that the Server Name still reads: MTLRS01\OpsMgrRS and click Next. Accept the Default and click Next. Click Next again and you will access the Summary window. Validate that everything is OK and click Next.


In the Progress and Finish window, ensure that all statuses are Success before you click Finish. Select Report Manager URL and accept the default by clicking Apply.

Report Manager URL

To validate that the URL was created, double-click on the URL: http://MTLRS01:80/Reports OPSMGRRS01.

SQL Reporting Services - Home

The SQL Server Reporting Services Home will open. Return to Web Service URL and click on URL http://MTLRS01:80/ReportServer_OPSMGRRS. The Microsoft SQL Server Reporting Services will open, validating that the SQL Reporting Services is working.

Web Service URL

In the Encryption Keys section, click Backup. In the pop-up window, type in the File Location of the Encryption Key: C:\Sources\RS Encrypted. Enter a password and confirm it. Ensure that this file is taken by your backup and click OK

Backup Encryption Key

Start by opening SQL Server 2012 Management Studio, and ensure that the server name and the instance are there. Here it’s MTLRS01\OpsMgrRS.

Connect to server - Pop-up window

Expand MTLRS01 and expand Databases. Validate that both ReportServer and ReportServerTempDB databases were created as we can see below. Install the Last Service pack and Cumulative roll up for SQL 2012 before you install OpsMgr 2012.

Expand MTLRS01 and Databases

Congrats, your SQL Reporting Server is now installed!

The post Installing SQL 2012 Server for Reporting Server appeared first on SherWeb.

Jan 122015

Microsoft SQL Server databases are used by over 68% of sites that use one or more database technologies. Surpassed by only Oracle databases, it means most DB admins will have to install or manage SQL servers at one point or another.

In this article, I’ll walk you through the installation of an SQL Server 2012.

How to Install the SQL Server 2012

Setting up the SQL Server is pretty straightforward. Follow these steps:

First, on MTLSQL01, open a session as an Administrator. Add the OMAdmins Group or any other group/user that will be used for this installatio in the Administrators Local group of the MTLSQL01 Server and then close the session.

Note: The server name is an example. You can use whatever name fits your needs.


Open a new session with the OMAdmin user. Click Setup and then Installation. Then click the New SQL Server stand-alone… and Show Details.


Validate that the status for all rules displays Passed. Click OK once it’s done.


Select Specify a free edition if you have an evaluation version or Enter the product key if you have a serial number. After entering your serial number (or picking the free edition), click Next.


Select I accept the Licence terms. Also, if you want to send usage data to Microsoft, you can click that box too. Click Next to get to the Server Setup Update screen. If you want to install updates, click the Include SQL Server Setup Update and click Next. The update will download and install. Once it’s done, click Show Details and validate that the status for all rules displays Passed.


Once you’re done with the update installation, continue to the Setup Role screen. Select SQL Server Feature Installation and continue.

This server will be used only by the Operations Manager Database (the short time database). The SQL Reporting Service will be installed on another server.

Select Database Engine Services and Full-Text and Semantic Extractions for Search (the latter is not mandatory). Change the path from C: to D: or any other disk.


Select Management Tools Basic and Management Tools – Complete. This will install all tools needed to manage the SQL Server. You can then continue to the next screen. Once again, check the Show Details to validate that the status for all rules displays Passed.


Select the Named Instance option and type OpsMgrOM. If you want, you can also install SQL without an instance. Once again, change the path from C: to D: and continue to the next screen. In the Disk Space Requirements screen, just click Next.


Select a domain user for both the SQL Service Agent and the SQL Server Database Engine. This user is a Domain User and doesn’t have any admin rights on the SQL Server. The Startup type must be Automatic. Then click on the Collation tab.


At this point, you can choose the default collation (SQL_Latin1_General_CP1_Cl_AS) or choose another supported collation. Click Next.

Note: The collation cannot be changed after the SQL installation. It is very important to select the collation that is supported.


Now, select Windows authentication mode. Click Add and select the OMAdmins group. Click Next. All user from this group will be a SQL SysAdmin.


Click Next on the Error Reporting screen and then Show Details. Once again, validate that the status for all rules displays Passed. Then, click Next.


Click Install to begin the SQL Server 2012 installation. Validate that the status for all rules displays Passed a final time and click Close. The installation is complete.


Validate that you can open SQL

We will now validate that you can open the SQL database. On MTLSQL01 server, make sure your session is open with a user member of the OMAdmin group. Press the Windows Key and select SQL Server Management Studio.

Select MTLSQL01\OPSMGROM and click Connect. This is your SQL instance that you define during installation. If you did not define any instance, just select the server name.


Expand the Server tree and then the Databases. Validate that the 4 databases are created and mounted.


Note: Install the last Service Pack and Cumulative Roll Up for SQL 2012.

Your SQL Server 2012 is now correctly installed. In my next article, we’ll be installing the SQL Reporting Services. Stay tuned!

The post Installing SQL Server 2012 appeared first on SherWeb.

May 162012

Cytanium - a newly launched discount shared hosting venture backed by OrcsWeb – has an extremely functional and usable control panel. One of the many features it has is the ability to leverage Microsoft’s Web Application Gallery (WAG) to automatically install dozens of different free applications. Just to show how easy is it, I grabbed some screenshots of me stepping through the process to install Orchard CMS on my Cytanium hosting account…

Cytanium's hosting control panel

The icon to enter the Web Application Gallery is located right in the main interface of the Cytanium hosting control panel. Once in the WAG part of the control panel, all of the available applications are listed alphabetically. You can change the drop-down list to narrow down the selection, or just scroll through the different pages to see all the options.

Cytanium's hosting control panel

Once I found Orchard CMS in the list, I can click on the name of the application or I can click Install right from the result list.

Cytanium's hosting control panel

The first screen before the download and install actually kicks-off just gives a short summary about the application chosen. Click next to begin the download.

Cytanium's hosting control panel

You’ll then get a dialog box showing that the application is being downloaded from the vendor to your hosted site on the server.

Cytanium's hosting control panel

After the download you are prompted for some basic installation parameters. (NOTE: Orchard CMS supports SQL CE but the WAG doesn’t yet, so installation through the WAG requires SQL Server 2008. To use SQL CE I’d recommend downloading to WebMatrix then using Web Deploy to publish up to the server. Not ideal because of the extra steps, but it is fairly easily and works great!)

Cytanium's hosting control panel

Wait a short few moments while it installs.

Cytanium's hosting control panel

And that’s it!

Cytanium's hosting control panel

You can now click on the link to launch Orchard CMS which has its own configuration wizard to finalize its setup.

Happy hosting!