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!
LVL 5
gigglickAsked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
also you need to install fresh sql server 2005 service pack (at least sp1)
0
 
Eugene ZCommented:
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?
0
 
gigglickAuthor Commented:
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.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
gigglickAuthor Commented:
Increased the points
0
 
Eugene ZCommented:
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
0
 
gigglickAuthor Commented:
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
0
 
Eugene ZCommented:
no problems
what error(s) did you get during setup of SSRS in the Configuration toll?
0
 
gigglickAuthor Commented:
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
0
All Courses

From novice to tech pro — start learning today.