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 |
|
MGouders
Starting Member
30 Posts |
 Posted - 2009-09-08 : 17:10:13
|
| Hi,A job assigned to run an SSIS package fails returning the following error message:Unable to determine if the owner (yourGroup\yourUserID) of job yourJobName has server access (reason: Could not obtain information about Windows NT group/user '\yourUserName', error code 0x5. [SQLSTATE 42000] (Error 15404)).Any help is appreciated,Mike |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MGouders
Starting Member
30 Posts |
Posted - 2009-09-10 : 10:54:45
|
| Hi tkizer,Thanks for your contributionSpeaking with the system engineering group it was brought up to me that the sql dba team are working on sql server delegation using Active Directory and changing the job owner to a default user would solve the problem. They are not using sa but rather one with specific rights for their environment.Mike |
 |
|
|
|
|
|
server access cannot be determined