I'm trying to configure the data source for an SSRS 2012 report using the "Credentials stored securely in the report server" option. I specified an AD ID and password, and checked the "Use as Windows Credentials when connecting to the data source" option. I click the Test Connection button and I get "Login failed for user ad1\myuserid". I know the password is correct since I am using it for other things. The MSDN doc on this says it should work.
Does anyone else use an AD ID and password with stored credentials for SSRS 2012? Is there a trick to it?