Sql-server – Windows Managed account to report subscription file share

sql serverssrs

Is it possible to used a Windows Managed account to access a file share in a Report subscription?

When creating a Windows file share report subscription, on Step 4 – Create a data-driven subscription, I must specify the Username and Password of the account which has access to the file share. Can this be a Windows Managed Account and if so, what do I specify for the password to get the field to validate and allow me to move to the next screen?

Best Answer

Ok, I have not messed with the file share subscriptions so I had to set this up locally on my machine to mess with it. The only thing I can even come across in MSDN that talks about the username for this type of subscription is here:

Password: Specify the password for the Windows user name.

Out of that the only thing I can find is that it requires an actual user account with password. So it is not possible to use virtual or managed account.

enter image description here

The only way I could get this subscription to write to the UNC path was to enter a Windows User account. In this instance my own login. I was just running an example SSRS report against AdventureWorks2012 database.