Do you ever have those days where it just starts bad and gets worse?
“Man Alive, what a day it has been and it is not over yet”
First, simple network change, enabling DHCP helper on our new Infrastructure. Sounds simple, right?. Well, our switches are stacked for connectivity and storage, so a reboot of the switches means shutting down the environment, IP and iSCSI. So I go and do this, not knowing about our cluster needing 3 nodes active, what a mission. We eventually got everything up and working after some help from “Call a Friend”, you know who you are and THANK YOU AGAIN .
Then we decide to move one and continue the day’s work with our migration, hit some snags there, but got through that.
Got to my desk and decided to load up our helpdesk tool, only to find the Reporting component is playing up. However, I would like to introduce all of you to my good friend and you all know him, Uncle GOOGLE. After much digging through MS Articles and already having done these steps and not finding much wrong, I came across the following gem. http://www.sqlservercentral.com/Forums/Topic719286-146-1.aspx#bm726108 . Gotta love these dedicated sites, followed the TEMP folder route and “voila” (almost as good as abracadabra, hehe), it is now working again.
In hindsight, should have stayed in bed and bunked today.
LOL
“EMBRACE YOUR INNER GEEK AND
ROCK ON”