aberndt (1/25/2012)
I see 2 databases in SSMS called XXReports and XXReportsTempDB, should I delete these before I reinstall??? I am going to be the only one creating reports in SSRS and then I will make them available to other users. Should SSRS be installed on the server or my workstation? If I install it on my workstation, what needs to be done to the server to allow it to function as the report server? I really apologize for all of the questions, you are being very helpful. Is there somewhere that has a step-by-step guide to getting started???
It is better to install SSRS on the server, otherwise it will not be accessible if your workstation is off etc.
If you are going to reinstall SSRS, you can remove those 2 databases as it will have no effect. The current names of those databases should not have the "XX" in the name. Maybe if you remove that it would fix the issue...but if there is any uncertainty on your part it may be better to create a clean installation.
EDIT: Please make sure though that those databases are not used for anything else, before you delete it. Or at least create backups.
For more information on SSRS, see the following: http://msdn.microsoft.com/en-us/library/ms159106.aspx