Setting up sql reporting services | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Setting up sql reporting services

I set up SQL reporting services. Basically I had a clean box where I put Windows advanced Server 2003, Sql server standard, Standard reporting services, IIS services, and Aspnet on. From there I ran the rsactivate and the rsconfig, according to the docs. Anyways, I get the web GUI to come up fine. I created a test report. It previews fine in Vstudio 2003. I deployed it to my web/sql/sql reporting server. I browse to it using report manager. I click it, I continually get a Login Failed error. login for user account bblehbleh failed. I have no idea where I have gone wrong. The username/password work fine in Query Analyzer and in Visual Studio, where the report previews fine. I have probably messed up using rsactivate or rsconfig somehow, but they seemed self explanatory. We really want to get away from crystal at some point, and with its tight integration with the .net framework and pricing, this seemed like the way to go. But it’s kind of hard to do if I can’t get it to work. Any help or suggestions would be much appreciated.
Hope you have checked Login Credentials for your Data Source in Report Manager (Assuming you are able to browse deployed reports going tohttp://SERVERNAME/Reports/Pages/Folder.aspx ) Harsh