Hi Andrey,

Thanks for the reply, and apologies for not replying earlier, end of financial year activities have kept me busy.

I have played with config files and memory settings but to...

• This reply was modified 5 years, 5 months ago by  kazim.raza. Reason: corrected name of the previous poster

And, yes, there are lot of report calls, on demand / manual reports, subscriptions (periodic), PBI calls etc. However; SSRS 2014 seems to be working fine, relatively, with the limitations...

• This reply was modified 5 years, 6 months ago by  kazim.raza.

Hi Lowell,

Thanks a lot for your reply. And, excuse me, I forgot to mention the differences, and infrastructure side of things.

My infra team tells me that SSRS 2017 environment is...

Thanks for the reply Thom. 

I tried creating a new data source from scratch, and got the same error, "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.". I...

My data source is on another server, SQL Server 2014 instance, and this data source does not work with Integrated Windows Security. I don't get to the point of executing...

Absolutely, very little difference. Now I am kinda lost..too.

Please receive the updated plan, it is the actual plan (I selected the include actual exec plan). I do see a lot of operators in this plan too, so what's...

Thanks for the template, Rich. This would be very useful for me, specially, since I tend to forget the syntax.

Scope_Identity() did the trick for me, I am wondering to myself how come I missed it..

Regards,

Kazim Raza

I agree with you on the key look up bit, I did widen the index making it to cover all those attributes that were being hit.

Can you refer me...

Machine name\instance name did the trick for me. I wonder if this is because I do not have it installed with the default instance name.

You should have clarified the data source, it would not have taken you a lot of debugging. You can get the data into your tables through import/export data option. You...

Paste them all in one query window and hit execute, it would create them all in one go. You would want to arrange the sequence of the scripts though to...

Chris, I won't be storing the PDF file itself in the database. Sections in the PDF I posted and their data are segmented / stored separately within the DraftContent Table...