SSRS Subscription cannot be created because the credentials used...
-
I am trying to create my first subscription on my SSRS webpage and I'm getting an error that says "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.".
I've looked this up online and found some websites that talk about going into the properties of the report and changing the data source to a custom data source and "Credentials stored securely in the report server" but I tried my user name and password to no avail. Can anyone help me get this set up? -
Are you able to run the report in SSRS, or does it always ask you for credentials? In setting up the custom data source, did you check the Use Windows Credentials box below the password field? I've found I need to check that when I use my credentials in a data source.
-
We are in fact able to run the reports in SSRS.
Currently they all use a shared data source that is using
Data source type: Microsoft SQL Server (with a connection string) and the Windows integrated security radio button is selected.
With this set up running the reports have no problems.When creating a custom data source for the report that I want to turn on subscriptions I've tried "Credentials stored securely in the report server" and can't get a test connection to work with my user name and password. I then found online that it doesn't look like you can use your own user id but you have to use the guid?
http://eimagine.com/ssrs-error-for-crm-report-subscriptions-cannot-be-created-because-credentials-are-not-stored/I've tried the link in step number 4 to get this ID but when I do a database engine query I can't find "<organization>_MSCRM". I feel like I'm going down a million rabbit holes to figure this thing out...
-
Sounds like you have the datasource set up to use the current users credentials. If it's a subscription, then there is no current user, thus no credentials to use. if you're using SSRS 2008 or prior, or not using a shared datasource , you'll need to update the datasource credentials at report level. if you're using a shared datasource (available in SSRS 2012 onwards), you'll need to update the credentials on the deployed datasource.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
OK that makes sense, so when creating a data source for the report specifically do I need this guid that the link is talking about? No matter what I try the test appears unsuccessful. Oh, and I am in fact using 2008 R2.
-
You'll need to amend the report's datasource then. When you manage the report in the web console, there is a "tab" called Data Sources. You'll need to enter the credentials you want the report to use in there. Most people use some kind of Service Account, specifically designed for running SSRS reports, and exporting them (if you are using a file share subscription).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Is the service account the part where I do a database engine query and query the "<organization>_MSCRM"? I'm not sure what the link I posted is telling me to do...
-
I'm not sure how to identify the credentials that I should use. The link above said something about querying the system to get them but I'm confused, can anyone help?
-
Use the credentials you need, you or your dba and your network Administrator, will likely need to set them up. I can't tell you what those credentials are, as they are unique to everyone.
As I said, a lot of people create a Service Account for it. it'll need to be able to access any data that your reports access, and if required, save to designated locations for file shares.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
I tried using my credentials which has full admin to the server to no avail. Should I not be referring to the link above? It pulls out an already existing user id from a database that looks hexadecimal.
- DKY - Monday, February 20, 2017 9:36 AM
What was the error you had returned, did it fail to log in, gave you the same error message about not having a datasource? if you were using your own credentials, are you using a Windows Login? If so, did you check the box that says you are using Windows Authentication?
Edit: Your interface will look different to this. as you have SSRS 2008, however, using Windows Auth, you'll need to enter something like:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply