The report server cannot open a connection

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  September 29, 2009 at 9:12 am

  #205210

  Setup failed to validate specified Reporting Services Report Server http://MYSubDomain.AFCCInc.Com/ReportServer. Error: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

  The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

  I am hoping that someone that has experienced this error can point me in the right direction.

  I have just installed AD, AND MS CRM 4.0 on one server, and on my data server where my one instance of sql server 2008 lives I have added Reporting services.

  I am getting this error from the server where my CRM is being installed, and this is the error that I receive after installing the MS CRM.

  When I installed reporting services on my data server, I receive the same error on the same machine that reporting services is installed.

  What do I need to do to be able to connect to reporting services ? I am assuming that all ports are open when i did the reporting services install.

  Thank you.

  Dam again!

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  September 29, 2009 at 9:59 pm

  #1059788

  After reinstalling my report services everything seems to be connecting just fine.

  I will have to admit, this AD with Reporting Services was rough!

  I have one last error, and I cannot seem to get it to go away.

  I am posting a picture hoping someone can help with it.

  Just to let you know that I have named pipes completely disabled. However, I still got this error when the named pipes was enabled.

  Please see the attachment.

  http://www.afccinc.com/help/CRM-Last-Error.jpg

  Dam again!