SSRS report prompting for windows credentials

• wannabe1

  SSCommitted

  Points: 1960

  More actions

  April 15, 2015 at 11:05 am

  #302953

  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>