Avatar of alkin

by alkin

Powershell Deployment Toolkit failed missing port for sql server

November 28, 2013 at 8:28 pm in Uncategorized by alkin

During the validation of PDT I received the following errory saying that the port was missing for my new SQL instances:

clip_image002

To fix this just add Port="number" in the SQL instance section like shown below:

image

Thanks for Damian Flynn to point this out to me.

Hope this helps,

Alex

Avatar of alkin

by alkin

Setting SQL permissions with Powershell

November 19, 2013 at 12:08 am in SytemCenter by alkin

 

In the next couple of posts I’m going to blog about automating a System Center post-configuration deployment with Powershell. After you have deployed a typical SC environment you still need to do quite a lot of configuration. The following posts will cover how to automate this with Powershell.

 

The first powershell script is to define a specific user account as a sysadmin on a bunch of SQL servers:


<sub>#Variables
$Servers = @("srv01.contoso.com",”srv02.contoso.com”)</sub>

<sub>
#Connect remotely to the server</sub>

<sub>
Foreach($Server in $Servers)
{ </sub>

<sub>Invoke-Command -ComputerName $Server -ScriptBlock { </sub>

<sub>
#Set the system account as sysadmin</sub>

<sub>[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null </sub>

<sub># Create SMO Connections to both SQL Instances
$Svr = New-Object ('Microsoft.SqlServer.Management.Smo.Server') "$server"
$svrole = $svr.Roles | where {$_.Name -eq 'sysadmin'}
$svrole.AddMember("User account”)
}
}</sub>

Thanks,

Alex

Avatar of alkin

by alkin

Best of MMS 2013

May 1, 2013 at 12:18 pm in Uncategorized by alkin

Don’t miss the best System Center event in Belgium of the year! http://scug.be/events/

 

 

Seats are limited so hurry!

Alex

Avatar of alkin

by alkin

How to change SCOM reporting to use Kerberos instead of NTLM

April 30, 2013 at 12:06 pm in Uncategorized by alkin

One of the Domain admins at one of my customers was complaining about all the NTLM request generated by the scom server to the reporting server. One of the issues with NTLM is that you need to re-authenticate every time, with Kerberos you receive a ticket that is valid for a longer period of time (by default 10hours). You can find more info about NTLM VS Kerberos here: http://blogs.technet.com/b/authentication/archive/2006/04/07/ntlm-s-time-has-passed.aspx 

 

All the SQL servers at this customer are configured to use Kerberos but apparently when the SCOM reporting is being installed and modifying the RSReportServer config file it will change the authentication method as well back to NTLM!! Although Microsoft is recommending Kerberos over NTLM for almost 10 years now, new products like SCOM 2012 are still using NTLM!!

 

To change the report server authentication settings, edit the XML elements and values in the RSReportServer.config file.

You can find the file in the following location: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer

 

clip_image002

Change the setting from RSWindowsNTLM to RSWindowsNegotiate

clip_image004

 

Important note Important

Using RSWindowsNegotiate will result in a Kerberos authentication error if you configured the Report Server service to run under a domain user account and you did not register a Service Principal Name (SPN) for the account. Make sure to create the SPN for the SQL reporting service as described here: http://blogs.technet.com/b/stefan_stranger/archive/2012/07/31/opsmgr-2012-what-should-the-spn-s-look-like-visual-representation.aspx

 

Thanks,

Alex


Avatar of alkin

by alkin

Cloud Service pack failed: Current user is not a valid Orchestrator user

April 2, 2013 at 9:46 am in SytemCenter by alkin

Microsoft released beginning of March the updated Cloud Service Process pack that is now fully compatible with System Center 2012 SP1. You can download the new process pack here: http://www.microsoft.com/en-us/download/details.aspx?id=36497   CSPP is an extension pack built on top of System Center. This release is compatible only with System Center 2012 and 2012 SP1. This release does not contain a new feature set from prior releases.

When I tried to install CSPP I got the following error:

clip_image001

I opened the log files of the CSSP setup that are located at the following location:

C:\Users\alex\AppData\Local\SCCloudServices\LOGS\SCCloudServicesSetupWizard07

When I search through the log file I discovered the following error:

clip_image003

03:12:25:Checking if current user is valid Orchestrator user or not
03:12:27:System.Runtime.InteropServices.COMException (0x800708AC): The group name could not be found.

My account is a local admin and I could perfectly connect to Orchestator and create and launch runbooks so I was quite suprised to see this error.

So I looked locally in computer managed and you need two groups: the first one is the OrchestratorSystemGroup and the second one is the OrchestratorUserGroup which apparently didn’t exist on my orchestrator server! This means the Orchestator pre-requisites checker is checking for a group which doesn’t exist locally!

clip_image005

So I created manually a new group and added my account to the group

clip_image007

clip_image009

After that I closed and re-opened the setup wizard and everything went through without any issues!

Hope this helps,

Alex

Avatar of alkin

by alkin

Installing hyper-v inside a vm on Windows Server 2012

March 19, 2013 at 4:07 pm in Uncategorized by alkin

 

For a test setup I needed to install a Hyperv inside a vm running Windows server 2012. I did some googling and found the following post http://www.aidanfinn.com/?p=10175 from Aidan saying that its possible on Win 2008.

So I wanted to give it a try but it failed saying that a Hypervisor was already running

 

image

Apparently in Windows 2012 Microsoft wont let you install the Hyper-V role inside a VM. Bummer!

So I gave it another try using Powershell and hoping to bypass the validation check by using the following command: “Install-WindowsFeature –Name Hyper-V -ComputerName hyperv01-IncludeManagementTools –Restart” but it failed as well, with same error!

The only solution was to ping my good friend Mike Resseler who told me to try the following powershell command:

“DISM /Online /Enable-Feature /FeatureName:Microsoft-Hyper-V" which let me install Hyperv just fine!

image

and the following will enable the Hyperv Management console: “DISM /Online /Enable-Feature /FeatureName:Microsoft-Hyper-V-Management-Clients

Thanks,

Alex

Avatar of alkin

by alkin

SPF examples

February 21, 2013 at 10:49 pm in Uncategorized by alkin

Microsoft just released  samples to extend the service managemetn portal and service management API; http://www.microsoft.com/en-us/download/details.aspx?id=36787&WT.mc_id=rss_allproducts_cloudservice

This download contains documentation and samples for the following:

  • Applying a custom theme to the Tenant portal + a sample theming kit
  • Creating a custom Tenant portal
  • Creating a custom Resource Provider + a sample Resource Provider that works with GoDaddy
  • Extending the Usage Endpoint + a sample billing adapter that works with Zuora

Alex

Avatar of alkin

by alkin

Extended network device monitoring list updated

February 16, 2013 at 12:45 pm in Uncategorized by alkin

Microsoft just released and updated list of devices that can be monitored by Operations Manager 2012. OpsMgrr 2012 can monitor network devices that support SNMP, and can provide port monitoring for devices that implement interface MIB (RFC 2863) and MIB-II (RFC 1213) standards. You can find more info about those RFC here http://en.wikipedia.org/wiki/Management_information_base .

 

Thanks,

Alexandre

Avatar of alkin

by alkin

Join the next IT Camps on Windows 8 and Windows Azure!

February 15, 2013 at 11:24 am in Azure, it camps, Technet, Windows 8 by alkin

 

IT Camps

Microsoft IT Camps are free, hands-on technical trainings for IT professionals led by Microsoft experts. Don’t miss the opportunity to elevate your skills by learning more about Windows 8 and Windows Azure through our free IT Camps!
Register now for a Windows 8 IT Camp on

· February 25th in the morning or afternoon or evening in Kortrijk

· February 28th in the morning or afternoon or evening in Genk

Or dive deep into Windows Azure on

· February 26th in the morning or afternoon in Genk

· February 27th in the morning or afternoon in Kortrijk

· February 28th in the afternoon in Mons

Get started

Avatar of alkin

by alkin

Building a Sharepoint Change Calendar with Orchestrator and Service Manager

November 8, 2012 at 10:48 am in Sharepoint by alkin

A few weeks ago one of my customers was asking if it’s possible to have a change calendar on the Service Manager portal. Out of the box this is not provided so I asked my good friend Anders how this could be solved. A few days later he already had a nice solution that you can find here: http://contoso.se/blog/?p=3350&utm_source=rss&utm_medium=rss&utm_campaign=building-a-change-calendar-with-orchestrator-and-service-manager So thank you Anders :-)

This solution is a perfect viable solution and it works like a charm. So you will be able to create a new change request and see it in your outlook calendar . But when I wanted to start integrating the exchange calendar into SharePoint I encountered some SharePoint limitations.  I couldn’t find an easy and straight forward way to insert the shared exchange calendar into SharePoint.

During my search to integrate my exchange calendar into SharePoint I discovered that you could create SharePoint lists and change the list to a calendar view! So this could be interesting! you can find more info about creating lists and calendar view here: http://sharepoint.microsoft.com/Blogs/GetThePoint/Lists/Posts/Post.aspx?ID=483 . Follow the procedure to create a new SharePoint list and change the view type to a calendar view . Remember the name you will give to your new list as you will need it later on.

Next step is to download the SharePoint IP and use it to create a new SharePoint list item based on a change request.

Configure the SharePoint Ip:

Note that you need to specify “SharePoint Configuration” and need to provide the name of your list you just created.

image

The runbook monitor Service Manager for new change request, when there is one, the runbook triggers and will create a new list item on Sharepoint

image

image

image

When I create a new change request, Orchestrator will automatically be triggered and put the change request details on the SharePoint List that we have incorporated into our SCSM portal

image

Hope this helps,

Alex

Visit Us On TwitterVisit Us On Linkedin