Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

SSRS - Cannot create a connection to data source.

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
Mr_Shaw
Asked:
Mr_Shaw
3 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
EmesCommented:
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
 
Mr_ShawAuthor Commented:
thanks all
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now