Re: Run time jobs

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/24/05 

Date: Wed, 24 Aug 2005 12:19:20 +0100

What account is the SQL Agent service running under ? Jobs owned by sa will
access resources under the context of the SQL Agent service account. 

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"SSK" <SSK@discussions.microsoft.com> wrote in message 
news:CC9BF3BD-5394-40B1-A8E2-7D1DAC73BBA2@microsoft.com...
>A job is created to fetch data from source server and populate the
> destination server. This job has the owner as windows authentication(user
> account). This main job inturn creates sub jobs with owner as sa.
>
> when i run the sub jobs from query analyser it works fine. But when ran 
> from
> sql server agent/jobs it is failing with the following error.
> Msg 18456, Sev 14: Login failed for user 'CHNDomain\CHNSHL23456$'. 
> [SQLSTATE
> 28000]
> Msg 7312, Sev 14:  [SQLSTATE 01000].
>
> [Note: CHNSHL23456$ is the destination system number]
>
> when same job ran from query analyser that was logged using 'sa' account
> fails with the following error.
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'sa'.
> [OLE/DB provider returned message: Invalid connection string attribute]
>
> The windows authenticated user ID exists in both source server/destination
> server users list.
> Pls hlp to get rid of this error.
>
> Regards,
> SSK
>

Relevant Pages

  • Re: Job Scheduling Classic!
    ... Does the SQL Agent service account have access to the file? ... And if the file is on another server, ... >Path indicating file does not use map letter. ...
    (microsoft.public.sqlserver.dts)
  • Re: Run time jobs
    ... Local System does not have access to network resources. ... >The login account has admin privileges on source and destination server also. ... >> access resources under the context of the SQL Agent service account. ...
    (microsoft.public.sqlserver.security)
  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... Client computer must use STRICTLY the INTERNAL DNS server which can ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
  • Re: Same question, still no answer!!!
    ... Sounds then like we are all paying for a feature set only large companies ... The "proxy server" pc is actually an older box stuffed ... Expectation #1) keep the ethernet more or less as is. ... The kids account would be ...
    (microsoft.public.windowsxp.basics)
  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... This would be on the DNS server 172.20.100.2 ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
Quantcast