SSRS
hi ,
when i m goin to browse in report manager configuration url then i m facing beloww error please advice
error : "rsReportServerDatabaseLogonFailed"
please help
thanks and regards:
ajeet
November 17th, 2010 3:53am
Find your error message
http://msdn.microsoft.com/en-us/library/ms156468.aspx
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 5:13am
has your account been created on Report Server??SSRSRpt
November 17th, 2010 11:28am
Hi ajeet,
Based on the error message, you can open the Reporting Services Configuration Manager tool and click Database in the pane at the left hand side, in the Database page, verify the account you have set has rights to access report server database.
The following information is from this article
http://msdn.microsoft.com/en-us/library/ms159133.aspx .
Accounts used to connect to the report server database are granted the following roles:
public and RSExecRole roles for the
ReportServer database.
RSExecRole role for the master,
msdb, and ReportServerTempDB databases.
When you use the Reporting Services Configuration tool to create or modify the connection, these permissions are granted automatically. If you use the rsconfig utility, and you are specifying a different account for the connection, you must update the
SQL Server login for that new account. You can create script files in the Reporting Services Configuration tool that will update the SQL Server login for the report server.
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 2:41am