Have you restarted the Agent service since you told it which mail profile to use under the Alerts system properties?

Strange then as if your an admin you shouldn't need to mess with DCOM.

Will keep digging once I have a spare moment here and there but as never running into...

Have you tried this one

http://sqlbuzz.wordpress.com/2011/12/07/connecting-to-the-integration-services-service-on-the-computer-mirrorstand-failed-with-the-following-error-access-is-denied/

Might be that 2008 R2 creates the MsDTSServer100 DCOM object and 2008 creates the MsDTSServer as I have both in my DCOM as I have both...

ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Can you post a screen shot of the error?

I've never had this issue so would be good to see what you see in case its something else other than DCOM.

Any firewalls between the clients and the servers? Are you connecting to a cluster?

Microsoft SQL Server Integration Services 11.0 is SQL 2012.

I take it your looking at the MSDN article on Connecting to a Remote Integration Services Server?

If so it looks like you've...

Well deny backup wont work then if the account is sysadmin, as if your a sysadmin even explicit denies do not take precidence.

Express has a 1GB memory limit, so are you talking memory as in RAM or are you talking memory as in storage?

First off, why no backups? System database are just as important to backup as your user backups. Please tell me you backup your Master database at least?

Second on...

Yes, same issue as what Shell has reported. The Sharepoint crawler was running indexing the sharepoint sites at the same time the database was being backed up, causing the...

You cannot improve the performance.

As I have said, what you are doing is very intensive and will take time to execute.

The best whole database string search query I have seen...

Do you have backups of MSDB going back 1 month? If so restore it as a user database, then query sysjobhistory via script.

If you do not have...

Abu Dina (11/20/2012)

---

Thanks Tony.

I have more questions sorry! if anyone can point me in the right direction I'd be eternally grateful!

1) The new box will not have any locally installed...

Not being stupid right to raise your concern but them accounts are created for the service regaurdless of the account which runs them. It does this so that you...