Could not obtain information about Windows NT group user

Raj More picture Raj More · Aug 5, 2009 · Viewed 99.1k times · Source

I am creating a SQL Server Replication using a script. When I try to execute

The job failed. Unable to determine if the owner (STAR\moorer7) of job L3BPT2M-Atlas-14 has server access (reason: Could not obtain information about Windows NT group/user 'STAR\moorer7', error code 0x5. [SQLSTATE 42000] (Error 15404)).

This is a job created by a script that defines replication.

How do I debug this?

Answer

Remus Rusanu picture Remus Rusanu · Aug 5, 2009

Active Directory is refusing access to your SQL Agent. The Agent should be running under an account that is recognized by STAR domain controller.