Hi, We have installed CRM2011 on Windows Server 2008 Standard and SQL Server 2008 wuth reporting services. I am getting follwoing error, when I am trying to run the report through CRM. The report is running fine in BIDS. Any thoughts? Log Name: Application Source: MSSQLSERVER Date: 10/28/2010 2:31:59 AM Event ID: 18456 Task Category: Logon Level: Information Keywords: Classic,Audit Failure User: Domain\svc_SQL Computer: CRM2K11BETASQL.Domain.pvt Description: Login failed for user Domain\svc_SQL'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

Hi, From the error message "Login failed for user Domain\svc_SQL'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]", the issue might be caused because the user Domain\svc_SQL can't access the report database. So, you can logon the SQL Server instance to check if the user has rights on this database, or use the stored credential (do it in report data source page) in report server option to work around this issue. Please let me know more if the issue persists. thanks, Jerry