How to: Change the Network Binding order for SQL 2012 Windows Server 8 Failover Cluster (Setup)

During the SQL 2012 Setup there is a warning that my binding order is not correct. It looks ok but it is not. there are a couple of KB items on technet. this is on Windows 8 server

 

Why this is appearing did I make a mistake ?  lets see mm my lan nic is on top. this looks ok so why this error. lets look at the SQL log

 

Ok here it is the SQL setup log file is it wrong ? local area connection* 11 is on top ? what is this ? lets lookit up .

 

NetworkBindingFacet: Looking up network binding order.

(05) 2012-03-18 14:03:04 Slp: NetworkBindingFacet: Network: ‘Local Area Connection* 11’ Device: ‘\Device\{2E9E3899-BB35-4E91-98D4-BF56F4ADE4F6}’ Domain: ” Adapter Id: ‘{2E9E3899-BB35-4E91-98D4-BF56F4ADE4F6}’

(05) 2012-03-18 14:03:04 Slp: NetworkBindingFacet: Network: ‘LAN’ Device: ‘\Device\{734667C2-FCC9-4874-B3E0-EDC3BA72F6AB}’ Domain: ‘mvp.local’ Adapter Id: ‘{734667C2-FCC9-4874-B3E0-EDC3BA72F6AB}’

(05) 2012-03-18 14:03:04 Slp: NetworkBindingFacet: Network: ‘ISCSI’ Device: ‘\Device\{1F016AE2-DD00-4B0F-B80B-57173AF2F36E}’ Domain: ” Adapter Id: ‘{1F016AE2-DD00-4B0F-B80B-57173AF2F36E}’

(05) 2012-03-18 14:03:04 Slp: NetworkBindingFacet: Network: ‘Cluster’ Device: ‘\Device\{BA1F99C0-0D58-44AA-85E0-ADFB1EF2C422}’ Domain: ” Adapter Id: ‘{BA1F99C0-0D58-44AA-85E0-ADFB1EF2C422}’

I know what it is it is the hidden cluster adapter which needed to be moved in the binding order, and that had to be done in the registry.

I opened up regedit and drilled down to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Linkage and opened up the Bind value:

 

 

\Device\{2E9E3899-BB35-4E91-98D4-BF56F4ADE4F6}

\Device\{734667C2-FCC9-4874-B3E0-EDC3BA72F6AB}

Flip the registry keys and you are ready to go.

This is hard to find eh yes but you can use powershell 

wmic nicconfig get Description,SettingID

More info about this is on MSDN

http://msdn.microsoft.com/en-us/library/ms189910(v=sql.110).aspx

changing-the-network-binding-order-in-windows-server-2008

and it you want to change this by powershell the get-itemproperty is the way.

Get-ItemProperty Registry::HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Linkage\bind\*

After the NIC binding order change the SQL setup marked all as passed.

Samples :

 

Get-Item -Path Registry::HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Linkage\bind\* | Select-Object -ExpandProperty Property

Get-WmiObject -Class Win32_NetworkAdapterConfiguration -Filter "IPenabled = $true" | select Description, IPAddress, index, SettingID

gwmi Win32_NetworkAdapterConfiguration | where-object {$_.IPEnabled -eq "True"} | ft Description, SettingID -auto

How to: Create a New SQL 2012 Server Failover Cluster (Setup) multiple instances on windows server 2012 #ws2012

Now that windows 2012 is in beta we can talk almost about anything and it is time to create my demo SQL 2012 machine. In this case I uses the Windows server 8 cluster from the other blog item to create a SQL 2012 cluster with 3 instances. All of the instances are created on different ways , Instance 3 is a ZTI   #WS2012 #TEE #TEE13 #MVP13

For starters build a 2 node cluster or more nodes if you want and use the SQL 2012 Media. I use the Enterprise version.

Remember that I create the Server Group and my cluster I already added the disk to my cluster mounted the SQL 2012 ISO file to the node. Ready for the Setup.

