You may want to check the following KB article:

FIX: Slow performance when you run the SSIS Server Maintenance Job to remove old data in SQL Server 2012

https://support.microsoft.com/en-us/kb/2829948

Sue

Jon Brune (8/22/2016)

---

Longtime SSIS 2005 user, but new to 2012 and the SSISDB catalog, and so far, not really a fan. I have an SSIS job that is called...

Setup package logging and what are the details of the error in the logs? When executing what type of task?

It seems like it might be a bit too vague...

You also need to enable Allow In Process for the provider. May not completely resolve the issue but you need that enabled as well.

Sue

Usually that will work. You'd generally want to work through this with whoever is managing the network since it does impact that area. You can find some tips about using...

I hope the additional steps include some bench marking and baselines for the system resources when doing this as several other things take a hit when you do this. CPU,...

Don't think you want to do that as already stated. It's mostly a reflection of the thread pool settings and the settings have so many dependencies it's not recommended to...

I've seen them before when there are issues with an app using SQLDependency. I would guess they could come from other apps using Broker services as well. You'd want to...

Are you logged onto the server itself as an administrator when trying to change this?

Sue

Guess I was incorrectly thinking that the error "A connection was successfully established with the server, but then an error occurred during the login process" with another SQL Server error...

Interesting...and no errors in the connectivity ring buffers in dm_os_ring_buffers. New twist on security maybe.

I would guess this might be the updates for TLS1.2 and then needing to update...

It's doable but there are oddball issues that come up like yours. In some cases, I've seen where just adding set nocount on for the procedure or query has cleared...

The error is thrown by the named pipes provider. Are the same protocols enabled on all the clients in the scenarios?

The order also matters. On the client computers, try...

It sounds like it's the issue listed here even though it's only been reported through version 2012:

https://connect.microsoft.com/SQLServer/feedback/details/539703/access-denied-attaching-a-database-when-permissions-are-inherited

Read through all the comments though as I am not convinced it's...

You are very welcome. If your on the admin side of SSRS and new to it, get familiar with the Reporting services log. That helps a lot in troubleshooting issues....