SQL Server Installation Add Features is not Showing All Instances

Today we get a request to install SQL server reporting services for 4 of 8 of the instances on a server.
As usual we pick our sql 2012 dump and start installing. When we reached to Add feature page of installation we were not able to see 4 of 8 instances in drop down as in screen shot

Difference Between varchar(max) and varchar(8000)




Script for Multiple Restore in one shot SQL server


Windows update can't check for updates because the service is not running

Patching does have its own issues, hard to predict

 This time I was doing windows updates

Control panel --> System and security --> Windows update -->check for updates

The image file is valid , but is for a machine type other than the current machine


While patching SQL server 2005 SP1 to SP2, we face below error

Error: The image file is valid , but is for a machine type other than the current machine

This error clearly states that patch file is good, the issue  is with my machines

SQL Server System Databases

 Many people does know about system databases but no one remembers detailed version and get confuse in tricky questions. So I have put this in points

Master Database :