again I use a lot of pictures in this blog and I do almost everything twice just to show you how you can configure your cluster.

the disk listing in the cluster. eh no we do not use the basic setup. Installation should be fun and not follow the wizard ok we have to use the wizard in this part. We use the advanced cluster preparation setup this will setup your SQL cluster in two parts.

 

 

 

Fill in your SQL product key or use a evaluation , accept the agreement.

  

Mm a warning it looks OK yes it is I create a new blog post on this ignore it for now.

 

Yes I corrected the binding order and we continue the setup.

 

I choose to install all the options This cluster will be used for the System center products.

 

 

I use a basic account but for more security you should use different accounts. And I will also configure my report server by hand later.

 

 

Now that the first step is ready we can do the second step but first I want to create a second instance preparation. as a basic I use the setup .ini file that you can save during the setup.

The second instance I use this ini file to create the instance preparation. Open the ini file and I changed the SQL01 in SQL02. easy

in the setup screen I use the install based on a Ini file setup. this is not an unattended setup. But all the screens are already filled in.  So this is like a practice unattended setup like in SQL03  

… import ini file As you can see the installation of a second instance is the same as installing one instance on a node or installing a third instance but you can install less or more options in the instances. they don’t have to be the same.

 

 

 

 

 

Easy just press next and finish almost unattended. You can also use the ini file of this installation if you want to rebuild this instance during a disaster.

Advanced Cluster Completion

Now that the Instance SQL01 and SQL02 are installed but not jet completed in my cluster we need to do the next step Cluster completion. This step we need to do this also twice , and yes one time I do this in the GUI and save the INI file and One I use the Ini file for the SQL02 setup just to see how it can be done.

 

Here we create the Cluster name and the SQL instance As you can see. And You see also the SQL02 instance. but remember you can only do one instance installation at the time

 

 

We choose the Disks and the IP address for this SQL cluster instance.

I use here only two disks but you can use more disk, DB ,Logs, and Temp DB and Analysis all on different disks. if you want more performance. this is if it runs on multiple SAN disks.

for System center the Collation is most important If you choose the wrong one you are in trouble it is hard to reconfigure this.

If you continue Setup using the default collation (SQL_Latin1_General_CP1_CI_AS), you will not be able to support multiple languages in Service Manager. In the future, if you decide you want to support multiple languages, you will have to re-install SQL Server.

Service Manager doesn’t like the default collation method (SQL_Latin1_General_CP1_CI_AS). If your SCSM SQL server is running with that collation mode you will get a warning when you install SCSM.

Further down in the error the Exhange 2010 MP was referenced with regards to “Microsoft.Exchange.2010.Reports.Dataset.Ten

After doing some investigation discovered that nager is only supported with a collation of “SQL_Latin1_General_CP1_CI_AS” hange 2010 management pack relies on the collation being “SQL_Latin1_General_CP1_CI_AS” to place certain data into the Data Warehouse.

Here is the bad news!!! The only way to resolve is it re-install SQL. So make sure if you are installing Operatons Manager your SQL collation is correct.

This error message is because we installed SQL Server in the default SQL_Latin1_General_CP1_CI_AS collation. This collation is the only one that is supported by SCOM2012 and so this is necessary when we want to install SCOM2012 and want to connect SCSM with SCOM2012.

When installing SCSM 2012 it’s important to use a supported language.

If you use the default collation: SQL_Latin1_General_CP1_CI_AS

multilanguage support will not be available in Service Manager.

Instead you should use a supported collation like eg.: Latin1_General_100_CI_AS

 

More info about this you can find here :

http://technet.microsoft.com/en-us/library/hh495583.aspx

 

If you use system accounts you don’t want to add the domain administrator but in my demo It is ok

 

 

Ready. the one thing that I did not install is a DTC because it is so easy to install on a cluster we do this in just a few steps.  go to the failover cluster manager and add a cluster role

 

 

pick the msdtc and give the role a IP and I always use a own disk for the DTC but you can share this if you want. my advice use a own disk for a more flexible cluster

 

 

