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 |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2007-02-15 : 11:43:12
|
| I did setup a backup job from maintenance plan, but it doesn't run and checked the error log, it show following.[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\MYNAME', error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)I'm the sysadmin for the sql serverany idea?Thanks! |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-02-15 : 12:35:37
|
| is your authentication set only to SQL SERVER? You may be the sysadmin, but is that your NT LOGIN or a standard login? |
 |
|
|
mapperkids
Yak Posting Veteran
50 Posts |
Posted - 2007-02-15 : 13:03:56
|
| My ID is set as sysadmin on SQL server, but not the NT domain. |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-02-15 : 13:24:06
|
| Are you logging in with a domain account or mapperkids with SA privileges?There is no role as System Administrator in NT Domain, you are possibly saying you are not a domain admin...And your SQL Server has what sort of authentiction? |
|
|
|
mapperkids
Yak Posting Veteran
50 Posts |
Posted - 2007-02-15 : 14:42:17
|
| The SQL server is using windows authentication mode only and my ID is not a system admin on NT domain, but in SQL server, my user id is under the Security->server roles-> as sysadmin, setupadmin, serveradmin, processadmin,So I think that can let me do anything inside the SQL server or not?Thanks! |
|
|
|
mapperkids
Yak Posting Veteran
50 Posts |
Posted - 2007-02-16 : 19:18:03
|
| Hi,Today I tried to ask the NT admin to login the SQL server and setup a scheduled job to check the shrink the db for testing purpose. Then the job start and got the same 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! |
|
|
|
|
|
|
|
|
Job agent question?