Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Data Source security using SQL username (not windows username)

Answered Data Source security using SQL username (not windows username)

  • Wednesday, January 30, 2013 6:45 AM
     
     
    Sign In to Vote
    0

    Hi,

    Is it possible to set the connection of data source to be "stored securely in the report server" using an SQL username and password instead of a windows username and password?

    I suppose that might be possible but will not function with subscriptions/ cache. Or would it? I suppose using an SQL username it would not be possible to check "use as windows credentials when connecting to DS"?

    Thanks

    Namnami

     

All Replies

  • Monday, February 04, 2013 12:54 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Namnami,

    When we specify stored credentials for the data source, the user name and password can be Windows credentials or a database login. If we specify Windows credentials, the report server passes the credentials to Windows for subsequent authentication. Otherwise, the credentials are passed to the database server for authentication. Both types of the credentials can be used for report subscription and report cache.

    Reference:
    Specify Credential and Connection Information for Report Data Sources

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

    Regards,

    Mike Yin
    TechNet Community Support