RE: Reporing service failure

Hi Puru,

I have the exactly same issue here. at the end of the day, i found that you
need to make sure the domain user is in local administrators group. this is
another important step to fix this issue.

hope this helps.

cheers!
Jerry Chen

""Charles Wang [MSFT]"" wrote:

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.
=========================================================


.

Relevant Pages

  • RE: Reporing service failure
    ... your SQL Profiler trace. ... I did not find any login failure in the trace file. ... your ReportServer and ReportServerTempDB databases. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: Win98 user acct cant connect - admin acct can
    ... I have made sure that everybody can login from the ... >If the administrator is the Domain Administrator, ... >account used a password that had a letter in it that ... A standard domain user account gets the ...
    (microsoft.public.windows.server.networking)
  • RE: cannot log into Reporting Services from SMSS
    ... You could try the following steps to add a domain user to sql logins. ... Type "domainname\username"(without quotes) in Login name box. ... ONE BUSINESS DAY RESPONSE to all posts. ...
    (microsoft.public.sqlserver.connect)
  • Re: can not login
    ... something in the link between their network and the one where the WSS ... > She is a domain user, that has previously been able to login to WSS. ...
    (microsoft.public.sharepoint.windowsservices)
  • Sharing Favorites Between Two Logins
    ... I have a local and domain user set up to share the same local profile on a ... local user login. ... due to some security configuration? ...
    (microsoft.public.windows.inetexplorer.ie6.browser)