Why my job is failing when i schedule in SQL Server , Management , Jobs?

Posted on 2006-03-29
Last Modified: 2013-12-03
Hi ,
    My name is Sridhar i got one problem to schedule job in SQL Server .  Pls find details below.

  We have Database Server called "A" and I registered that Database in my local machine (Enterprise Manager) by using Windows Authentication.  I created a table called "mytable" and it shows owner as "Sridhar".  Now I created DTS package in that connection task i have mention Windows Authentication and given Server name and selected Database ( you know that password is not necessory for windows authentication users).  Now I scheduled that as a Job and I went to job and ran that job.  But it is throwing Failed message.  When I see "View Job History" then I see below line

*** The job failed.  The Job was invoked by User MNAPOOL\Sridhar.  The last step to run was step 1 (dtsBusinessDays) ***

  In this case i went to login to see what kind of permissions i have.  I clicked on my login properties and in that if i went to "Database Access", I see these permission are tick marked for a particular database "public","db_owner","db_datareader","db_datawriter".

  I desperately need help in this..need

Thanks in advance

Question by:bethamsetty
    LVL 14

    Accepted Solution

    When you run a job in SQL Server Agent, the job does not run under your id, it runs under the id that SQL server Agent is running under.  You can see who that is by going to the properties of the SLQ Server Agent in Enterprise manager.

    So your DTS Pachage is trying to connect using NT Authentication, but SQL Server Agent is running under the local Administrator account for example and this account does not have rights to log into SQL Server.  Try creating a SQL server User, and change the DTS package to use this account.  Also change the table owner to be that of this user, or make it owned by dbo.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    In a word: Permissions.  The SQL Server Agent service startup account does not have the required permissions.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    Actually you may need to change the account used be the SQL Server Agent to be a domain account.

    Author Comment

    Thanks bunch to 'adwiseman' works for me................cooooooooooooooooool

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now