Solved

SSRS - Cannot create a connection to data source.

Posted on 2009-03-31
4
526 Views
Last Modified: 2012-05-06
I just deployed my cube and I am getting an error on my browser reading

Cannot create a connection to data source.

I can't figure this one out. When I was designing my  report the query builder could see the cube no problems.
0
Comment
Question by:Mr_Shaw
[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
4 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 168 total points
ID: 24029110
Might be your Login has expired.
Try resetting it and then delete the prior connection and create a new connection to the same server.
This should resolve your problem.
0
 
LVL 14

Assisted Solution

by:Emes
Emes earned 166 total points
ID: 24029143
it seems like a rights issue

you have to setup the data source in the properties tab of your report.there you select A Custom Data Source and Credentials storedsecurely in the report server

or use windows authentication with user domain
0
 
LVL 9

Assisted Solution

by:VikramMullick
VikramMullick earned 166 total points
ID: 24030736
0
 

Author Closing Comment

by:Mr_Shaw
ID: 31564830
thanks all
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Display SQL maintenance plan SQL Code 3 42
database access query MSSQL 3 42
SQL Server - Multiple Conditions on Left or RIGHT Joins 2 22
T-SQL Query 9 27
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

733 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