Post reply

Cannot view SQL jobs as sysadmin

  • February 6, 2003 at 6:40 am

    #80205

    I've got a NT user who is a member of the LocalSQLAdmins group on a 2000 server. This LocalSQLAdmins group has the sysadmin role on SQL server. Other members of this group are able to view SQL agent jobs except for one particular user. Is there something I should look for that would cause this user to not view jobs?

    Thanks,

    Marco

  • February 6, 2003 at 7:31 am

    #448209

    Is this particular user's NT login be granted to access SQL Server without 'sa' right outside the LocalSQLAdmins group in your SQL Server?

  • February 6, 2003 at 7:52 am

    #448213

    There is a SQL server login for this user without "sa" rights. Would that cause this problem?

  • February 6, 2003 at 8:21 am

    #448222

    I don't think SQL Server login (SQL Server authentication) has effect to him but if the login is NT login (NT authentication) and I would say yes.

    Can you run sp_helplogins and indicate which login is the one?

    Edited by - Allen_Cui on 02/06/2003 08:29:55 AM

    Edited by - Allen_Cui on 02/06/2003 08:31:14 AM

    Edited by - Allen_Cui on 02/06/2003 08:42:09 AM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply