none
AD RMS Report error: Timeout expired

    Question

  • 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

    How to troubleshoot this case ?

    Sunday, September 01, 2013 12:08 PM

All replies

  • Hi Jacek,

    do you still experience this problem?

    Might you want add a timeout setting to the SQL connection string under HKEY_LOCAL_MACHINE\Software\Microsoft\DRMS\2.0\ConnectionString

    e.g. connect timeout=60;

    That changes the connection timeout from 15 seconds to 60 seconds.

    Regards,

    Lutz

    Thursday, October 17, 2013 2:50 PM
  • Hi Jacek,

    do you still experience this problem?

    Might you want add a timeout setting to the SQL connection string

    I have an open case in PSS - looks that it is 'by design'  if you have more than 2M records in AD RMS log_db :-(

    • Edited by JacekN Sunday, November 17, 2013 10:05 PM
    Sunday, November 17, 2013 10:05 PM