Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-26 : 10:12:32
|
| Ray writes "Hi,I tried to ask the NT admin to login the SQL server and setup a scheduled job to "Shrink the db" for testing purpose.I tried my ID even I'm not the NT admin, but setup as SQL server as sysadmin, setupadmin, processadmin.Then the job start and got the error. [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\MYNAME', error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)I have no idea why that happen to NT admin. then I check the Services for SQL Agent under the control panel- admin tools- services.It shows using the LOCALSYSTEM as login for the SQL Agent service.Any one have any idea. what security requirement to run a job other than use 'sa' account, since we are using on Windows authenciation mode only.I must be something is missing? hope some experts here to answer my question.Thanks!" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-02-28 : 13:41:57
|
| i'm not an expert but if you're on windows authentication i suggest you change the service account for sqlserveragent service to an nt service account, likewise for the sqlserver service as well--editi was making assumptions, the service account should be sysadmin on the server if you've switched to windows authentication--------------------keeping it simple... |
 |
|
|
|
|
|
Who can run the server scheduled agent Job?