as you can see my cluster is ready to use

the second cluster completion I do this with a INI file all the steps are the same as without the ini file only the items are filled in.

..import ini file

 

 

I skiped the other screens

 

Done Now I have two SQL instances and 2 sets of ini files. these file I’m gonna use it for an unattended setup. SQL installation in just 10 minutes

the first step SQL cluster preperation

setup.exe /Q /CONFIGURATIONFILE=”C:\SQLSetup\ConfigurationFile.ini”

/SQLSVCPASSWORD=”<StrongPassword>” /IACCEPTSQLSERVERLICENSETERMS/INDICATEPROGRESS

because I use a account for my SQL server I need to fill in my password.

 

 

 

  this will kick in the cluster completion.

For this unattended setup I created the following file I use the following account for all the services : sql2012 and the password is also sql2012 Remember this is a lap use strong passwords in real life !!!

Step one is the Cluster preperation

d:\setup.exe /q /CONFIGURATIONFILE=”C:\SQLSetup\SQL03-1.ini”

/AGTSVCPASSWORD=”sql2012″

/ASSVCPASSWORD=”sql2012″

/SQLSVCPASSWORD=”sql2012″

/ISSVCPASSWORD=”sql2012″

/RSSVCPASSWORD=”sql2012″ /IACCEPTSQLSERVERLICENSETERMS /INDICATEPROGRESS

Step Two is the Cluster Completion

d:\setup.exe /q /CONFIGURATIONFILE=”C:\SQLSetup\SQL03-2.ini”

/AGTSVCPASSWORD=”sql2012″

/ASSVCPASSWORD=”sql2012″

/SQLSVCPASSWORD=”sql2012″

/ISSVCPASSWORD=”sql2012″

/RSSVCPASSWORD=”sql2012″ /IACCEPTSQLSERVERLICENSETERMS /INDICATEPROGRESS

 

 

You can do this also in one ini file but if something fails you don’t have to do it all again.

Happy clustering !!

How To Create a Windows Server 8 Cluster Windows Server 2012 Cluster

The way We build a cluster in windows 2008R2 is almost the same in windows 8

In windows 8 You can do more with PowerShell. In this blog post I will create a cluster old style first. Then PowerShell one-liner

 

My first node and the windows server 8 cluster group. just create a cluster group for easy handling the servers.

And as you can see the selected server is on the right top of your screen.

Now in this gui we add the Failover cluster Role and the tools. I did select the server and proceed with the wizard.

Just follow the wizard and add the Feature.

Now there is a new thing you don’t have to wait till the install is done. close the window and if you want to see the progress you can. by opening the installation progress task.

 

Now I added the Failover cluster feature almost 4 windows  

The PowerShell way : Trouble with the Commands ? just use the *

Go to the powershell <> it is already in admin mode <>

Get-WindowsFeature *

you will see a list of all Features. I will use only the Failover-clustering

Get-WindowsFeature Failover-Clustering

The installation kicks in and does the installation with out any questions.

  

This will save time or when you do a unattended OSD. As you can see in the PowerShell I opened a PoSH to the other node just right click on the node.

But sure you can use the GUI.

But what about the Creation of a cluster. ? Gui or PoSH Well first the PowerShell line.

New-Cluster -Name "My-first-Cluster" -Node mvpwin8-n1 -NoStorage -StaticAddress "11.222.222.33"

Cluster name is :My-first-Cluster

Nodes in my cluster is 1 <> and yes you can create a one node cluster.

I did not add any storage to the cluster.

And I used a static IP : 11.222.222.33

Or Gui <> This time I add both nodes, open the FCM and select create new Cluster and add both nodes.

   

Run the validation reports. And the validation reports are also contains new items

 

Give the Cluster a name and an IP and my cluster is ready.

 

Now that my basic cluster is ready We add some disks to the cluster.

The PowerShell Way :

This shows a list of all available disks

Get-ClusterAvailableDisk -Cluster Clustername

the add-cluster disks adds the disks to the cluster

