Solved

Cannot Open Database requested by login in Reporting Services 2008

Posted on 2009-04-13
5
586 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In this article I will describe the Backup & Restore 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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

706 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

15 Experts available now in Live!

Get 1:1 Help Now