DTS Package - Destination server is now off domain.

We have a DTS package that refreshes our external website data on a
nightly basis. I recently moved our external website off of our
domain. The SQL Services were previously running as
DOMAIN\Administrator account. When I moved the server off of the
domain, I reinstalled SQL Server and set the services to run as a
local, non-administrative account, MACHINE\sqlservices. The reason I
did this is, if someone were to compromise the machine via the SQL
Services, they would not have administrative access to the machine.

Now, my DTS package fails. I have been reading many posts on the
Internet to try to understand why the package fails, but I have not
been able to figure it out. When it fails, I am logged into the
Internal machine as DOMAIN\Administrator. The owner of the package is
also DOMAIN\Administrator.

Step 1: (succeeds) - sp_UserKill. This procedure kills all SPIDs with
the specified database (DATABASENAME). It appears to be successful.

Step 2: (fails) - drop database DATABASENAME. This fails with the
following message: "Cannot drop the database 'DATABASENAME' because it
is currently in use." Checking enterprise manager, it does not appear
to be in use. I've cycled the SQL Services and rerun with no luck.

I have a feeling that this is an issue with security, but I can't
figure it out. Can someone please assist me?

Thank you in advance.

Jeremy

.

Relevant Pages

  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)
  • DTS Package - Destination Server is now off of domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.dts)
  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL Import/Export
    ... The two best ways to do this is either creating a DTS package that copies ... the entire database and then running that package automatically using the ... SQL Agent. ... > I have 2 different SQL servers running on a network, ...
    (microsoft.public.sqlserver.dts)
  • Re: Import data from Access to SQL2005 on daily basis
    ... You can use SSIS to execute your working 2K package by using the Execute DTS 2000 Package task. ... looking to transfer data on a daily basis from an Access database to ... in SQL 2000, but do not know how to go about it in SQL 2005. ... tried importing the 2000 DTS package into 2005 with little luck. ...
    (microsoft.public.sqlserver.dts)