Error: MSSQL07/SQLAgent Not Found ?

Discussion in 'Databases' started by Lee, Nov 19, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Lee

    Lee

    I set up a DTS Package, so that I could automatically copy my remote database here on DASP, to a local database,just for an extra level of backup.

    It got through almost all of the process, then I got the "MSSQL07/SQLAgent not found" error.

    It retrieved my table definitions, views, etc... but no data. Kinda defeats the purpose!

    I'm pretty sure SQL Agent has to be running on the DASP end for this to work. Does DASP run SQL Agent? Can this be made to work as intended?

    Thanks!

    -Lee


    ========================
    I used to believe in living ever day if it were my last, but then I ran out of clean clothes. Nobody does laundry on their last day.
     
    Lee, Nov 19, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    You cannot schedule DTS package on our server because of security issue.

    SQL Agent only execute as the service user and thus have access to all DB. ie. if we were to allow DTS package, the package can have access to all database on the server.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Nov 22, 2004
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page