Business intelligence templates in vs2017

Uninstall & reinstall ssdt. On reinstall only choose integration services – leave others blank.



HTTP Error 502.5 – Process Failure

Not going to rehash what everyone else did.  Shout out to Ahmed [and everyone else who does the same as him, but we’ll use Ahmed because I like his post best]:

He does a great job telling us what to do. I’m going to say what I did.  After Ahmed’s instructions on how to enable logging, it still refuses to write a debug log.   Event viewer said the large negative number which translates to the hresult “80004005”: access denied.

No prob; simply cacls c:\path\logs /T /G “Authenticated Users”:F

Then the log gets created nicely.   And it tells me the same thing it told Ahmed; wrong .net version.   I thought I could install that framework on my development box, and it would be brought along when I deploy.  That is an incorrect assumption.

What you need to do is install that framework on your target box, manually.   I am deploying to an Amazon hosted cloud server, not Azure.  I assume you Azure folks will be the same –  simply copy the .net framework install to your target box to install locally, or incorporate that framework into your base image you use to create your box.

Get rid of those awful nuget packages

Restoring NuGet packages…

To prevent NuGet from restoring packages during build, open the Visual Studio Options dialog, click on the Package Manager node and uncheck ‘Allow NuGet to download missing packages during build.’