Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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