Re: cannot open database requested in login

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 15:57:51 +0100

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@discussions.microsoft.com> wrote in message
news:2fa8101c46d9e$9dd77520$a401280a@phx.gbl...
> 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.

Relevant Pages

  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: file conversion from SQL Server to Access
    ... You want to take data and table structure from SQL Server to Access? ... You can also have DTS create the destination tables for you. ... Is there a Northwind database ... >> www.konesans.com - Consultancy from the people who know ...
    (microsoft.public.sqlserver.dts)
  • Re: Audit of sql server
    ... The DTS database transfer makes sense now. ... >> SQL Server will not check on this for you. ... >> Compiles each query but does not execute it. ...
    (microsoft.public.sqlserver.programming)
  • Re: Blocking MS Access from linking tables...
    ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: DTS Performance
    ... Make sure the log and data file size are not going to need to expand during the import ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... > this database is 2.74 GB and the database itself is 2.67 GB. ...
    (microsoft.public.sqlserver.dts)