Dario IT Solutions Blog

Only SQL 2008 SP1 is supported on Windows 2008 R2.

If you tried installing SQL 2008 from its DVD\ISO you surely got this error message:

In order to install SQL 2008 together with SP1, follow these Steps:

1. Install the prerequisites of SQL 2008:
   • .NET Framework 3.5 SP1 (from Server Manager –> Features –> .Net Framework 3.5.1 Features)
   • Windows Installer 4.5
2. Extract the service pack to a folder on the server using the following command:
   • SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SQL2008SP1
3. Run the service pack to install the Setup files
   • C:\SQL2008SP1\x64\setup\1033\sqlsupport.msi
4. Run the Setup.exe file from the SQL 2008 source media by specifying the /PCUSource parameter:
   • Setup.exe /PCUSource=C:\SQL2008SP1

Hi guys,

We held two open houses this week, one on February 22nd at MediaTech Haifa and the other on February 24th at Microsoft Raanana.

I would like to thank the large number of people who attended, it was great hearing your comments and questions.

Attached below are all the PowerPoint decks from the events:

For your reference, these are the major agent versions (as of December 24th, 2009):

1. DPM 2007 SP0 – 2.0.5820.0
2. DPM 2007 SP1 – 2.0.8793.0
3. DPM 2007 SP1 (with KB963102) – 2.0.8824.0
4. DPM 2007 SP1 (with KB968579) – 2.0.8836.0
5. DPM 2007 SP1 (with KB970867) – 2.0.8844.0
6. DPM 2007 SP1 (with KB970868) – 2.0.8851.0
7. DPM 2007 SP1 (with KB976542) – 2.0.8861.0

A bit of an Israeli pride..

Core Configurator 2.0 is now available to download from: http://coreconfig.codeplex.com/

If you are unfamiliar with this tool – it is a graphical tool that allows you to configure a whole bunch of system settings on a Windows Server Core installation:

Core Configuration tasks include:

• Product Licensing
• Networking Features
• DCPromo Tool
• ISCSI Settings
• Server Roles and Features
• User and Group Permissions
• Share Creation and Deletion
• Dynamic Firewall settings
• Display | Screensaver Settings
• Add & Remove Drivers
• Proxy settings
• Windows Updates (Including WSUS)
• Multipath I/O
• Hyper-V including virtual machine thumbnails
• JoinDomain and Computer rename
• Add/remove programs
• Services
• WinRM
• Complete logging of all commands executed

Cluster Shared Volumes (CSV) is a new feature that was introduced in Windows 2008 R2.

If you want to read more about it, how it works, and how you can enable it. There is a lot of material out there that you can refer to:

• Windows 2008 R2 NLB & Failover Clustering
• http://technet.microsoft.com/en-us/library/dd759255.aspx
• http://technet.microsoft.com/en-us/library/dd630633(WS.10).aspx
• http://blogs.msdn.com/clustering/archive/2009/03/02/9453288.aspx
• http://blogs.msdn.com/clustering/archive/2009/02/19/9433146.aspx

Well, after you’ve setup your cluster, enabled CSV, and added clustered disks to CSV, it is now time to copy your VHD files to those CSV disk. The big question is, which cluster node should you perform this operation on?

We’ll, to make a long story short – Copy it to the node that owns the CSV disk!

The reason this is important is that if you are running the copy on the coordinator node (the node which owns the CSV volume of interest), the writes are all local writes. If you are running the copy on any other node, the writes are actually redirected over the network (because they are extending writes to the file) and not done directly to the volume.

Hope this will save you some much needed time

Hi guys,

It was very nice meeting you all yesterday at the re-birth of the Infrastructure & Management User Group.

Below is the presentation for the main subject we talked about – “Windows 2008 R2 Overview”.

We will continue next month, on December 17th with the subject “Active Directory improvements in Windows 2008 R2”.

In the meantime, share your thoughts and interesting finds at the group site – http://www.linkedin.com/groupRegistration?gid=2389097

Have a great weekend and take care!

I know its a bit late, but here is the presentation I gave on November 3rd at the Microsoft convention – Let’s Talk Business-Tech that was held at Tel Aviv.

During the presentation, my co-presenter Ronen Gabay and myself talked about the new features of Failover Clustering in Windows 2008 R2.

We talked about Geo-Clusters, PowerShell 2.0 extensive support, Cluster Shared Volumes and mainly about how simple it is to create and manage complex cluster (everyone can do it! believe me! ).

We finished the presentation with a nice demo of RDS 7.0 media enhancement when we showed a 1080P HD movie (Terminators 2 Trailer) over RDP 7.0 while doing a Live Migration of the RDS Session Host virtual server that we RDPed into.. very nice!

What do you think, will we start seeing more clusters from now on? or something is still missing?

I’ll love to get your input.

Ever needed to get alerts on all services that are set to Automatic but not running?

Use the following SCOM monitor to do just that:

1. Create a Unit Monitor of type “Timed script two state monitor”, call it “Check For Not Running Services In Automatic Mode” or name it whatever you want

2. Check of “Monitor is enabled” (we will enable it to run only on specific servers later with overrides)

3. Monitor target – Agent

4. Put the following script:

Call Main ()

Sub Main()

