Bootmgr is missing ERROR ...!!!!!!!!

Bootmgr is missing ERROR

I had a tough time with windows server 2008 R2 when it gave me an error as 

“ BOOTMGR IS MISSING  PRESS CTRL+ALT+DEL TO RESTART”

After lots of struggling hours on internet and consulting many experts I was able to boot my server normally, it was very important server to retain as many things depended upon it .Things that I have tried were changing the boot options from settings and trying to boot and tried to explore other options too… things which worked were when I tried to explore through repair options,(I took a snapshot of the machine before attempting these as it was virtual machine)

1.   Boot your server from CD\DVD
2.  Click next and select Repair your computer 
3. Select first option and click next
4. Select command prompt
5. Type diskpart and enter
6.  Type list Volume and enter  
7. Check which is the system reserved partition (basically it would be 100 MB check the drive letter too)
8. Select the volume which is assigned to system reserved partition eg. Select volume 1 and enter
9. Type active and enter this would give message like ’DiskPart marked the current partition as active'
10. If you type list volume again it would shoe asterisk (*)which is active
11. Now type list disk and enter
12. Select the disk where your windows is installed typically its disk0 hence type Select Disk 0 and enter
13. Type list partition and enter to list partitions which may display message like Partition 1 is now the selected partition
14. Exit diskpart now
15. You can additionally try system file checker commands too like sfc /scannow which inspects all important windows files and if it finds any issues with them it replaces them
16. Restart your server machine and check if that’s boots properly.

Hope this helps resolving the above issue.

Failed to create SQL server certificate Error on SCCM installation

I came across one more error while installing SCCM 2012 which says Failed to create SQL server certificate Error on SCCM installation, tried to Google again on the same to find root cause it was found that the account with which you install the SCCM set up should be local administrator on that machine which my account was but more condition is it should also be added onto sysadmin group on the sql server it is connecting to. After adding the user to these groups installation completed smoothly. Enjoy installing SCCM.

Error :

Could not connect or execute SQL query error on SCCM installation

While installing SCCM 2012 I came across one more error as Could not connect or execute SQL query as shown below hence tried to Google for the solutions to rectify the same .

If many instances are running on sql server they try to run on port 1433 for specific IP hence it is better to turn off Listen All but the changes which would matter here are protocols for instance under  IP All settings through configuration manager on SQL server should have 1433 listed and listen all setting to be given as NO. Specifying the port number is the key here, clear all the dynamic ports number and don’t forget to restart the SQL services once changes are made.

How do I get rid of Dynamic ports Enabled Error on SCCM installation?

How do I get rid of Dynamic ports Enabled Error on SCCM installation?

We use configuration manager to specify the ports TCP port 1433 and to disable the dynamic ports .Even though it again says us to use static port 1433, hence one should disable dynamic ports (field set to a blank string) ie this can be set to blank through SQL server configuration manager as shown below, this should fix the error.But make sure you restart the sql service before trying to attempt for it again.