I was working on installing SQL2012 Server on a new machine as well as the reporting services, after configuring the reporting service i was trying to access the local reporting services URL when i got the attached below message






My account was an admin on the machine and SQL admin as well, i checked the UAC from Control panel and it was already turned off as shown below


Looks like in Server 2012 and 2012R2, even if you changed the setting "Never Notify" as shown above (which worked fine with 2008R2) the UAC is still active. In order to turn it completely you will need to edit registry as follows:

1. Navigate  to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system"
2. Change the "EnableLUA" key value from 1 to 0                                                                                                                                      
                                                                      
3. Restart the server/computer

After Applying the last Tuesday Microsoft (October 2012) patches/Updates, SQL reporting services wasn't able to start on several servers and the below error is displayed when you try to start the service



One of the Updates released on that date is the KB 2716440 http://support.microsoft.com/kb/2716440  which resolves a vulnerability in the SQL server. To make sure that this update specifically caused this behavior. I uninstalled this update and after that I was able to start the SRSS (Reporting services) without any problem.

This issue could occur by a missing registry key and a common solution to such problem is to add this key as follows:

1. Open Regedit on the Problematic Server
2. Navigate to the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
3. In the Right Pane create the following Key (If not already created)
1. Value: DWORD (32-bit)
2. Name: ServicesPipeTimeout
3. Value Data, Click Decimal and type 60000 (Not less than 60000)
4. Reboot the server

I passed by this experience when i was setting a new protection group using DPM 2012 for the latest SQL database server 2012. As per Microsoft System Center 2012 - Data Protection Manager Release Notes http://technet.microsoft.com/en-us/library/hh848297.aspx DPM 2012 should backup and recover SQL 2012 Databases except if the AlwaysOn feature is enabled. The AlwaysOn feature is not supported under the current DPM 2012 RTM but expected to be fully supported with the release of the System Center 2012 SP1 (expected in the next few weeks).

Briefly, To backup and recover SQL 2012 workload under DPM 2012 RTM

1. Make sure the AlwaysOn feature is not enabled (Currently DPM 2012 RTM doesn't support it)
2. Grant the SQL NT AUTHORITY\SYSTEM account SysAdmin Right.
3. Remove the Protection group and add it again after applying the above changes.