Thank you so much for not only the solution but also for the link.

I am very grateful for both. I will sleep easier tonight.

Thanks,

Nic

Hi SQL Sarah,

Thanks for this, my concern was someone may have used BIDS/SSDT and had a report model data source, it seems this isn't the case so as you rightly...

Hi Sql Sarah,

Thanks for the reply. The type is very useful but what I'm actually trying to do is for all the type 2's determine which are Report Builder built...

Hi,

That seems to have done the job nicely.

Thank you very much, Querying XML is a bit of a dark art to me so you've made my life far easier.

Nic

Exactly, I thought the wording was a misleading here, as it can be...

I think I'm going to just get the user to run it via the T-SQL script, saves me either giving them admin rights or going through a painful trial and...

Hi,

I think you've got something there.

If I add the user to the master database, but not a member of any role then I get the same error back but instead...

Interesting (but more confusing).

It works when done via T-SQL but not via SSMS UI.

Really confused now.

By the UI, I'll try doing it via T-SQL now.

Hi,

No that didn't work, just to confirm what I did then;

I added the account as a login on the instance, removed it from the AD group. Then granted the account...

Hi Bob,

No luck.

So what I did was to grant permissions on the folder to the following;

1. The service account of SQL Server.

2. The service account for SQL Server agent (it's...

Thanks for this, I'll give it a try in the morning and let you know how I get on.

Nic

Thanks Uwe.

Regards,

Nic

Hi,

Thanks for getting back to me on this.

So suffix searches are not supported, makes sense as it would have to index just about every possibility and would result in a...

Hi,

I've managed to resolve the Report Builder issue, turns out the Report Server didn't have the language pack for IE installed.

Installing the issue resolved the issue with the format.

I've...