August 20, 2008 at 10:38 am
I have SSRS installed on my SQL Server 2005 server, however, I noticed that the ReportServer and ReportServerTempDB databases are not existing. I don't know what happened to them. What is the best way to get them - I do not have any backups. I thought I could reinstall SSRS but it apperas that I cannot uninstall it without uninstalling SQL Server Database Engine. Any ideas? Can I do a backup from another server and restore them to this one or will that corrupt something? Any thoughts are appreciated
August 20, 2008 at 11:32 am
What does the Reporting Services Configuration Manager say? In Start -> Programs -> Microsoft SQL Server 2005 - > Configuration Tools. I believe you can install the databases from here as well if they show as not installed.
Restoring from somewhere else is a major pain as you would need the Encryption Key and restore that as well. If the DB's never installed you won't have an encryption key.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 21, 2008 at 8:50 am
Ok thanks. I checked the configuration and had the databases created from there. I did get an error that the virtual directory must be created but the databases are there now. I need to read up on the Reporting Services and what the virtual directory is all about. I am an newbie at SSRS. Thanks for your help
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy