Solved

Cannot Open Database requested by login in Reporting Services 2008

Posted on 2009-04-13
5
588 Views
Last Modified: 2012-08-13
Hello
I cannot open a report on my reporting server using the crediential for a user "reportadmin".
User is memeber of all the SQL Server groups (see attached pdf)

I am getting the follwoing error:
Cannot open database "dbname" requested by the login. The login failed. Login failed for user 'machinename\user'
user.pdf
0
Comment
Question by:saleemz
  • 3
  • 2
5 Comments
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 24135320
Make sure that the user that you are connecting with in the data source that is deployed to the Reprt Server has proper connect privlidges to your database "dbname".  This error looks like what I have seen when a new or changed datasource has not been granted the right access.
0
 

Author Comment

by:saleemz
ID: 24135725
what access do I need to give him and how do I do that?
I am new to reporting services. I will appreciate your assistance.
0
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
ID: 24141896
Use Management Studio to connect to the database that the reports will run against.  Under Security>Logins> Right click on the login that is connecting from the Data Source and select Properties.  Select the User Mapping page and make sure the database is selected up top and whatever roles they need to be members of on the bottom.  We alway like to create a database role to assign logins to and then grant access to stored procedures (Prefered) or tables and views to get to the data.  That makes it easier to add other logins to get all reports or add a new stored procedure to be available all reporting users.
0
 

Author Comment

by:saleemz
ID: 24143674
Thanks its all working now. The problem was that the users were not assigned (not even added to the users list). Now I know how it works. We need to make sure that the users are added to the database and then assign them with approprate roles.
Thanks again for your help.
0
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 24144252
Your welcome, glad all is working now.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now