Hi AlphaTangoWhiskey

The Database ownership is actually really interesting question.  Since the SSISProxy Account is creating the database, it does indeed become the owner of the database

both the script

            
April 11, 2019 at 10:36 am
            
#3120150

            
            
                                                
        

Thanks Eric - that Server Roles Venn-Diagram on the MS Docs link is really useful - had been searching for something like that

The SSISProxy has been granted the server dbcreator...

Thanks, is this also compatible with vs2013

Hi did you ever get a solution to this. I have exactly the same problem and scenario

I want the Developer to be able to schedule their own jobs, but...

Perfect thanks jon, set full permissions for the account to the \MSSQL\Log folder and the service started successfully

Thanks

Simon

Thanks worked perfectly selected process clear from Ssms and re-ran the process full and it ran through completely this time

Brilliant, Thanks Jared

Thanks Ashish,

Good point on the Backup v Attach/Detach

I just wondered whether there may be a quick way of transferring the packages, but I guess it's not that much effort...

I have managed to resolve this issue by adding the account runnning the subscription on Londonbi1 (subscriber server) to the list of accounts on the Publication Access list on Londonsc1...

Hi Kmil, which version of Robocopy are you using - the return code varies with the version - if you are using XP010 which is the version in the Windows...

No problem Ravikumar,

Joseph, I'm afraid I never solved this problem, I adopted a completely different approach to my solution that didn't involve distributed transactions. I have also moved jobs...

Many Thanks for that Crispin, I thought it might be the case, but it's good to get it confirmed. I have just moved to a new organization and inherited a...

Thanks for that Gail

Hi Gail, saw your reply to this thread, does this mismatch between the metadata and the physical allocation have any impact any the data resturned by any operations on the...

Hi anurags99

Let me know if I'm teaching you to suck eggs at any time.

To enlist MSDTC on your target machine you will need to set some options...