|
|
|
| I created a job on SQL 2005 - logged in using Windows domain user. And I get
the following error message. Any clue to fix it?
Message
The job failed. Unable to determine if the owner (Domain1\nick) of job
test_job_1 has server access (reason: Could not obtain information about
Windows NT group/user 'Domain1\nick', error code 0x5. [SQLSTATE 42000] (Error
15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).
| |
|
| You're using domain acct, so sql will need to contact the domain controller
to validate the acct. Check to see if there is a DC available for
authentication.
Do you get an error if you use a sql acct as the job owner?
--
-oj
"nick" <nick@discussions.microsoft.com> wrote in message
news:51F93238-10FD-4E93-80C5- 46833A206CD1@microso
ft.com...
>I created a job on SQL 2005 - logged in using Windows domain user. And I
>get
> the following error message. Any clue to fix it?
>
> Message
> The job failed. Unable to determine if the owner (Domain1\nick) of job
> test_job_1 has server access (reason: Could not obtain information about
> Windows NT group/user 'Domain1\nick', error code 0x5. [SQLSTATE 42000]
> (Error
> 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).
>
| |
|
| SQL account works fine. Only domain account cause the problem. I cannot
create linked server use domain account too. (my domain account can access
both servers from my workstation).
How to config the domain/Ad to enable it?
"oj" wrote:
> You're using domain acct, so sql will need to contact the domain controller
> to validate the acct. Check to see if there is a DC available for
> authentication.
>
> Do you get an error if you use a sql acct as the job owner?
>
> --
> -oj
>
>
>
> "nick" <nick@discussions.microsoft.com> wrote in message
> news:51F93238-10FD-4E93-80C5- 46833A206CD1@microso
ft.com...
>
>
>
| |
|
| suddenly even sql account get the following error:
Message
Executed as user: nick. Access to the remote server is denied because the
current security context is not trusted. [SQLSTATE 42000] (Error 15274). The
step failed.
"oj" wrote:
> You're using domain acct, so sql will need to contact the domain controller
> to validate the acct. Check to see if there is a DC available for
> authentication.
>
> Do you get an error if you use a sql acct as the job owner?
>
> --
> -oj
>
>
>
> "nick" <nick@discussions.microsoft.com> wrote in message
> news:51F93238-10FD-4E93-80C5- 46833A206CD1@microso
ft.com...
>
>
>
| |
|
| Hi,
are you in a one domain scenario ? Make sure that the password of the
domain account isn=B4t expired or the accoutn was deleted or the account
was disallowed to run in the needed priviledged context.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
|
|
|
|