I have AD RMS on Windows 2008 R2, it worked properly for two years.
I didn’t change any parameters, but now I can't generate any reports, the error is: "The following error occurred while obtaining data from Microsoft SQL database: Time out expired. The timeout period elapsed prior to completion of the operation or server is not responding."
However AD RMS is working and handing certificates upon request. There are logs in the AD RMS SQL database(dbo.ServiceRequest and dbo.Certificate are growing)
Configuration: AD RMS cluster: 2 x (2 CPU + 4 GB RAM) SQL Cluster on VMware: 4 CPU and 16GB for each node Total ADRMS SQL DB size < 40GB DRMS_Login_xxx dbo.ServiceRequest ServiceReuiestID > 16M records dbo.Certificate RequestID > 9M records
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.