RE: Reporing service failure

Hi Puru,
Thank you for your response.

Just check with you whether you added the "Audit Login Failed" event in
your SQL Profiler trace. I did not find any login failure in the trace file.

Also I recommend that you try explicitly adding your domain user account as
a login to your SQL Server instance and assign it with db_owner role on
your ReportServer and ReportServerTempDB databases. You can refer to the
following steps:
1. Logon your SQL Server instance from SSMS;
2. Expand the Security folder under your server, expand the Logins folder.
3. If the domain user account is not here, please right click the Logins
folder, click New Login..., input the Login name (ED\isppmsrs), select
Windows authentication, select "User Mapping" in the left column, check
ReportServer, check db_owner, check ReportServerTempDB, check db_owner and
then click OK.

After these steps, try configuring your Database Setup in your Reporting
Services Configuration Manager again.

Hope this helps.

Best regards,
Charles Wang
Microsoft Online Community Support

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.