Get-ClusterAvailableDisk -Cluster Clustername |Add-ClusterDisk

 

or in the FCM right click on storage

 

Now that we have disk in our cluster we can add witness disk to the cluster.

under more actions we can select the Quorum settings

Disk and node majority is the choice for a two node cluster on a three node you don’t need the disk. the Third node is the Vote.

 

Choose a disk for the Quorum, and as you can see I do have a drive letter but if you want more security. Skip the Drive letter you do not need it.

 

Next Step add Roles to the cluster.

Create Windows Server 8 Server Groups

In windows server 8 you can create server groups this is handy for management , deployment and all other things you want to do with the servers.

How does is work. First go to the dashboard :

and choose option 4 Create server group.

 

  

Give the group a name this name will show up in the left of your dashboard

Add the servers that are part of this group, select and add.

 

Now that we have a server group we can deploy roles to this server with out going to this server.

just click and install Windows 8 Rocks

 

from here install a server role or feature.

More in the following blog posts.

Windows Server 8 Beta Hyper-V Component Architecture Poster

The link for this poster is: http://www.microsoft.com/download/en/details.aspx?id=29189

 

Provides a visual reference for understanding key Hyper-V technologies in Windows Server 8  Beta and focuses on Hyper-V Replica, networking, virtual machine mobility (live migration), storage, failover clustering, and scalability.

Here are links to previous posters:

1. Windows Server 2008 Hyper-v Component Architecture with Service Pack 1
http://www.microsoft.com/download/en/details.aspx?id=2688

2. Hyper-v Component Architecture
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3501

3. Windows Server 2008 R2 component posters
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7002

4. Windows Server 2008 Component Posters
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17881

Technorati Tags: Windows,Server,Beta,Hyper,Component,Architecture,Poster,details,Provides,Replica,machine,Here,posters,Service,Pack,microsoft,download,aspx,displaylang
Windows Live Tags: Windows,Server,Beta,Hyper,Component,Architecture,Poster,details,Provides,Replica,machine,Here,posters,Service,Pack,microsoft,download,aspx,displaylang
WordPress Tags: Windows,Server,Beta,Hyper,Component,Architecture,Poster,details,Provides,Replica,machine,Here,posters,Service,Pack,microsoft,download,aspx,displaylang

Clustering DHCP Windows Server 8

On the BUILD conference highlights Microsoft showed new features of windows server 8. one of the new things was clustering DHCP. Now in windows 8 the DHCP clustering is easy to setup and to manage.

When you have your cluster just add the Role and select DHCP server. Just for the Demo I turned off the second node. Just make sure that you have installed the Windows Role DHCP on both nodes. this is not the cluster Role.

We choose a netbios name and a IP that will be used for the Clustered DHCP server.

And We select some storage that hold the DHCP files ( DB )

And as I said the Second node is turned off just for the demo to show you the warning the wizard shows you. it is in yellow and says there is only one node.

The Cluster Overview As you can see the DHCP resource is running on node 1 and in the lower screen you can see the DHCP cluster configuration. Disk , IP, Name. and If you want to change this, this is the place to do this.

If you want to manage the DHCP server just do manage in the Cluster View

Right click on the DHCP role.

 

Sample overview of the DHCP server

Now that I have turned on the second node I can do a failover. Eh but you did not configure anything on this node Except installing the Windows DHCP role.

Yes but as it is a cluster the configuration moves to the other node.

  And I can do manage on both nodes or on a management server open the DHCP scope based on the DHCP netbios name.

Easy as that and the configuration of all the DHCP scopes are here.

A nice new feature of windows server 8.

Windows 8 Cluster Update #CAU ( Cluster Aware Update Wizard )

Updating and patching of you cluster is always a lot of work failover and patching and the other node. level the cluster etc etc.

Windows 2012 has a new tool for this : Cluster Aware Update Wizard. It is not a WSUS replacement.

How does it work well like this. You do not have to install any role or feature to use this.

Just start the CAU ( Cluster Aware Update Wizard ) no not COW 😉

