February 24, 2014 at 9:16 pm
I am running Report Server on localhost with a datasource defined as a "custom data source" defined using "Windows integrated security". I can connect and run the report successfully. However, when I attempt to generate a subscription, I receive an error stating "Subscriptions cannot be created because the credentials used to run the report are not stored". My reportserver.config contains the following authentication RSWindowsNTLM. I have tried every possible combination of authentication options, but I still can't get subscriptions to work. My Report service service account is using the Built-in account: Reportserver$MSSQLSERVER12.
I can't seem to find the solution to this issue. Any help would be appreciated.
February 25, 2014 at 11:56 am
The "the credentials used to run the report are not stored" is referring to the dataset used to run the reports. Since it is set to Windows Integrated Security, it works for you when you run the report in SSRS because you have permissions. But the subscription probably doesn't have a default user to run under, so there are no permissions. We have a default user for our shared datasets, and we set them up using "Credentials stored securely in the report server." That way the subscriptions run under that user, with that user's permissions.
February 25, 2014 at 7:40 pm
What are the required steps that need to be taken? Thanks.
February 26, 2014 at 12:58 pm
IN SSRS, go to the Data Source definition for the data source the report is using. In Properties, select the "Credentials stored securely in the report server" radio button, and then enter a user and password that has reporting permissions. Hopefully then you'll be able to set up your subscriptions. As I mentioned, we have a generic reporting user whose credentials are stored in our shared data sources.
February 28, 2014 at 7:04 am
This is where my problem exists. Report Server is running on localhost. I am set up as an admin user on the localhost machine and in SSRS Site Settings I am also set up as a user with System Administrator, System User roles. In Reporting Services Configuration Manager/Report Server Database/Current Report Server Database Credential the following setup exists:
Credential: Windows Account
Login: MY-PC\Will
Password: ****************
The password length here does not seem to match my windows account password. When I select "Change Credentials" I get:
Server Name: MyServer
Authentication Type: Current User - Integrated Security
User Name: MY-PC\Will
Password: blank
Test Connection is successful.
When I go to "Change Credentials", I enter the following info using my windows password.
Authentication Type: Windows Credentials
User Name (Domain\user) MY-PC\Will
Password ***********
The change appears to be successful:
Generating rights script Success
Applying connections rights Success
Setting DSN Success
When I attempt to create a datasource on localhost report server using ""Credentials stored securely in the report server" - I receive a password error.
When I use "Windows integrated security" I receive ""Connection created successfully.
I am stumped. Thanks for your help!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply