I was able to fix my problem by rechecking my query and making sure all the single quotes got partners...a part of oversight 🙂

may i know how you fixed it? im having the same...

nope, it will just add the new server. All the other target servers should already be enlisted.

do you need the sql browser at this point? maybe you can disable this service if your objective is to make sql service start and run?

sound like object permission issue.

You just need to add and enlist the new target server that you have.

what were the results of your initial investigation? have you checked the logs in sql and in windows?

I have written an article about this, maybe it could help

Currently, I'm doing a reviewer series on this MCSA exam for SQL Server 2012. I am also keen on upgrading my certification of MCITP SQL Server 2008 to MCSA SQL...

Have you tried to open resource manager in your server? All the current running services you can see here and memory being used.

+ 1

Also summarized this in my blog post http://coffeeandsql.com/2013/07/11/access-denied-on-your-ssis-sql-server-2008/

don't forget also in your stored procedure to add the following statements

SET NOCOUNT ON/OFF

SET XACT_ABORT ON/OFF

Maybe related also to your access rights on the server.

did you say "while installing"? You only need to attach this database file to your installed SQL Server. Remember to remove the attachment for log file and you should be...

i think everyone is correct in saying don't let the developers do the backup in the first place.

I also had this same scenario way back. Our domain admin needed to do something in the AD, something to do with policy, then he asked me restart my sql...