-
SSRS Subscription Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.
So, when a SQL Server Reporting Services subscription gives you an error message like: “Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.” You know exactly what to do to fix it right? Just fix the so called “configuration error”. Problem solved! Another day another dollar. Am I…
-
Change The Owner Of An SSRS Subscription: The Simple Way
So you need to change the owner of an SQL Server Reporting Services subscription? No problema. (Why would you need to change it you might ask? Perhaps because you have deactivated the user account that created the subscription and now “strange things are afoot at the Circle K”, and if you know that reference please…
-
Preventing Failed SSRS Subscriptions: Which user created your subscriptions?
Check it out my friends. You need to keep an eye on which accounts are creating your SSRS subscriptions. Why? Because buried inside the ReportServer database (with no way to change it from the front end) SQL Server Reporting Services is keeping track of this information. And when one of those user’s account is disabled strange…
-
Solution! SSIS Error: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender
While running a 2012 SQL Server Integration Services package, the package ended up failing with the following message: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: “Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender”. The quickest and…
-
DAX Formulas To Know And Love
PowerPivot this. PowerPivot that. Blah, blah, blah. Sorry folks, I don’t have time to learn your new Excel plugin because I’m writing SQL! I’m hardcore! Well, I finally started using PowerPivot a few days ago and I’m pretty impressed (although I seem to be able to make Excel crash pretty frequently). So I’m starting a…
-
We Don’t Need No Duplication: Eliminating the Visual Studio “Do Not Ignore Duplicate Key errors” warning.
So when I open up a SQL Server Analysis Services Project in Visual Studio and it gives me the warning “Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration so that it is not set to IgnoreError.” I thought to myself: “That’s a good idea.” I ought to do that.…
-
Resolving Analysis Services “The provider ‘SQLNCLI.1’ is not registered”
I know. While everyone else is moving on to SQL 2012 here I am upgrading a SSAS 2005 cube to SQL Server 2008 R2 Analysis Services. I can hear Garth imploring me to “Live in the now man!” So as I went about the mundane task of upgrading a cube from a really old version…
-
SSRS: A Hidden Tablix That Won’t Hide And Wham!
Here’s a real quick tip after banging my head against the desk for awhile. I had a tablix in SSRS that was supposed to be hidden if there were no rows. It was working fine until, wham, it stopped working. (Oh no. I said “wham”. That obviously leads me to “Wham!”. I had my mom…
-
It all comes back to the work that occurs behind the curtain…
Couldn’t have said it better… RT @lanier: “80% of #datascience is infrastructure; 20% is the fun stuff—charts etc.” – @opower at #strataconf — Michael Cavaretta (@mjcavaretta) October 24, 2012