Re: Agent job owner/visibility

From: Vern Rabe (VernRabe_at_discussions.microsoft.com)
Date: 07/27/05

  • Next message: lleonard: "Machine account access" 
    Date: Wed, 27 Jul 2005 08:50:09 -0700

    Uri:
    Yes, we have a login to SQL Server for that Windows Domain Group. I don't
    believe the login is in any fixed server roles.

    I may have separately found the solution, however. I have requested the DBAs
    to add the login to the TargetServersRole in the msdb database. Haven't
    tested yet (or even gotten their approval to do it), so we'll see.

    Thanks
    Vern

    "Uri Dimant" wrote:

    > Vern
    > Has this Windows Domain Group a login to SQL Server?
    >
    > What are permissions to the login?
    >
    >
    >
    > "Vern Rabe" <VernRabe@discussions.microsoft.com> wrote in message
    > news:DA097453-1559-45B5-BB2C-E45A3180DA3F@microsoft.com...
    > > Windows 2000, SQL Server 2000 SP 4, Windows Authentication. We have
    > > several
    > > developers, all in a Windows domain group, and when one developer creates
    > > an
    > > Agent job, that job is owned by that one developer and is not visible by
    > > the
    > > other developers. Is it possible to have a job be owned by a login that
    > > corresponds to a Windows domain group? The Owner dropdown in EM seems to
    > > indicate it's not possible, because no groups (domain or local) are
    > > listed.
    > > We are not in the sqladmin group, nor in the local Windows Administrators
    > > group.
    > >
    > > Thanks
    > > Vern Rabe
    >
    >
    >

  • Next message: lleonard: "Machine account access"

    Relevant Pages

    • Re: Agent job owner/visibility
      ... Has this Windows Domain Group a login to SQL Server? ... > developers, all in a Windows domain group, and when one developer creates ... > We are not in the sqladmin group, nor in the local Windows Administrators ...
      (microsoft.public.sqlserver.security)
    • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
      ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
      (microsoft.public.sqlserver.connect)
    • Re: cannot acees two databases as owner
      ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
      (microsoft.public.sqlserver.setup)
    • Re: Database security design with ASP.net and form-based authentication
      ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
      (microsoft.public.sqlserver.security)
    • Re: Credentials not being passed with remote access
      ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
      (microsoft.public.sqlserver.security)