‘ Monitor if automatic process is not running

Dim oAPI, oBag, wshShell
Set oAPI = CreateObject("MOM.ScriptAPI")

Set wshShell = WScript.CreateObject( "WScript.Shell" )
strComputer = wshShell.ExpandEnvironmentStrings( "%COMPUTERNAME%" )

‘strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

Set colListOfServices = objWMIService.ExecQuery _
("Select * from Win32_Service Where StartMode = ‘Auto’")

For Each objService in colListOfServices
Set oBag = oAPI.CreatePropertyBag()
If Not objService.Started = True Then
strDesc = "Service " & objService.Caption & " is not running on " & strComputer
Call oBag.AddValue("Description", strDesc)
Call oBag.AddValue("State", "BAD")
Else
Call oBag.AddValue("State", "GOOD")
End If

oAPI.Additem(oBag)

Next

oAPI.ReturnItems

End Sub

5. As Unhealthy expression put

Property[@Name='State'] Contains BAD

6. As Healthy expression put

Property[@Name='State'] Contains GOOD

7. Turn on Alerting

8. As Alert Description put

$Data/Context/Property[@Name='Description']$

9. Turn on Override for specified servers and change option Enabled to TRUE

Enjoy!

Microsoft has published some very nice eBooks free of charge! enjoy!

Introducing Windows Server 2008 R2

http://download.microsoft.com/download/5/C/0/5C0BD0AB-040D-4C56-A60B-661001012DDA/Windows_Server_2008_R2_e-book.pdf

Learn about the new features of Windows Server 2008 R2 in the areas of virtualization, management, the Web application platform, scalability and reliability, and interoperability with Windows 7. Download Introducing Windows Server 2008 R2, written by industry experts Charlie Russel and Craig Zacker along with the Windows Server team at Microsoft.

Microsoft Press / Oct. 2009 / Version 1.0 / 200 pages / 11.1 Mo / PDF

Deploying Windows 7 Essential Guidance from the Windows 7 Resource Kit and TechNet Magazine

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ee2a1d38-88a9-43b3-95bc-7e962f0b6030

Microsoft’s eBook Deploying Windows 7 Essential Guidance from the Windows 7 Resource Kit and TechNet Magazine combine selected chapters written by industry experts Mitch Tulloch, Tony Northrup, Jerry Honeycutt, Ed Wilson, and the Windows 7 Team with select Windows 7 articles from TechNet Magazine. Sample topics include: Deployment Platform, Planning Deployment, Testing Application Compatability, and 8 Common Issues in Windows 7 Migrations.

Microsoft Press – Microsoft TechNet / Oct. 2009 / Version 1.0 / 332 pages / 6.5 Mo / PDF

Understanding Microsoft Virtualization Solutions

http://csna01.libredigital.com/?urmvs17u33

This guide will teach you about the benefits of the latest virtualization technologies and how to plan, implement, and manage virtual infrastructure solutions. The technologies covered include: Windows Server 2008 Hyper-V, System Center Virtual Machine Manager 2008, Microsoft Application Virtualization 4.5, Microsoft Enterprise Desktop Virtualization, and Microsoft Virtual Desktop Infrastructure.

Microsoft Press / Oct. 2008 / 452 pages / 14.4 Mo / PDF

NB : This download requires a Windows Live account

7 Development Projects for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services Version 3.0

http://download.microsoft.com/download/0/2/f/02f0f661-88e1-43c2-b523-88d2e9e6802f/7%20Development%20Projects%20with%20the%202007%20Microsoft%20Office%20System%20and%20Windows%20SharePoint%20Services%202007.pdf

Get a hands-on introduction with seven practical projects. This guide highlights architectural underpinnings, the latest enhancements for developers, and code samples to get you started with building custom applications and solutions with Windows SharePoint Services products and technologies. (Note For developers)

Microsoft Press – Microsoft TechNet / May 2006 / 236 pages / 7.76 Mo / PDF

Hi all,

Microsoft recently announced that customers can now deploy Microsoft Windows Server and Red Hat Enterprise Linux and a range of select applications, virtualized on Red Hat and Microsoft virtualization products, knowing that the combined solutions will be supported by both companies.

Here are the details:

• Red Hat Enterprise Linux 5.2, 5.3, 5.4 have passed cert tests when running on Windows Server 2008 Hyper-V, Microsoft Hyper-V Server 2008, Windows Server 2008 R2 Hyper-V, Microsoft Hyper-V Server 2008 R2. See more at RedHat’s certified hardware site.
• Windows Server 2003/ Windows Server 2008 / Windows Server 2008 R2 are validated to run on Red Hat Enterprise Linux 5.4, using their KVM-based hypervisor. See more at Microsoft Server Virtualization Validation Program site.

Beyond the OS, both companies have select applications that would receive technical support when running on certified server virtualization software.

The Microsoft applications can be seen in KB article 957006. On the Red Hat side, you can now run JBoss Enterprise Middleware within a virtual machine guest on Hyper-V and receive coordinated technical support.

This is a step forward for enterprise customers, hosting providers, systems integrators, and those who want to offer their customers the top x86 operating systems to run applications.

Good news for everyone that uses both Microsoft & Red Hat products, I hope more collaboration news like that will continue to come out.