Post reply

SQL Agent account Issues

  • August 20, 2009 at 6:24 am

    #95761

    1. I have created windows user account for example user name is "A", after that set this "A" user member of Administrators windows group.

    2. Go to the both sql services are MSSQLSERVER and SQLSERVERAGENT, these services are runing under "A" windows user account.

    3. For the security purpose i had set option of deny for Builtin\Administrators and remove the system administrators role from sql server enterprise ->security->logins.

    4. After that Mssqlserver service runing fine, but an Agent services does not running,

    can anyone tell me, how to resolved sql agent services. if i go back enable option of grand Builtin\Administrators and set system administrators role sql agent services running fine.

    Thanks in advance

  • August 20, 2009 at 11:33 pm

    #1042604

    Sql server agent could not running on under windows account, after delete or deny builtin\administrators from sql server 2000.

    How to resolve this issues?

    thanks

  • August 24, 2009 at 7:10 am

    #1043599

    Hi,

    Check out this article. http://www.sqlservercentral.com/articles/Security/removingthebuiltinadministratorssomepitfallstoavoi/1661/

    Thanks

    newbie2sql

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

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