We recently converted our NT 4 domain to Active Directory, and jobs started
failing with messages like the following. Evidently, SQL Server is having
trouble verifying the credentials of the job owner:
The job failed. Unable to determine if the owner (<Domain>\<user> ) of job
<JobName> has server access (reason: Could not obtain information about
Windows NT group/user (<Domain>\<user> ) '. [SQLSTATE 42000] (Error 8198)
).
I see there are KB articles talking about pre-2000 compatibility, but both
the domain controller and the SQL Server machine are running Windows Server
2003. Does anyone know how to fix this?
(Yes, you can change the job owner as a workaround, but this won't keep
future jobs from being owned by Windows users unless we switch everyone over
to SQL authentication)
Thanks.Check this kb;
825042 FIX: SQL Server Jobs That Are Owned by Non-sysadmin Users May Not
Start
http://support.microsoft.com/?id=825042
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Showing posts with label owner. Show all posts
Showing posts with label owner. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
error 7410
I get the following error when i try to run a query on a linked server.
Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared
SQLSTATE
HY007 (Error 0). The step failed.
any good ideas on how to solve?
Hi!
Do please check http://support.microsoft.com/kb/823429 and
http://support.microsoft.com/default...;en-us;834116.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Fab" <flazzaro@.tac.infostream.ca> wrote in message
news:%23pS25NcfFHA.2372@.TK2MSFTNGP14.phx.gbl...
>I get the following error when i try to run a query on a linked server.
> Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
> statement. SQLSTATE 42000 (Error 16805) Associated statement is not
> prepared SQLSTATE
> HY007 (Error 0). The step failed.
> any good ideas on how to solve?
>
>
Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared
SQLSTATE
HY007 (Error 0). The step failed.
any good ideas on how to solve?
Hi!
Do please check http://support.microsoft.com/kb/823429 and
http://support.microsoft.com/default...;en-us;834116.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Fab" <flazzaro@.tac.infostream.ca> wrote in message
news:%23pS25NcfFHA.2372@.TK2MSFTNGP14.phx.gbl...
>I get the following error when i try to run a query on a linked server.
> Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
> statement. SQLSTATE 42000 (Error 16805) Associated statement is not
> prepared SQLSTATE
> HY007 (Error 0). The step failed.
> any good ideas on how to solve?
>
>
error 7410
I get the following error when i try to run a query on a linked server.
Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared
SQLSTATE
HY007 (Error 0). The step failed.
any good ideas on how to solve?Hi!
Do please check http://support.microsoft.com/kb/823429 and
http://support.microsoft.com/defaul...b;en-us;834116.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Fab" <flazzaro@.tac.infostream.ca> wrote in message
news:%23pS25NcfFHA.2372@.TK2MSFTNGP14.phx.gbl...
>I get the following error when i try to run a query on a linked server.
> Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
> statement. SQLSTATE 42000 (Error 16805) Associated statement is not
> prepared SQLSTATE
> HY007 (Error 0). The step failed.
> any good ideas on how to solve?
>
>
Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared
SQLSTATE
HY007 (Error 0). The step failed.
any good ideas on how to solve?Hi!
Do please check http://support.microsoft.com/kb/823429 and
http://support.microsoft.com/defaul...b;en-us;834116.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Fab" <flazzaro@.tac.infostream.ca> wrote in message
news:%23pS25NcfFHA.2372@.TK2MSFTNGP14.phx.gbl...
>I get the following error when i try to run a query on a linked server.
> Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
> statement. SQLSTATE 42000 (Error 16805) Associated statement is not
> prepared SQLSTATE
> HY007 (Error 0). The step failed.
> any good ideas on how to solve?
>
>
error 7410
I get the following error when i try to run a query on a linked server.
Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared
SQLSTATE
HY007 (Error 0). The step failed.
any good ideas on how to solve?Hi!
Do please check http://support.microsoft.com/kb/823429 and
http://support.microsoft.com/default.aspx?scid=kb;en-us;834116.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Fab" <flazzaro@.tac.infostream.ca> wrote in message
news:%23pS25NcfFHA.2372@.TK2MSFTNGP14.phx.gbl...
>I get the following error when i try to run a query on a linked server.
> Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
> statement. SQLSTATE 42000 (Error 16805) Associated statement is not
> prepared SQLSTATE
> HY007 (Error 0). The step failed.
> any good ideas on how to solve?
>
>
Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared
SQLSTATE
HY007 (Error 0). The step failed.
any good ideas on how to solve?Hi!
Do please check http://support.microsoft.com/kb/823429 and
http://support.microsoft.com/default.aspx?scid=kb;en-us;834116.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Fab" <flazzaro@.tac.infostream.ca> wrote in message
news:%23pS25NcfFHA.2372@.TK2MSFTNGP14.phx.gbl...
>I get the following error when i try to run a query on a linked server.
> Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
> statement. SQLSTATE 42000 (Error 16805) Associated statement is not
> prepared SQLSTATE
> HY007 (Error 0). The step failed.
> any good ideas on how to solve?
>
>
Subscribe to:
Posts (Atom)