Thanks both. I have logged it with WRC.

Oddly, if i click the "HealthShare" option from portal i get a couple of zen error dialogs, at which point the link strip at the very top of the page changes and shows a "Ensemble Management" option. Clicking that then shows me the menu i was expecting to see when selecting "Ensemble".

Hi, thanks for replying.

I was a little too vague in the initial question. I have already given the role the below permissions, in addition to the database resource:

If i use a direct link to the production (i.e. EnsPortal.ProductionConfig.zen) i can get in, and see the production ok. I just can't navigate to it from the Management Portal landing page.

That did the trick, thanks.

Hi, thanks for the reply.

{ts} only seems to work with literal values, not with columns. So the following query errors:

select %nolock top(1) datepart('hh', {ts TimeCreated}) 
from Ens.MessageHeader