none
SSRS basic authentication pass user credentials to SQL Server data source RRS feed

  • Question

  • "After you enable Basic authentication, be aware that users cannot select the Windows integrated security option when setting connection properties to an external data source that provides data to a report. The option will be grayed out in the data source property pages."

    So, what authentication can you use?

    How do you identify the user to SQL Server?

    Can you pass through the user credentials to an explicit SQL Server user account?

    Many thanks in advance,
    e.

    Tuesday, March 14, 2017 12:17 PM

All replies

  • Hi exotericist,

    Generally, when configuring a data source, we can specify credentials in the following ways:

    1. Prompt the user for credentials.

    2. Store credentials.

    3. Use Windows integrated security. (If you are using basic authentication, this option is can not be selected)

    4. Use no credentials.

    The network environment determines the kinds of connections you can support. For more information, please refer to: Specify Credential and Connection Information for Report Data Sources

    In your scenario, you can use store credentials and type a user name and password using either windows credentials or database credentials. See: To specify stored credentials for a shared data source

    If you still have any questions, please feel free to ask.

    Best Regards,

    Pirlo Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, March 16, 2017 2:20 AM
  • Thanks for the reply.

    The developer tells me he has to use forms authentication to provide access to SSRS, since he wants to prompt the user for credentials only once when the app starts up.

    This will identify the user to SSRS.

    Is it possible then to pass these credentials to SQL Server?

    How would I access them?

    Many thanks in advance,
    e.

    Thursday, March 16, 2017 1:12 PM
  • Hi exotericist,

    What's the meaning of "pass these credentials to SQL Server"? Do you mean pass the custom forms credentials to SSRS?

    If so, SSRS is supported to use custom forms authentication. You can share the forms authentication cookies with SSRS. For more information, please see: Reporting Services Custom Security Sample

    Regards,

    Pirlo Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, March 20, 2017 4:31 PM