that is, as far as I can see, an older paper.

Visual Studio Subscriptions (formerly MSDN subscriptions) - latest licensing whitepaper here.

from it

Different Licensed Users Can Run the Same...

Quick thing about MSDN licensing - End users who are doing acceptance TESTING do not require a license.  To quote Microsoft's licensing terms:

Acceptance Testing and Feedback. Your end users may...

This would probably be written better as an "IF" statement rather than a CASE... something along the lines of:

IF EXISTS (SELECT 1 FROM [ITRM_ITBF].[Dflt].[MANUAL_LSV_PERMISSIONS] WHERE USERNAME =...

Blanks are a bit harder to deal with.  One way would be to add a UNION onto the query... something like:

UNION
SELECT NULL
WHERE NOT EXISTS(SELECT 1
FROM <table>
WHERE SSN...

My preference is to avoid maintenance plans wherever possible.  I have run into issues with them and when a problem comes up, it can be tricky to reproduce and debug. ...

I've not used developer edition, but we also run SQL Server Standard at my workplace.  I am just offering a different option: Visual Studio subscription licensing for your test/dev environment.  Everyone...

Hello JSB_89,

Have you checked the logs?  That would be my first step.  Check PBI logs and IIS logs and windows event logs.  One of them should have something useful in...

Your max memory is set way too high.  I would drop that down to a more reasonable value.

As Frederico_fonseca said, you should have at LEAST 1 GB free for the...

Looking at the log it says it out of memory.  "Memory allocation failure".  You need more memory on your VM or need to allocate your memory differently.

As a thought, do you have a linked server on Server1 that points back to Server1?

If this is a manual process of extracting the data to CSV, you could probably do a find-and-replace in the CSV.

If you are using a tool (SSRS for example), you...

The link in the whitepaper seems to be broken :(.

• This reply was modified 5 years, 9 months ago by Mr. Brian Gale. Reason: fixing mistake (article vs whitepaper)

Not looking through the logs sounds like you don't really want to find out what caused the problem.  That is what the logs are there for.  Without finding the cause,...

My best guess as to why it suddenly broke is that something changed on your system.  Could have  been a windows update, a sql update (although those are both unlikley),...

To address the security certificate message, that is semi normal.  Computers generate a certificate to be used for RDP connections.   It is used to encrypt the connections.  It should have...