Re: Could not save on existing DTS

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: The Margolins (margolin_at_optonline.net)
Date: 05/06/04 

Date: Thu, 06 May 2004 17:31:06 GMT

Make them members of dbo role in msdb.

"SangHun Jung" <anonymous@discussions.microsoft.com> wrote in message
news:6CA2F4EB-60D8-43BD-8BE9-4BFF96C147C7@microsoft.com...
> Once we moved to Active Directory domain (let's call BBB domain) from AAA
domain, all developers could not modify existing DTSs even though they were
owner of the DTSs (AAA domain). They get error saying you are not in
sysadmin role so you could not modify. They can create new DTSs on server
though.
> I can not just simply give them system admin role on SQL servers to solve
this issue. Any suggestions would be appreciated.
>
> SangHun Jung

Quantcast