Re: SQLAgent Jobs Not Available after SP4 Applied
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 05/20/05
- Previous message: Jason Delaune: "SQLAgent Jobs Not Available after SP4 Applied"
- In reply to: Jason Delaune: "SQLAgent Jobs Not Available after SP4 Applied"
- Next in thread: Jason Delaune: "Re: SQLAgent Jobs Not Available after SP4 Applied"
- Reply: Jason Delaune: "Re: SQLAgent Jobs Not Available after SP4 Applied"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 20 May 2005 08:49:38 +0200
Hi
Have you applied the SP4 to their developer machines also. The tools have
had updates.
Are you using any un-documented SP and XP's? Microsoft has added a lot of
security on this when the user is not in the sysadmin role.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jason Delaune" <JasonDelaune@discussions.microsoft.com> wrote in message
news:EFBEA7FC-E269-4A4F-BFCA-46B0A16AAE6D@microsoft.com...
> Hello all,
>
> I have created a generic user for our developers to use as the owner of
> the
> SQL Server jobs they create. This way all developers can use a generic
> account to manage the jobs they create so that all developers can easily
> see
> each other jobs. For the jobs that required administrator access, we setup
> a
> proxy account. This all worked great when our server was running SP3a.
>
> We recently applied SP4 to the server and now we are receiving all kinds
> of
> permission problems. Now when our developers what to see the jobs using
> the
> generic account (job owner) they get errors about permissions denied to
> the
> xp_sqlagent_* extended stored procedures as well as various other xp_*
> extended stored procedures within the master database.
>
> What has changed with SP4 that would cause this problem? And what's the
> easy
> way to fix it other than making the generic account dbo within the master
> database?
>
> Thanks,
> Jason
- Previous message: Jason Delaune: "SQLAgent Jobs Not Available after SP4 Applied"
- In reply to: Jason Delaune: "SQLAgent Jobs Not Available after SP4 Applied"
- Next in thread: Jason Delaune: "Re: SQLAgent Jobs Not Available after SP4 Applied"
- Reply: Jason Delaune: "Re: SQLAgent Jobs Not Available after SP4 Applied"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
