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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
gigglickAuthor Commented:
Increased the points
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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
Eugene ZCommented:
also you need to install fresh sql server 2005 service pack (at least sp1)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.