All SQL Jobs are failing

  • Hi,

    In my production server some one has changed the SQL server service account to "Local system". But my SQL agent service is running under a domain account in whose user contex all jobs are created. As a security measure we have removed BUILTIN\Adminstrators login from the server.

    If i see the job history it says "Login failed for BUILTIN\Adminstrators".

    Can any one tell me why it is trying to use "BuiltIN\Adminstrators" user account?

    Thanks in advance

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • You will need to allow the LocalSystem account the appropriate logon rights to SQL Server. To achieve this, do the following:

    ' The LocalSystem is known as [NT Authority\System] for SQL Server

    ' and it needs logon rights

    EXEC sp_grantlogin [NT Authority\System] 

    ' Make it a member of the sysadmin role

    EXEC sp_addsrvrolemember [NT Authority\System] , 'sysadmin'

    More info can be found in this very good article:

    http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.asp

     

  • this means that the user is trying to access the server via windows authentication and on the server itself...

    or help us, he's using the "builtin\administrators" as user in the login window for sql authentication

    ha ha ha!

     

    HTH

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

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