Should I be deleting a ReportServer database?

I'm new to SSRS. I setup a ReportServer locally on my laptop and it works. I can deploy a report, open the report server database and look at the tables. So far so good.

This is SQL 2014

1. We have a Test server and I see 2 databases on it: "ReportServer" and "ReportServerTempDB". When I click on the databases, I get this message.

2. I restarted Services and tried it again but didn't work.

3. I can see it setup in this screen and I tried "test connection" and that worked. The ReportManager Web Services and Manager URLs work as well. So, howcome I can't open the database? Should I create another Reports Server database?

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.

Jason clarkDBA FreelancerCommented:
If you are getting this error then you have to connect to database in single-user mode.
Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role.

Here you can find step-by-step instruction to do this.

In short you must start the SQL Server instance with parameters -m, after start SQL Server Management Studio with windows authentication.

Now you are a sysadmin, assign the sysadmin role to your user, exit and remove the -m parameter and restart SQL Server.
Vitor MontalvãoMSSQL Senior EngineerCommented:
1. We have a Test server and I see 2 databases on it: "ReportServer" and "ReportServerTempDB". When I click on the databases, I get this message.
How are you trying to connect to those databases?
Are they in the local server or remote? If remote you need to allow remote connections to them. Also you'll need to have SQL Browser service started and running.
Which user are you using? Verify if it has permissions in the databases.

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
CamilliaAuthor Commented:
I tried opening the database by logging into the server itself.
I have SQL 2014 on my laptop as well so I connected to it and tried to open it and got the same message.
I used the login/password for the SQL server. It's a login test created that we use in the ASP.Net code as well to connect to the database.

I'll check the solutions suggested and will post back.

I shouldn't create a new Reports database?
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Vikas GargAssociate Principal EngineerCommented:

Its not good idea to delete the databases

"admin permissions " is what you need on the database.
CamilliaAuthor Commented:
I can open another database on that server. But I need specific admin permission on the server or on the reports database?
Vitor MontalvãoMSSQL Senior EngineerCommented:
I used the login/password for the SQL server.
I don't know if it's a good idea. I think the user should be the same that is configured for SSRS service account.

I shouldn't create a new Reports database?
No. SSRS create the 2 databases during the setup.
CamilliaAuthor Commented:
Let me see what the user ID and password are and try opening the reports database with that.
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

From novice to tech pro — start learning today.