Should I be deleting a ReportServer database?

Camillia
Camillia used Ask the Experts™
on
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.

Error
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?

Manager
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jason clarkDBA Freelancer
Commented:
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.
https://msdn.microsoft.com/en-us/library/dd207004(v=sql.110).aspx

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.
IT Engineer
Distinguished Expert 2017
Commented:
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.
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?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Vikas GargAssociate Principal Engineer
Top Expert 2014
Commented:
Hello,

Its not good idea to delete the databases

"admin permissions " is what you need on the database.
I can open another database on that server. But I need specific admin permission on the server or on the reports database?
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
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.
Let me see what the user ID and password are and try opening the reports database with that.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial