April 15, 2015 at 11:05 am
I have a report deployed with a shared data source. Running the report prompts for windows credentials. The report runs successfully when I enter the credentials.
The shared data source has the below mentioned properties.
I don't want the report to prompt for credentials. When a user runs the report, if they have access to the data source, then they should get results or get denied if they dont have access
How can I prevent the prompting? I can create a new data source if needed. Please advise.
<Extension>SQL</Extension>
<ConnectString>Data Source=devreportserver</ConnectString>
<UseOriginalConnectString>False</UseOriginalConnectString>
<OriginalConnectStringExpressionBased>False</OriginalConnectStringExpressionBased>
<CredentialRetrieval>Prompt</CredentialRetrieval>
<WindowsCredentials>True</WindowsCredentials>
<Prompt>Windows username and password</Prompt>
<Enabled>True</Enabled>
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply