February 27, 2006 at 8:46 pm
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
February 27, 2006 at 11:48 pm
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://qa.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.asp
March 1, 2006 at 11:34 pm
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