Find Your SSRS Target Server URL

If you are looking to deploy your SSRS (SQL Server Reporting Service) reports directly from Visual Studio you will need to set the Target Server URL in the Properties of your project in the deployment section.  The trick here is that this is not the URL for your Report Manager. What you are in fact… Continue reading Find Your SSRS Target Server URL

SSDT – Pre and Post Deploy Script Markers And Flava Flav

I admit, this post is primarily to provide a place for me to copy and paste my own code, but it's so sweet I figured some of you other SQL Server Data Tool Users might find it handy. When troubleshooting the generated deployment scripts I've always added a PRINT statement to indicate the beginning and… Continue reading SSDT – Pre and Post Deploy Script Markers And Flava Flav

SSDT – The object reference differs only by case from the object definition warning

Well here's a Visual Studio SQL Server Data Tools (SSDT) warning I haven't come across before. I suspect the problem occurs only when performing a join to an external database reference dacpac. Luckily, the fix is simple (although a bit time consuming if you have very many of these warnings). First, the warning message will… Continue reading SSDT – The object reference differs only by case from the object definition warning

SSDT VS 2012 – Bringing an existing database under source control

Alright! You are the hero of your database team! You've received the okay to start using SQL Server Data Tools to manage one of your existing databases. You think to yourself: "Within a few minutes I'll have the project up and running and I can move on to phase 2 of my plan to save… Continue reading SSDT VS 2012 – Bringing an existing database under source control

Where is vsdbcmd.exe in Visual Studio 2012!?!

Looking for your old friend vsdbcmd.exe in visual studio 2012? There's good news and bad news. The bad news is it's gone and it's not coming back. (see this MSDN thread if you don't believe me). The good news is there's a replacement: sqlpackage.exe The path for sqlpackage.exe is typically: C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin… Continue reading Where is vsdbcmd.exe in Visual Studio 2012!?!

Handrawn SAFe Agile Doodlegraphic

A few years back I remember ready an article saying that people who doodled while listening to a lecture retained more information than those who did not doodle. With two solid days of training on the Scaleable Agile Framework (aka SAFe) I thought it might be a good idea to give it a try. Then… Continue reading Handrawn SAFe Agile Doodlegraphic

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… Continue reading SSRS Subscription Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.

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… Continue reading Change The Owner Of An SSRS Subscription: The Simple Way

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… Continue reading Preventing Failed SSRS Subscriptions: Which user created your subscriptions?

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… Continue reading Solution! SSIS Error: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender