Solved

Cannot Open Database requested by login in Reporting Services 2008

Posted on 2009-04-13
5
595 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 27

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 27

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 27

Expert Comment

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

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

691 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