System Center Operations Manager 2016 Step by Step–Part 3

Hi again

after some work problems I get back to new SCOM 2016 installation. I mentioned last time that we will today install SQL server. There were some questions about which version to use. I wanted to install SQL 2016 SP1 but I get notice it is not yet supported (see comments on this post by Kevin Holman.  You can get the list of last supported databases with SCOM 2016 UR1 on this TechNet link

image

You can use version you choose, because if you remember SQL license is free for System Center products. With only one rule, just use it for System Center products databases and nothing else.

Did you create SQL service account. If you didn’t, do it now. I created only two. One for SQL service account and one for SQL Reporting services account. So lets start. Choose new SQL server installation

image

After entering product key, accept license terms of use. I skipped Microsoft updates because I don’t want to end up with SP1 I don’t need for this SCOM installation. 

image

If everything is green you are good even windows firewall scream for attention here. You choose next features needed for SCOM SQL installation

 image

Choose default instance if you don’t need better that that

image

Enter you domain service accounts for SQL services and give services automatic startup. Also check Volume Maintenance Task privilege to use this new SQL feature

image

You need to use this SQL collation. In any case it is by default in SQL installation sou you will not miss it

image

Specify Windows authentication mode (do not use Mixed mode)

image

You setup your database and log files as you can, but rule of the thumb is to format those drives with 64K allocation unit sizes, and if you have possibility put your tempdb database and log on SSD drive. It is best to leave that volumes only for databases.

image

On Reporting Services page choose Install and Configure

image

Click next on Feature Configuration Page if everything is green  and then Install on Ready to Install page.

After everything is done, we are free to go further. Until next time

image

SQL Server Broker for the Operations Manager database is disabled

I was moving Operations Manager database today, but after everything went smooth, I get this error  “SQL Server Broker for the Operations Manager database is disabled” How  to fix it?

First of all stop all SCOM services in this order

  1. System Center Management Configuration
  2. Microsoft Monitoring Agent
  3. System Center Data Access Service

After that Open SQL Management Studio and do this SQL queries (run one by one)

ALTER DATABASE OperationsManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE
 ALTER DATABASE OperationsManager SET ENABLE_BROKER
 ALTER DATABASE OperationsManager SET MULTI_USER

SELECT is_broker_enabled FROM sys.databases WHERE name='OperationsManager'

If everything is successful last query will give you result 1, so it means that SQL broker service is enabled.

Start Services in opposite order then stopping. Have a nice weekend

System Center Operations Manager 2016 Step by Step– Part II

I promised last time I will give my example of SCOM environment (experience based)  so you can compare it with your requirements, to see if that may work for you. Right know lets start with number of current SCOM agents on my SCOM server. I recently deleted some because we changed Exchange environment and some other things. To get exact number of agent installed around we will use PowerShell and simply do next

image

As you can see I have 35 agents installed. If you are unfamiliar with the term, it is every computer that have SCOM agent installed (MMA – Microsoft Monitoring Agent).  It is not some representative number. Still I think it is more common then people think. But still there is much more hidden workload that is not accounted in this number.

You will probably want to monitor some network devices too. Or maybe even storage or some other SNMP enabled devices. Lets count them with PowerShell. As you can see there is some IP addresses there. They are some optical switches, tape library, storage etc.

image

That is not all but lets stop there. Where is it running now? You will be surprised!  All of this is running on just one physical HP DL380 G5 server fully populated with disks and 32 GB of RAM with SCOM environment installed including databases (I mean DWH&ACS database too). But please don’t go there. This server was installed in time of SCOM 2007 R2 version when that was enough for that workload. I needed to tweak a lot of things to get it running on current SCOM 2012 R2 version. It survived couple of SCOM upgrades in between . Console was slower but it worked. I am now more clever and I will do fresh start. So what configuration can easily chew this environment. I found some servers in our warehouse with next configuration.

image

It doesn’t seems some round numbers but people from supply have some strange configurations in their heads Smile

What is important here. First of all, please separate SQL workload from management server. Two reasons.

  1. SQL workload can be very hard on performance and will stand in the way of normal SCOM functioning. It will take RAM, processors, everything it needs to work.
  2. SQL Server license is free for System Center use only. So please don’t put it on some big SQL server where you have a ton of other databases. In my case I will put also SCCM database here because it is small enough. If you need SQL workload for some other System Center product consider more RAM memory and enough space to accommodate database sizes

I don’t have anything against virtual servers. Management server can be virtualized in this configuration without to much fuss. SQL virtualization? Maybe, but that is you decision to make. So what we need for next time.

We will start with SQL installation. Because I want to run SCCM database here too, I need to consider what SQL version are compatible for both System Center products. As I understood somewhere Configuration Manager is going on its own path besides System Center product. I still didn’t chew on that one, but it was always separate product for me. From times of SMS 2003. 

image

If you look at the SQL compatibility for ConfigMgr 2016 (I need to stop using SCCM) you will see that SQL 2016 SP1 is supported. I will try to install SP1 version and see if that goes. I didn’t found any documentation is SP1 supported for SCOM but I will look for it.

Until next time

How to license WORKGROUP server in DOMAIN !

You probably had task to license some server or client PC that is not domain member and besides that it is not using your domain DNS server. As you already know, KMS server is usually installed on domain joined server. So what to do? First open hosts file (%windir%\system32\drivers\etc) on computer you want to license, and add host record for your KMS server (vmo-aaa in my case).

image

After that you need to run two command. You need to know on which port your KMS service is working. Default port is 1688. With first command you tell client which server and port to use for licensing, and in second you activate your license. That is all you need to activate your Windows license.

Slmgr /slms vmo-aaa:1688
Slmgr -ato

System Center Operations Manager 2016 Step by Step– Part I

As you know SCOM 2016 is published last year. Like many others I also have a task to upgrade my SCOM environment to new version. That’s why I get idea to document my path and maybe help other on all problems that can occur. Probably there is some people that are installing this product  for the first time. I will not write to much about theory of how SCOM works but focus mainly on all steps required to have functional and working SCOM environment. Especially I will take some time to explain configuration of some different management packs both Microsoft, vendor and community published.

So lets start. For all of you newbies, I will recommend first some reading you can do besides this blog. There is not so much books about SCOM 2016 but there is no much change when you compare it to 2012 R2 version. You can use 2012 R2 books and articles if you have it already. This is the list of latest books, new and old links you can use:

There is more, but lets stop here. It is more then enough to start with. So what is the first step. PLANNING!

To have functional SCOM environment you need to carefully plan your workloads. How to size your environment? You can do it by experience from your previous deployments, but if you are new then you use System Center 2012 Operations Manager Sizing Helper Tool Excel sheet. It is made for SCOM 2012 version, but it is usable for SCOM 2016. Only thing I saw is wrong in excel sheet is number of Linux/Unix computers you can manage with one management server. If I am not wrong number is doubled in SCOM 2016 so take that in account.

image

I will not walk you on Excel sheet. You will need to go for yourself to discover your needs. Please be extra careful with designing database server. It is crucial in SCOM design. If you have some good SQL admin ask his advise. If you don’t know how to calculate IOPS requirements you can test them on you server. For that best thing to use lately (besides IOmeter) is using DiskSpeed Powershell script together with  Diskspd Utility: A Robust Storage Testing Tool (superseding SQLIO). Be careful to put script into right folder with diskspd.exe file to get it running. When you succeed you get something like this. 

image

I need to run to other task that are waiting for me, but we will see each other very soon. Go thru this subjects and next time I will show you my imagined future configuration on almost purely experience basis. 

See you

How to remove OMS from SCOM

I am sometimes so annoyed that once you connect your SCOM to OMS it is hard to get rid of it. You even delete workspace, but only thing you get is some errors in SCOM console. Ok how to get it out if you temporary doesn’t want it there?

I started with Kevin Holman post about it but I had some trouble doing it so here is full  story. Lets first copy paste some things.

First of all we need to stop download of intelligence  management packs from OMS and all others related. To do that,  create override with name “override OMS temporary disable” , and disable two rules. Go to Authoring > Rules, and set your scope only to “Operations Manager Management Group”

Disable the following two rules:

image

It will disable automatic download of OMS MPs.

Now lets delete some MP

Open PowerShell and do next commands

Get-SCOMManagementPack -name “*advisor*” | Remove-SCOMManagementPack

Get-SCOMManagementPack -name “*IntelligencePack*” | Remove-SCOMManagementPack

get-SCOMManagementPack -name “Microsoft.EnterpriseManagement.Mom.Modules.AggregationModuleLibrary” | Remove-SCOMManagementPack

First command will probably fail. you will delete only one management pack but rest of it will not be possible because of dependency. This two you will have problems with

image

They have dependency on this management pack and you can not delete them. So what to do?

image

If you added run as account for System Center Advisor Run As Profile Proxy, and probably you did,  remove it from there. After that we need to edit this management pack. Go to PowerShell again and do this (don’t run it read first).

$MP = Get-SCOMManagementpack -Name Microsoft.SystemCenter.SecureReferenceOverride
$MP.References
$MP.References.Remove(“SystemCenter6“)
$MP.References.Remove(“SystemCenter5“)
$MP.Verify()
$MP.AcceptChanges()

To explain.

  1. With $MP.References you will show all reference inside this MP including Advisor ones.image
  2. After that you will remove references using right Key names listed for Advisor MPs
  3. With MP.Verify() you check everything to ensure there are no orphaned overrides, etc.
  4. If everything is OK do $MP.AcceptChanges() to save everything

After that you can easily delete first override mp “override oms temporary disable”  and both  left over Advisor MPs.

image

If I missed some step please comment

Install VMWare tools on OpenSUSE 11.2

 

To install VMWare tools folow next steps :

  1. Launch YaST > Software >  Software Management
  2. Remove open-vm-tools, libvmtools,vmware-guest-kpm-desktop,open-vm-toolsgui

imageimageimage

  1. Change Filter to Patterns, and make sure c++ compiler is installed (gcc) , make, kernel-desktop-devel . In my case it was not so install itimage
  2. Close YaST
  3. Right-click the VMWare guest in the VMWare client, and click Install VMWare tools
  4. Open Terminal
  5. Type mount /dev/cdrom /media
  6. Type cp /media/*.tar.gz /tmp
  7. Type cd /tmp
  8. Type tar -zxvf VM*.tar.gz
  9. Type /tmp/vmware-tools-distrib/vmware-install.pl and follow default values or not,  or just type –default after commandimage
  10. Type init 6 to restart the server

  11. Type /etc/init.d/vmware-tools status to make sure it is runningimageimage

ENJOY  – regards to everybody

The trust relations between this workstation and the primary domain failed

 

image

Ok you get this error. How to repair it correctly. I get it today and like always I know that I need to reset computer account password. Usually people rejoin computer to domain. but here is simpler solutions, or at least similar when it comes to time consumption.

First of all you need to log in. If you don’t know local admin password disconnect network card and login with your domain password that is cached in computer. After you log in connect network card again.

Now open Powershell and test you secure channel and if it gives you false repair it. Use Get-Credential only if you don’t have enough rights for changing computer object.

Test-ComputerSecureChannel -Verbose
Test-ComputerSecureChannel -Repair -Credential (Get-Credential) -Verbose

image

Reinstall GUI after uninstalltion on .NET on Windows Server 2012 R2

When some developer try to install Sharepoint he will certainly make a mess. One deinstalled .NET in my company, and I really didn’t know that after you uninstall it from Windows Server you can get this after restart. NO GUI

image

How to get it back. Let do step by step

DISM.exe /online /enable-feature /all /featurename:NetFx4
DISM.exe /online /enable-feature /all /featurename:MicrosoftWindowsPowerShell
shutdown /r


image

After that open powershell on command prompt and install gui

Install-WindowsFeature Server-Gui-Shell, Server-Gui-Mgmt-Infra

image

Windays16 – epilogue

Hi everybody

Usually around end of April Microsoft Croatia organize IT WinDays conference. It is one of the biggest IT conferences in this region, approximately 1700 participants . Last time I was there in 2006.  I was participant and very young in terms of experience and IT knowledge. For me, it was world of knowledge offered, and I needed to choose wisely. It seems I did. After 10 years I am here as speaker and sharing my thoughts and knowledge with others. Same conference – different perspective. This years conference is for the first time in Valamar Isabella Island Resortu –Poreč.

Windays Island

How I / to  become speaker on Windays?

My carrier as speaker started on community session. In 2010 me and MVP colegue Denis Mihić  founded Hercegovina MSCommunity. It was basic when I look at it now, but very educational. It still is. I had very good practice on community session, and  I was pronounced that year best community speaker at first Bosnia and Herzegovina Microsoft conference MSNetwork. I also get to know a lot of people from Microsoft and other ecosystems during last years,  and I was trying to present my work as best I could on different conferences. Sometimes it was better, and sometimes it was worse. Like in marriage ( if you you are married), but one thing need to be clear. You need to love her, or in this case love it. When I am writing this I have in my mind Nenad Trajkovski who is always passionate about his wife like he is about speaker engagement on every conference. Reason why I am writing all this is one panel talk  I attended. The name of it was just just this headline above “How do you become Windays speaker ?”. It is very interesting that I repeat this panel in  my memory more then for example any other technical lecture, and I really love technical stuff . Why? One of the reasons is that I get my speaker results just before, and they were average.

WP_20160428_11_30_40_Rich

I knew I was not bad, but it should be excellent! This is premium conference for me, and I am average?! Lets repeat some of my thoughts  during that panel talk. Even though they are not true every time. Because in that case I will never be speaker here.

“”How the hell I end up as speaker here. If I am listening carefully these people here, I almost do all things wrong. I always doesn’t finish presentations (at least I think so), I always have urge to say more, I don’t stick to timetables inside my time (at least I respect other timetables) and generally I don’t have Superman speaker skills to present anything without good preparation. It seems that afterwards I don’t respect people that come to lecture, as they mentioned.

After listening to panel of Windays  content owners and their problems with choosing presentations, and what drives them in choosing it, I analyzed myself and get to REVELATION. After so many years I realized that knowledge I share doesn’t need PowerPoint slides. Up to now I always put slides to get people with less knowledge some basic information about topics, and afterward there is real thing. DEMO! When this starts I am where I need to be. I can then speak for hours. On Windays I had presentation slot for 30 minutes for lecture about Microsoft OMS. In depth lecture about Log Analytics search and automation capabilities. In such a short time I had to speak about some very interesting things, but sad for me, I spent 10-15 minutes on pre DEMO talk. I stolen some time at the end because there was Technical Keynote afterward but even that didn’t help. Result was not so excellent speaker result, and feeling of guilt that I could do more. Sorry people, I will try to be better next time. Something people always say when they got out from confession in church, but they come back again as sinners week later. I will try.  Promise.  And don’t repeat my mistake. If you speak DEMO do DEMO only. Forget slides!

WP_20160428_10_59_05_Rich

After all,  I was still joyful to learn something more about myself and what is needed to be better speaker. Before 10 years I was learning about technical stuff, and today I am learning about presenting knowledge on conference. This is a life experience and value everybody should be getting on these events every time, and remember it for later.

Even I was little disappointed with my performance as speaker there was time for conference party. It was awesome. I met some new people, drink some beer with old and new ones.  In general had a good time.

At the end what to say : “Thank you Windays!” . Value of this conference is always diamond for me it seems. You get to know some excellent people, and also get to know where you are standing and how much you matter in IT world today. I hope I will have more experience like this on future conferences, but Windays will stay in good memories by me.

I hope I see you all again (new and old friends) on WinDays island next year

20160428_192148