Archive for the ‘SQL Server 2008 SP2’ Category

What can go Wrong during the SQL 11 upgrade ( Beta SQL 11 Denali )

Now that there is a beta of SQL 11 ( denali ) I want to see if I can break my Cluster with SQL 2008 on it during the upgrade. Yes I can.


These are testing machines ( snapshot of production ) and the screenshot are showing you what can go wrong. It was hard to make a blog post about this there was so much to fix and to do and to explane how to solve things.  At the end I deside to create a fresh cluster ;-(



I use a 2 node cluster windows 2008r2 with SQL 2008 on it 2 named sql instances.image

Lesson 1 be prepared and no rush during de upgrade.

Lesson 2 Make sure your current SQL cluster is fine if not do not upgrade !

In my post and I guessed it would be fun to do this with SQL Denali.

Well It is fun but the things I want to fix and to make sure the I can fix it and write a blog about this was not easy.

Well this blog is holding a lot of screen shots to see what and how the installation can be done.

So my 2 node cluster that I used for the SQL 2008 what can go wrong is up and running and ready for the beta sql 11.

I downloaded the SQL denali beta mounted the ISO in my hyper-V and started the splash.

But first let me test this on a brand new cluster and see how things are going.

Except I use the Same IP for the SQL instance ( typo on perpes )

clip_image002 clip_image004 clip_image006 clip_image008 

Ok I needed a reboot package after the reboot I’m ready to go


Fill in your key or leave it this way ( give your key later )

clip_image022 clip_image024

clip_image026 clip_image028

Give the file location and name the instance

clip_image030 clip_image032


clip_image036 clip_image038

I give the disk and the IP number ( make sure it is a free IP )

clip_image040 clip_image042 

Put in the service account

clip_image044 clip_image046

Some new screens

clip_image048 clip_image050

clip_image052  Well All set and ready to go But during the install there was this error, What is it and why ?

clip_image054  clip_image058

Well It seams that I used a Ip adress that was not Free but why this error and why not installing and leave the resource off line. So what is the status of the install.

Well there is no cluster good that this was not the production SQL so lets remove it an reinstall

clip_image056 clip_image062

clip_image064 clip_image066

Can’t find the SQL , yes the setup did not install it but why ?

clip_image068 clip_image070 clip_image072

clip_image074 But on more error messages to go there is no clean fix and this is just for not putting in a right Ip adress. next step clean out the register and delete the files, and rerun the setup again.



After playing with denali and upgrading , deinstall , install, fresh install , Win2008R2 Sp1

If you are beta testing denali on a cluster do not use the setup for cluster node install but choose the prepare for cluster install and after that use the finish cluster install. this works fine and fast.

Both my test clusters are broken during the upgrade It is all my fault I did this and not all the errors are SQL denali problems. but the main problem is make sure you have a plan and if something goes wrong make sure you can fixit or do a rollback.

In my case the only thing I did was a taken IP address and running an instance that is clustered and running a non clustered instance on both nodes.  seems not logical at all. But have you seen crappy sql clusters ? Or are all your Clusters in excellent shape ?

dumb questions do not exist, but have you ever worked on a helpdesk ?



Windows Live Tags: Wrong,Beta,Denali,Cluster,node,Lesson,Make,installation,Except,Same,instance,typo,Fill,Give,location,disk,account,Some,error,Free,resource,status,production,setup,messages,files,Both,problems,instances,seams,errors,blog,reboot
WordPress Tags: Wrong,Beta,Denali,Cluster,node,Lesson,Make,installation,Except,Same,instance,typo,Fill,Give,location,disk,account,Some,error,Free,resource,status,production,setup,messages,files,Both,problems,instances,seams,errors,blog,reboot

Powershell MSDTC cluster add in

Teched 2010 Berlin #TEE10 #Teched

For Demo and learning Sites you need often thing that takes only a minute but when you play with it it takes more time than you want.

So with this in my mind I created 3 powershell scripts that you can use for builing a cluster , NLB Cluster and a MSTDC cluster resource.

So If you want to create a MSDTC resource in your Cluster you can do this in the GUI or with a Powershell Script.

You can find the Scripts Here : Powershell Scripts

Powershell MSDTC cluster add in

First We load the powershell modules If it is a cluster you should do this on all the Cluster Nodes

Servermanagercmd -install Application-Server
Servermanagercmd -install AS-Dist-Transaction AS-Ent-Services –allSubFeatures

I Comment every line for what it does.

# Create a new HA Server Role – Distributed Transaction Coordinator
Add-ClusterServerRole -Name ServerDTC -Storage "Cluster Disk 6" -StaticAddress

Here we create the resource and chuck it to a disk and IP

# Add the MSDTC Service to the new Server Role
Get-ClusterGroup ServerDTC | Add-ClusterResource -Name MSDTC-ServerDTC -ResourceType "Distributed Transaction Coordinator"

Put in the MSDTC services.

# Create Dependencies for the DTC group
Add-ClusterResourceDependency MSDTC-ServerDTC ServerDTC
Add-ClusterResourceDependency MSDTC-ServerDTC "Cluster Disk 6"
# Start DTC group
Start-ClusterGroup ServerDTC


So Now that this is ready you can configure the MSDTC but remember the items that I mentioned in my previous blog.

Microsoft SQL Server 2008 SP2 Release Notes



What’s New in Service Pack 2

The following features are new in Service Pack 2 (SP2).

  • SQL Server Utility. After you apply SP2, an instance of the SQL Server 2008 Database Engine can be enrolled with a utility control point as a managed instance of SQL Server. For more information, see Overview of SQL Server Utility in SQL Server 2008 R2 Books Online.

  • Data-tier Application (DAC). Instances of the SQL Server 2008 Database Engine support all DAC operations after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.

  • Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for Reporting Services SharePoint integration. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in for SharePoint 2007 products. The new add-in supports the integration of SharePoint 2007 products with SQL Server 2008 R2 report servers.  For more information see the “What’s New in SharePoint Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What’s New (Reporting Services).

To download the SQL Server 2008 SP2 release please select from the links below:

WordPress Tags: Microsoft,Server,Release,Notes,Beta,Service,Pack,features,instance,Database,Engine,Overview,Online,Data,tier,Application,DACs,client,tools,Management,Studio,objects,unit,Services,SharePoint,Mode,integration,products,supports,links,LinkId,Feature,Instances,operations,servers,fwlink

    Posted September 30, 2010 by Robert Smit in SQL Server 2008 SP2

    Tagged with

  • Tag