I was receiving the following error: Failed to connect to data source ‘The broker service reported an error. See the event log for more information.’ in the event viewer ( Event ID 5) when using Desktop Director, and the latency wasn’t displayed.
It looks like the performance counters are corrupted, I repaired them using the following command lodctr /r.
When running the command you receive the error:
Error: Unable to rebuild performance counter setting from system backup store, error code is 2
Open the command prompt and run the following command:
Noow you receive the following message:
Info: Successfully rebuilt performance counter setting from system backup store
You would like to manage Windows 8.1 and Windows 2012 R2 through GPO from Windows 2008 R2 domain without updating your domain.
Download and install the Administrative Templates (.admx) for Windows 8.1 Update and Windows Server 2012 R2 Update and copy the definitions to your central store.
To see what’s new: Group Policy Settings Reference for Windows and Windows Server
The SQL setup won’t start when you double click setup.exe, when executing setup.exe from command prompt you will receive the following error:
ERROR: Runtime error: This method explicitly uses CAS policy, which has been obsoleted by the .NET Framework. In order to enable CAS policy for compatibility reasons, please use the NetFx40_LegacySecurityPolicy configuration switch. Please see http://go.microsoft.com/fwlink/?LinkID=155570 for more information.
The solution is to remove .Net Framework 4.5
After removing you can install SQL.