🙂 🙂 🙂 🙂 🙂 :)……………
Here’s an excerpt:
19,000 people fit into the new Barclays Center to see Jay-Z perform. This blog was viewed about 74,000 times in 2012. If it were a concert at the Barclays Center, it would take about 4 sold-out performances for that many people to see it.
Let me share with you guys, an Error Message what I’ve encountered yesterday. Well, this is not a very detailed post but I hope this will help what to check for when you encounter this Error/Warning Message.
Okay, I was validating a brand new SQL Server Clustered Instance(two node) and I tried to failover the Instance to the other node. But when I try to initiate a failover, I got this Message saying “the operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group“.
What’s the Issue: The 2nd Node was not added into this Clustered Instance.(Add Node to Cluster piece was missed by whoever Installed this SQL Server Cluster)
How to Confirm?
Go to the 2nd node and look for SQL Server Binaries for respective Instance. Also you should be seeing SQL Server Instance Being Installed but in Offline Status(assuming this is your Secondary Node at this particular point of time) from your SQL Server Config Manager Oooor you can simply Open Failover Cluster Manager and check for Possible Owners(Not preferred Owners) for this Instance.
Once he added the missing node to the SQL Cluster, everything was back in business as expected.
I know it’s a Quick and a Dirty Post, But I hope this helps!
Let me ask you this, how many of you as Server Admins/Database Admins used Task Manager of Windows in the past? I bet, all of you! Well, how many of you thought “Aah, It gives some useful information, but not everything”. I fall in the second category. It’s a very great tool for understanding about your server(but, I would say from 20,000 foot distance). Wouldn’t it be great if it really shows you how many Physical Sockets your server have, how many CPU’s(not logical), hyperthreading,what is the Rated Speed and what’s the actual current Speed your CPU’s are currently running? Yes, that’s what I’m talking about. You can get all this information at a single glance now on Windows Server 2012/Windows 8 :). Let me show you Windows Server 2008R2 Task Manager first.
Don’t get surprised looking at my Single CPU 🙂 It’s my DC, a Virtual Machine in my lab.
Anyways, are you able to see anything which I mentioned earlier? Nope. Basically we have to rely on some third party tool(I prefer CPU-Z for a high level internal details).
As you can see below, CPU-Z tool is giving all the cool information which I’m looking for. It’s pretty awesome tool to have in your toolkit if you are not already aware of.
Now see below for Windows Server 2012 Task Manager. I logged onto another Virtual Machine which has Windows Server 2012 Eval Edition.
As you can see It’s giving Rated Speed by manufacturer, current Speed, maximum Speed, Number of sockets, Processors, Type of machine and even CPU Cache details(You’ll see L1,L2 and L3 cache details on real Servers).
Isn’t it Nifty? I would say yes, It’s pretty useful in many cases!
Well, Let me ask you one Interesting Question. Do you think Task Manager on Win Server 2012 is a good tool to Understand your hardware of underlying Host for your Virtual machines? If you think “Yes”, It’s a Bummer!! See below Screenshot for the Task manager from the actual Host hosting those 2 above shown VM’s.
So, point to be noted is Task Manager and few other standard tools are not enough to dig into hidden details of VM Host. Do not rely on Task Manager for VM’s! Virtualization is a beast on it’s own which acts as a perfect Abstraction Layer. But for Physical Boxes, Task manager 2012 works like a champ and does it’s job pretty good compared to previous Versions of Windows as you can see…….
Today in the PASS summit, Microsoft announced SQL Server 2012 Service Pack1 which is made available to download for public officially. You can download this from here.
One cool thing to notice is that URL provides you with two flavors of downloads -SP1 Update and SP1 Slipstream 🙂 Personally, I like this move by Microsoft to provide Slipstream Downloads. You know why, if you’ve had to prepare your own SlipStreams for your SQL Server Installations at work!
You can get the List of Bugs got fixed in SP1 here.
In this Blog Post, let us see how to fix this Weird error message you might get while Installing SQL Server 2012 on top of Windows Server 2012. I already mentioned about this in the post where I showed how to Install SQL Server 2012 on Win Server 2012, but wanted to come up with a separate post just for this Error because it’s so annoying and frustrating when you see this. Trust me guys…This Error needs special Attention 🙂
Okay, Let’s say you are all ready for deploying SQL Server 2012 on top of Windows Server 2012 as your boss is pushing you towards SQL Server 2012(Which is awesome :)). You started your Installation and somewhere in the middle of your Installation Process, you get this annoying message that Installation Failed. Well, you are on Windows server 2012 which comes with brand new .Net Framework and you are not expecting any framework Issues(Initial setup Checklist gives no Errors on this). So what is it missing? The Answer is “.NET 3.51 Payload“. Yes, we must manually enable .NET 3.51 Payload in Windows Server 2012.
Look at the below Screenshot carefully at the Bottom left where it is asking for .Net Framework 3.5 to be enabled.
So, now you know why we need to pay attention while Installing SQL Server 😀
Anyways…..For this you need to have Windows media handy or should be connected to Internet, OR you can enable this automatically by enabling Remote Management which you might not do on your Production Boxes.
So, How to Fix this Annoying thing? Yes, you are correct if you said PowerShell (Few of you might thought about DISM or Just GUI for adding this feature as you used to do in Win Server 2008R2….YMMV!)
Note: Even the Error Message says, go and enable this feature using Server Manager GUI, it might fail!!!….Avoid GUI for fixing this. Instead use awesome PowerShell guys. I’ll show you powershell way of doing this…
1. Insert your Windows Media in your DVD Drive(in My case it’s D:)
2. Open Powershell as Admin and type “Install-WindowsFeature Net-Framework-Core -Source D:\Sources\sxs” without double Quotes and hit enter.
Look for Exit Code “Success”! That’s it Guys…The Rest should be Flawless!
MSSQLTREK 