Or do this of a cluster, yes it can be clicked but it won’t work you can’t patch the server that you are running the CAUW . so use a management server.  start the tool and connect to the cluster the Tool looks in the AD or netbios and off you go

Check my fresh installed windows 8 cluster and see if there are updates needed and sure there are two updates ready to install.

First I do a check / report what updates the nodes needed.

 

Now I do the update nodes and the wizard goes and ask me all kind of stuff but I can do only next.

 

   

Now that the wizard is ready It starts to update the nodes you can follow the update progress in the log view screen. I have one failure ( just for testing)

After the Reboot the cluster is ready and up again no problemos.

 

 

 

Clustering on Windows 8 the first steps

Now that windows 8 is available to the public, I can show you how to build a cluster in windows 8 not that this is shocking different than in windows 2008R2. but here are the few steps. There is so much new stuff that it is a long blog with a lot of screen dumps for those who just want to see and not want to install a cluster.

First we need two servers I will build a two node cluster.

This is basically the first logon page. I already added the machine to the domain and give the network a name and installed the failover Role.

 

 some screen shots

As in windows 2008R2 install the Role Failover Clustering and start to install the cluster.But where to start it looks so different. all the stuff is in the control panel.

  

The Server manager and the control panel are important , go to programs for the installed programs and not for roles or features. as you can see

 

 

Now that we found the roles follow the wizard. For installing the roles right click on the server and choose add role the wizard popsup and check the role and or feature it is fast and easy.

 

the role is set and after a reboot ( I checked .NET 3.5 and other options ) that needed a reboot I’m ready for my cluster.

   

Do the check vallidation if the Cluster nodes are useable for clustering

 

The Report shows that the storage is not Ok . This is right I need to assign the storage to the cluster.

The next step is create the cluster. I created the Cluster and give a cluster Name and IP number

Now that the cluster is ready for usage. We see that it is slightly different than in windows 2008R2 . The options in the roles are changed, menus are different.

Lets see step by step what is changed. the screens tells you the change.

All the services that can be clustered out off the box just follow the wizard . and get a different view of the Items. It depends on what you want to see.

 

As you can see the right click on the servers and other items gives you a nice view what you can do. very nice thing is that now you can drain the roles and not only pause the node.

Nice is not the show events just right click and you are there.

Create an empty role just right click and you are there.

 

Assign disk and change the Cluster Quorum / witness disk

 

an overview of my windows 8 server running on hyper-v. I like the icons on the desktop

the new server manager is way different and at first I thought WTF but after a few clicks I like it YES it need some adjustments but the start is OK nice over view of the things you want to change the first time. events ,performance yes this is cool nice views. really cool to much to put in one blog post. for now my denali cluster is ready and DC’s. all servers are test servers. probably the next version can’t be upgraded and all the work is gone so a lot of powershell exports for the next release.

NICE.

Technorati Tags: Windows,cluster,stuff,want,page,machine,Role,shots,Failover,panel,Server,manager,programs,features,check,feature,Report,shows,Name,Lets,Alle,Items,Nice,Create,Assign,disk,Quorum,performance,test,steps,build,blog,just,install,servers,node,give,some,control,roles,wizard,click,reboot,options,ready,storage,step,change,view,events,cool
Windows Live Tags: Windows,cluster,stuff,want,page,machine,Role,shots,Failover,panel,Server,manager,programs,features,check,feature,Report,shows,Name,Lets,Alle,Items,Nice,Create,Assign,disk,Quorum,performance,test,steps,build,blog,just,install,servers,node,give,some,control,roles,wizard,click,reboot,options,ready,storage,step,change,view,events,cool
WordPress Tags: Windows,cluster,stuff,want,page,machine,Role,shots,Failover,panel,Server,manager,programs,features,check,feature,Report,shows,Name,Lets,Alle,Items,Nice,Create,Assign,disk,Quorum,performance,test,steps,build,blog,just,install,servers,node,give,some,control,roles,wizard,click,reboot,options,ready,storage,step,change,view,events,cool