Wednesday, January 30, 2013 6:45 AM
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"?
Monday, February 04, 2013 12:54 PMModerator
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.
If you have any questions, please feel free to ask.
TechNet Community Support
- Marked As Answer by Charlie LiaoMicrosoft Contingent Staff, Moderator Monday, February 11, 2013 1:44 AM