Cant load up Reporting Services

Hi there
Im a newbie to Reporting Services and am trying it out on SQL Server 2005
I went through the installation process for Reporting Services and installed
a sample database from the Microsoft Press Book on Reporting Services.
I tried to navigate to the following location :
http://localhost/Reports/Pages/Folder.aspx
but i get the following error message
The report server cannot open a connection to the report
server database. A connection to the database is required for all requests
and processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
failed for user 'ReportServer2005'. The user is not associated with a
trusted SQL Server connection.
Ive set up ReportServer2005 as a Login on SQL Server and its been set
up as a Windows login accout.
Thanks
ChrisOn May 3, 3:26 pm, "Chris Asaipillai"
<chris.asaipil...@.btinternet.com> wrote:
> Hi there
> Im a newbie to Reporting Services and am trying it out on SQL Server 2005
> I went through the installation process for Reporting Services and installed
> a sample database from the Microsoft Press Book on Reporting Services.
> I tried to navigate to the following location :
> http://localhost/Reports/Pages/Folder.aspx
> but i get the following error message
> The report server cannot open a connection to the report
> server database. A connection to the database is required for all requests
> and processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
> failed for user 'ReportServer2005'. The user is not associated with a
> trusted SQL Server connection.
> Ive set up ReportServer2005 as a Login on SQL Server and its been set
> up as a Windows login accout.
> Thanks
> Chris
I've read somewhere that the User ID and Password for SSRS might be
locked. You might want to try unlocking it and restarting IIS (via
iisreset at the command prompt). Also, check the RSConfiguration file.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant