wrvishnu,

I don't know how to generate the actual hash other than using the SSRS front end once time, then looking up the hash that was generated. For our shop...

UPDATE:

I had counted on the XML elements in the ExtensionSettings field to always be in the same order. Today I discovered that this isn't always the case. ...

Ah, I see...yes, it works for regular and data-driven subscriptions.

~wz

Which two flavors do you mean? (Email delivery extension doesn't require credentials)

~wz

Hey Grasshopper,

Thanks for asking. Yes, you are correct- you'll enter the hashed value for both the UN and PW, not the 'human legible' versions :-).

At our shop, we use a...

This code works well- it's also cleaner, since I've now been learning better how to deal with XML.

SELECT

SubscriptionID

,CAST(ExtensionSettings AS XML) ExtensionSettings

INTO #Subscriptions

FROM dbo.Subscriptions

WHERE DeliveryExtension = 'Report Server FileShare'

UPDATE #subscriptions

SET...

Update: the above code works beautifully with standard subscriptions, but is not robust enough to handle data-driven subscriptions.

Our company had never used data-driven subscriptions until the past few weeks, and...

Glad to help!

No problem-

Keep in mind that the username and password are stored in XML datatype as a hash value. I obtained the hash values for the execution account's Username and...

Hi everyone,

I was researching this exact scenario ...how to handle the expiring password problem and found this thread. I'm a bit late to the game, but I've found a...