asked on

Reporting Services Re-Installation

I was having no luck with a SQL server Reporting Services repair (some config tools were missing from the original install). So I uninstalled following the directions at the following link. http://msdn2.microsoft.com/en-us/library/ms143518.aspx
We re-installed and rebooted and I'm not seeing the reporting services databases. I also can't navigate to the server/reports page. Can anyone help me figure out of to get this back up. Do I just need to reattached teh db files? If so where are they.

THanks!

EugeneZ

make sure that during installation you selected right sql server
after you'll get databases (if you have backups or DB files of SRS databases (you can try to attach or restore)
go to Reporting services configuration
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\RSConfigTool.exe"

then try to navigate..
----
BTW: what was error that made you reinstall srs?

gigglick

ASKER

Hi -

THanks for your reply. I was not able to navigate to the //Server/Reports folder...At that point it gave me a general error just stating that an error occurred on the report server. When I clicked the help link there was no information available on the error. I'm using a test server right now to try to diagnose the problem (by recreting but am having no luck). Do you know if there is a good guide out there on how to use the Reporting Services Configuration Tool? INstead of having to rebuild the server I'll have to use this to reinstall and configure the RS instance but the guides I've found are not very good.

gigglick

ASKER

Increased the points

EugeneZ

you can not use SRS without setup from Services Configuration Tool

how to use the Reporting Services Configuration Tool:

Black Belt Administration: Reporting Services Configuration Manager
By William Pearson
http://www.databasejournal.com/features/mssql/article.php/3683406

http://technet.microsoft.com/en-us/library/ms156305.aspx

SQL 2005 Reporting Services Part 1
http://www.databasejournal.com/features/mssql/article.php/3573361

ASKER CERTIFIED SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gigglick

ASKER

Thanks, I've been using the Configuration toll with errors but I did not reinstall the service pack (2). I will try this and let you know...thanks again for your help

EugeneZ

no problems
what error(s) did you get during setup of SSRS in the Configuration toll?

gigglick

ASKER

I would get all the way through to the database setup where it would crap out -- it gave me no real description of the error and I check the permission for the username and it had full permissions to the database. When I tried scripting it instead of using the wizard it looked like it created corrupt scripts as it was trying to create the RsEXECRole in databases that didn't exist?? Thank god this is just on the test server -- cross my fingers on the sp