forget DTS for a second.

Can you conect using QA?
Are you using the same connection properties in DTS?

how are you trying to connect?

Does this happen when you run DTS manually?

Are you specifying servername or IP address?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Leonardo Gaitán" <leonargr (AT) cable (DOT) net.co> wrote

Hi, i have a DTS that connect to SQL Server database, the
settings and permissions of the conecction are right,
however, when i try execute it, the DTS failed with the
following error: Sql Server does not exist or access is
denied.

Any idea,

Thanks´,

Leonardo Gaitan