Hi all,
Sql server 7.0

I have a DTS replication which truncates the destination
of one database and copies all the rows from the source
table of another database of same server(1st server) in
first step. in second step the rows are copied from
destination table to another table of other server(2nd
server).its an scheduled job.
its hung now as even after several hours the status shows
executing.
when i go to Dts designer and try to click on
transformations it gives error cannot open database '1st
server database' requested in login

pls help me in this.

TIA.

Is the connection object using Windows Authentication? If it is then when
you go to open the connection it will try to authenticate your Windows
Account. Do you have permissions to view that DB?

Have a look at this article as well for some nuances of DTS when run as a
scheduled job

http://support.microsoft.com/?kbid=269074

and be aware of this

http://support.microsoft.com/?kbid=290077


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"haseeb" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

thanks for reply,
But the DTS job was running from several months we did not
face any problem except this time and no one has changed
the user or the sa password.

Pls suggest.

TIA

Has somebody deleted the DB then?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"haseeb" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

The database is intact no one has deleted it.
i even checked it manually.


TIA