Wednesday 8 August 2012

Adding SQL Node 2 Cluster services (MSCS) verification error

Error Code 0x80071398
Error..! never mind.
I evicted the node from the cluster and re-added it. Validate the cluster. It worked. Reboot when in question.
reinstall the SQL failover cluster on node 2.
I'm thrilled as failover cluster is awesome and religiously working fine. This is now my first step forward to the new infrastructure for SQL 2008 R2 consolidation project. Redundancy at its par.

Tuesday 7 August 2012

Problem installing SQL Server 2008 R2 Failover Cluster on Node 2

Exception from HRESULT: 0x80070006
HRESULT: 0x80070006 (E_HANDLE)) ---> System.Runtime.InteropServices.COMException (0x80070006): The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE)). noted in SQL Server 2008 versions.
The problem rarely occurs in a row. So restart the server. Restart the SQL node two installation.
you can also try removing the traces of SQL installation from the second node and then try setup again. This time it should go.
for SQL instance removal failure try SQL installed instance removal

Monday 6 August 2012

curiosity lands on Mars - sends stunning pictures

The biggest scientific endeavor of the decade accomplished with NASA's Mars rover curiosity descending on the Red Planet today.. I watched it live on NASA's website @ http://www.nasa.gov/multimedia/nasatv/index.html
Rover sends first raw picture from the surface of the Mars

high resolution pictures expected in next 48 hrs.

The breathtaking moments of NASA scientist, ya it's unfeigned  team work:
Jet Propulsion Laboratory, California Institute of Technology, Pasadena, California
 

7 minutes of terror, Mars landing today 6th Aug 2012

live on NASA TV today scheduled to touch down inside a vast, ancient impact crater on Sunday at 10:31 pm Pacific time (1101 IST on Monday 6th Aug 2012). The 1 ton Rover will make an unprecedented Mars landing withstanding 1600 deg temp., friction will slow the capsule from its interplanetary cruising speed of 13,200 miles [21,200 kilometers] an hour to 1,050 miles (1,700 kilometers) an hour, according to NASA and finally a supersonic parachute will precisely land the rover to a stop at the identified spot.
The rover will operate for 687 Earth days (one Martian year), gathering information on climate, geology and to plan for a human mission to the planet.
India's first mission to Mars – First mission to mars 2013

Sunday 5 August 2012

SQL instance removal failed<<Quick Instance Removal

remove the instance by running the the syntax from command prompt where the SQL setup CD is mounted:
G:\>setup /Action=RemoveNode


Thursday 2 August 2012

Restore Favorite Folder and/ or Unread Mail in MS Outlook

Restore Favorite Folder in Outlook

for Outlook 2010

First Close the MS Outlook application and then click start and paste the below command in search field and press enter:

"C:\Program Files\Microsoft Office\Office14\outlook.exe" /resetnavpanel

Or you may click Window key + R and execute the above command.
Tips: windows key 

for Outlook 2007


First Close the MS Outlook application and then click Start >> Run "C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE" /resetnavpane

check if the favorite folder has come back or else in Outlook 2010 do the following as indicated with arrow marks:

In Outlook 2007 click View >> Navigation Pane >> Favorite Folders


this will turn favorite folder to display back properly.

Restore the Unread Mail Folder in Outlook Application


The "Unread Mail" folder is MS Outlook's default Search folder. It contains a count of the number of mails that are unread in the configured e-mail account. Sometimes, it may happen that this search folder would not be displayed or you might have accidentally deleted it. If so, you can easily Restore the "Unread" mail and display again.

In Outlook 2007


1. click the File menu, point to New, and then click Search Folder.
2. In the Reading Mail section, click Unread Mail.
3. click OK.



Shortcut to open the New Search Folder dialog box: Press CTRL+SHIFT+P (for both Outlook 2007 & Outlook 2010)
OR  do the selection as seen  


Now the Unread Mail will be visible under Search Folders. You may now add "unread mail" to the Favorite Folder by a right click and options available as seen below:



or 'Add to Favorite Folder' in Outlook 2007


that's it.

Wednesday 1 August 2012

Legal Notice before you get to Windows Logon prompt

TSIS-Legal Notice
Adding the legal framework notice on corporate systems.
 
open registry and locate for System under Policies
(Computer\HLM\Software\Microsoft\Windows\CurrentVersion\Policies\System).
Make sure you backup the System registry folder before making changes.
i)  Right Click from System folder and Select New – String Value. Name it as legalnoticecaption. DoubleClick to modify the Value Data and name it Legal Notice.
ii) Right Click from System folder and Select New – String Value. Name it as legalnoticetext. DoubleClick to modify the Value Data and enter the following text:
 
This Computer System and Network is sole property of your company name full (companyshortname) and may be used only by companyshortname employees for official purposes. Any sort of unauthorized use of this system is strictly prohibited and may be subject to criminal prosecution. Users should have no expectation of privacy as to any communication on or information stored within the companyshortname systems and network. The companyshortname reserves the rights to monitor any activity or communication on the system and retrieve any information stored within the system. By accessing and using this computer and network, you are consenting to such monitoring and information retrieval for law enforcement and other purposes.

this can be very well be added at domain security policy level.