Re: Run time jobs

From: SSK (SSK_at_discussions.microsoft.com)
Date: 08/25/05

  • Next message: Dejan Sarka: "Re: Can't remove SA account or delete xp_cmdshell ext stored proc?" 
    Date: Wed, 24 Aug 2005 23:33:09 -0700

    The SQL server agent is started by Local System account.
    The login account has admin privileges on source and destination server also.

    "Jasper Smith" wrote:

    > 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
    > >
    >
    >
    >

  • Next message: Dejan Sarka: "Re: Can't remove SA account or delete xp_cmdshell ext stored proc?"

    Relevant Pages

    • Re: Compromise?
      ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
      (microsoft.public.sqlserver.security)
    • Re: Windows Auth to SQL Server from ATL Web Service not working...
      ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
      (microsoft.public.vc.atl)
    • Re: Discussing 3 different strategies for deleting from multiple tables
      ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
      (microsoft.public.data.ado)
    • RE: connection problems in secondary site and SQL server
      ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
      (microsoft.public.sms.admin)
    • RE: MP Install issue
      ... Will setting the SPN on the domain account fix the communication issue ... >> MPDB ERROR - CONNECTION PARAMETERS ... >> with a trusted SQL Server connection. ...
      (microsoft.public.sms.setup)