DTS Server

Hi,
Can someone tell me how to start DTS Server in SQL 2005 beta 2?
In "Server Configuration Manager", I see DTS Server's State is "Stopped", and Start Mode is "Other (Boot, System, Disabled or Unknown). Attempts to start (by doing: properties -> start) have failed.
In the tool "SQL Server 2005 Surface Area Configuration", I found the "start, stop, pause, resume" buttons grayed out.
david
SQL Server Agent depenedent services which means you have to install SQL Server Agent with a service account. Hope this helps.|||

Thanks for the fast response.
But, could you give me a little walkthrough for doing what you've suggested, namely:
" ... install SQL Server Agent with a service account ... " ?
With beta 2, I can see the tool MS SQL Server Management Studio, and I can see "SQL Server Agent", and in the "Logins" section a number of entries are listed.
But exactly what need to be done to get DTS started? (Pl outline the exact steps - I do not have prior exprience with SQL server admin, and the SQL2005 beta 2 documentation on system admin is mostly "blank" presently.)
Thanks.
david

|||

You need Admin experience to know how to install the SQL Server Agent with a service account most COM C++ programmers need it so they know. That said the quick and dirty solution is to reinstall SQL Server because after six years Microsoft installer now ask you to install SQL Server Agent with a service account. The other option try the links below for the configuration steps. Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm.asp

|||

Thanks for the detail info you've provided. I am going see what I can do with it. The codes in the links have syntax that resembles what I have seen in some stored procedures (EXEC, ... etc.) Since these are all new to me, I will ask you these 2 elementary questions:
(i) Using just SQL server (i.e. without using ASP.NET), what are some of the ways I may enter and run the sample codes in the links you've provided?
(ii) Assuming DTS is set up successfully and is running, where may I initiate the DTS function in SQL Server 2005?
I know the answer for SQL 2000, and that is simply by going to: Tool -> DTS, or alternately go to Tools -> Import/Export.
For SQL SERVER 2005, should I expect to be able to do the same to start up DTS?
The reason I am asking this is because I have somehow got DTS Server running, but I don't see a way to begin using DTS (I don't see DTS under the "Tools" tab)
Thanks again, for the previous rensponse.
David

|||Additional question:
Are DTS funcationality available for use from ASP.NET 2.0 Beta 2?|||The new the DTS is a full ETL(extraction transforamtion and loading) tool so you have to go to the first link I gave you to know more about it. Another option is the SQL Server BOL(books online) it is the best in the industry. Hope this helps

DTS Question ...

I have SQL 2000 Enterprise Manager on a desktop development machine .. will
I be able to use DTS from this machine if we upgrade to SQL 2005 on the
server; the reason I'm asking is that I think the "upgrade" (with Small
Business Server) is going to be to the Workgroup Edition, which I don't
think has DTS in the box ... or does it ?
Thanks in advance ...
LLiz wrote:
> I have SQL 2000 Enterprise Manager on a desktop development machine .. wil
l
> I be able to use DTS from this machine if we upgrade to SQL 2005 on the
> server; the reason I'm asking is that I think the "upgrade" (with Small
> Business Server) is going to be to the Workgroup Edition, which I don't
> think has DTS in the box ... or does it ?
> Thanks in advance ...
> L
>
>
DTS no longer exists in SQL Server, it is replaced with Integration
Services in SQL 2005.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:eYtkiBIpGHA.220@.TK2MSFTNGP05.phx.gbl...

> Liz wrote:
will[vbcol=seagreen]
> DTS no longer exists in SQL Server, it is replaced with Integration
> Services in SQL 2005.
yeah, but DTS exists on my desktop .. or does it ? I never once thought
about it ... is it not able to talk to SQL 2005 ? Can you use EM at all
with a SQL 2005 back end ?|||Liz wrote:
> yeah, but DTS exists on my desktop .. or does it ? I never once thought
> about it ... is it not able to talk to SQL 2005 ? Can you use EM at all
> with a SQL 2005 back end ?
>
>
No, the DTS DESIGNER exists on your desktop, the DTS engine does not,
that is a server component. And no, you'll have a hard time getting
Enterprise Manager to work with a 2005 server.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:OuYToQOpGHA.4192@.TK2MSFTNGP03.phx.gbl...
> Liz wrote:
> No, the DTS DESIGNER exists on your desktop, the DTS engine does not,
> that is a server component. And no, you'll have a hard time getting
> Enterprise Manager to work with a 2005 server.
but the on the MS site today I saw in a SQL 2005 WG ED. summary that you can
download DTS for use with it ... ' (in addition to whatever the
import/export facilities that are native to the WG Edition (and other
editions I presume))|||Liz wrote:
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:OuYToQOpGHA.4192@.TK2MSFTNGP03.phx.gbl...
> but the on the MS site today I saw in a SQL 2005 WG ED. summary that you c
an
> download DTS for use with it ... ' (in addition to whatever the
> import/export facilities that are native to the WG Edition (and other
> editions I presume))
>
>
You can download the DTS DESIGNER to use with the new Management Studio
- this is not the DTS engine. All this does is allow you to connect to
SQL 2000 servers to edit legacy DTS packages.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:eVabsvapGHA.4760@.TK2MSFTNGP05.phx.gbl...

can[vbcol=seagreen]
[vbcol=seagreen]
> You can download the DTS DESIGNER to use with the new Management Studio
> - this is not the DTS engine. All this does is allow you to connect to
> SQL 2000 servers to edit legacy DTS packages.
jeez ... they don't do much of a job explaining that in the feature summary
...
here's a quote:
"You can also run packages that were created by using SQL Server 2000 tools
as part of a SQL Server 2005 data transformation solution. Integration
Services provides the Execute DTS 2000 Package task for running DTS packages
from within SQL Server 2005 Integration Services packages."
http://msdn2.microsoft.com/en-us/library/ms143706.aspx
that sure makes it sound like you can run a DTS package against SQL2005 data
... it's not completely unambiguous BUT ...
Thanks, Tracy ...
L|||Liz wrote:
> jeez ... they don't do much of a job explaining that in the feature summar
y
> ...
> here's a quote:
> "You can also run packages that were created by using SQL Server 2000 tool
s
> as part of a SQL Server 2005 data transformation solution. Integration
> Services provides the Execute DTS 2000 Package task for running DTS packag
es
> from within SQL Server 2005 Integration Services packages."
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> that sure makes it sound like you can run a DTS package against SQL2005 da
ta
> ... it's not completely unambiguous BUT ...
> Thanks, Tracy ...
> L
>
You can run an existing DTS package (imported from a SQL 2000 instance)
as a task inside an SSIS project. You can't create new DTS packages as
they existed in SQL 2000, that whole concept has been replaced with
SSIS. It's much more powerful than DTS was, you should spend some time
exploring its capabilities.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

DTS Question ...

I have SQL 2000 Enterprise Manager on a desktop development machine .. will
I be able to use DTS from this machine if we upgrade to SQL 2005 on the
server; the reason I'm asking is that I think the "upgrade" (with Small
Business Server) is going to be to the Workgroup Edition, which I don't
think has DTS in the box ... or does it ?
Thanks in advance ...
LLiz wrote:
> I have SQL 2000 Enterprise Manager on a desktop development machine .. will
> I be able to use DTS from this machine if we upgrade to SQL 2005 on the
> server; the reason I'm asking is that I think the "upgrade" (with Small
> Business Server) is going to be to the Workgroup Edition, which I don't
> think has DTS in the box ... or does it ?
> Thanks in advance ...
> L
>
>
DTS no longer exists in SQL Server, it is replaced with Integration
Services in SQL 2005.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:eYtkiBIpGHA.220@.TK2MSFTNGP05.phx.gbl...
> Liz wrote:
> > I have SQL 2000 Enterprise Manager on a desktop development machine ..
will
> > I be able to use DTS from this machine if we upgrade to SQL 2005 on the
> > server; the reason I'm asking is that I think the "upgrade" (with Small
> > Business Server) is going to be to the Workgroup Edition, which I don't
> > think has DTS in the box ... or does it ?
> >
> > Thanks in advance ...
> DTS no longer exists in SQL Server, it is replaced with Integration
> Services in SQL 2005.
yeah, but DTS exists on my desktop .. or does it ? I never once thought
about it ... is it not able to talk to SQL 2005 ? Can you use EM at all
with a SQL 2005 back end ?|||Liz wrote:
> yeah, but DTS exists on my desktop .. or does it ? I never once thought
> about it ... is it not able to talk to SQL 2005 ? Can you use EM at all
> with a SQL 2005 back end ?
>
>
No, the DTS DESIGNER exists on your desktop, the DTS engine does not,
that is a server component. And no, you'll have a hard time getting
Enterprise Manager to work with a 2005 server.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:OuYToQOpGHA.4192@.TK2MSFTNGP03.phx.gbl...
> Liz wrote:
> >
> > yeah, but DTS exists on my desktop .. or does it ? I never once thought
> > about it ... is it not able to talk to SQL 2005 ? Can you use EM at all
> > with a SQL 2005 back end ?
> >
> >
> >
> No, the DTS DESIGNER exists on your desktop, the DTS engine does not,
> that is a server component. And no, you'll have a hard time getting
> Enterprise Manager to work with a 2005 server.
but the on the MS site today I saw in a SQL 2005 WG ED. summary that you can
download DTS for use with it ... ' (in addition to whatever the
import/export facilities that are native to the WG Edition (and other
editions I presume))|||Liz wrote:
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:OuYToQOpGHA.4192@.TK2MSFTNGP03.phx.gbl...
>> Liz wrote:
>> yeah, but DTS exists on my desktop .. or does it ? I never once thought
>> about it ... is it not able to talk to SQL 2005 ? Can you use EM at all
>> with a SQL 2005 back end ?
>>
>> No, the DTS DESIGNER exists on your desktop, the DTS engine does not,
>> that is a server component. And no, you'll have a hard time getting
>> Enterprise Manager to work with a 2005 server.
> but the on the MS site today I saw in a SQL 2005 WG ED. summary that you can
> download DTS for use with it ... ' (in addition to whatever the
> import/export facilities that are native to the WG Edition (and other
> editions I presume))
>
>
You can download the DTS DESIGNER to use with the new Management Studio
- this is not the DTS engine. All this does is allow you to connect to
SQL 2000 servers to edit legacy DTS packages.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:eVabsvapGHA.4760@.TK2MSFTNGP05.phx.gbl...
> > but the on the MS site today I saw in a SQL 2005 WG ED. summary that you
can
> > download DTS for use with it ... ' (in addition to whatever the
> > import/export facilities that are native to the WG Edition (and other
> > editions I presume))
> You can download the DTS DESIGNER to use with the new Management Studio
> - this is not the DTS engine. All this does is allow you to connect to
> SQL 2000 servers to edit legacy DTS packages.
jeez ... they don't do much of a job explaining that in the feature summary
...
here's a quote:
"You can also run packages that were created by using SQL Server 2000 tools
as part of a SQL Server 2005 data transformation solution. Integration
Services provides the Execute DTS 2000 Package task for running DTS packages
from within SQL Server 2005 Integration Services packages."
http://msdn2.microsoft.com/en-us/library/ms143706.aspx
that sure makes it sound like you can run a DTS package against SQL2005 data
... it's not completely unambiguous BUT ...
Thanks, Tracy ...
L|||Liz wrote:
> jeez ... they don't do much of a job explaining that in the feature summary
> ...
> here's a quote:
> "You can also run packages that were created by using SQL Server 2000 tools
> as part of a SQL Server 2005 data transformation solution. Integration
> Services provides the Execute DTS 2000 Package task for running DTS packages
> from within SQL Server 2005 Integration Services packages."
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> that sure makes it sound like you can run a DTS package against SQL2005 data
> ... it's not completely unambiguous BUT ...
> Thanks, Tracy ...
> L
>
You can run an existing DTS package (imported from a SQL 2000 instance)
as a task inside an SSIS project. You can't create new DTS packages as
they existed in SQL 2000, that whole concept has been replaced with
SSIS. It's much more powerful than DTS was, you should spend some time
exploring its capabilities.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

DTS Problem

Hi,
When i create a DTS and schedule it, the DTS don't run, but if i run this
DTS using the SQL Enterprise manager, everything works fine! Is it a
permission problem ? A Scheduled DTS must have a specific permission ?
Thanks in advance,
VictorDid you start SQL Server Agent ?
Jens Suessmeyer.
"Victor Pereira" <taintmode@.yahoo.com.br> schrieb im Newsbeitrag
news:eLIohxRRFHA.3296@.TK2MSFTNGP15.phx.gbl...
> Hi,
> When i create a DTS and schedule it, the DTS don't run, but if i run this
> DTS using the SQL Enterprise manager, everything works fine! Is it a
> permission problem ? A Scheduled DTS must have a specific permission ?
> Thanks in advance,
> Victor
>|||From BOL
Usually, a package run from DTS Designer, the DTS Import/Export Wizard, the
DTS Run utility, or from the command prompt executes under the security
context of the user who is currently logged in. However, a package scheduled
for execution runs under the security context of the SQL Server Agent job
that runs the package.
"Victor Pereira" wrote:

> Hi,
> When i create a DTS and schedule it, the DTS don't run, but if i run this
> DTS using the SQL Enterprise manager, everything works fine! Is it a
> permission problem ? A Scheduled DTS must have a specific permission ?
> Thanks in advance,
> Victor
>
>|||My DTS read a file C:\foobar.csv and import it into SQL Server. SQL Server
Agent scheduled jobs run on the SQL Server, while interactive ones execute
on the same system on which they were launched. So, when i run the
interactive job, i read the local C:\foobar.csv and everyting works! But
scheduled job will try to open a C:\foobar.csv at the SQL Server, but this
file won't exist so, the process fail! Am i right ?
Thanks in advance,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> From BOL
> Usually, a package run from DTS Designer, the DTS Import/Export Wizard,
the
> DTS Run utility, or from the command prompt executes under the security
> context of the user who is currently logged in. However, a package
scheduled[vbcol=seagreen]
> for execution runs under the security context of the SQL Server Agent job
> that runs the package.
>
> "Victor Pereira" wrote:
>
this[vbcol=seagreen]|||Yes. If you need to read a remote file, make share on remote location, set
appropriate permission for SQL Server Agent Service and in your DTS specify
UNC name for that file (\\Server\Share\foobar.csv)
Hope this help
"Victor Pereira" wrote:

> My DTS read a file C:\foobar.csv and import it into SQL Server. SQL Server
> Agent scheduled jobs run on the SQL Server, while interactive ones execute
> on the same system on which they were launched. So, when i run the
> interactive job, i read the local C:\foobar.csv and everyting works! But
> scheduled job will try to open a C:\foobar.csv at the SQL Server, but this
> file won't exist so, the process fail! Am i right ?
> Thanks in advance,
> Victor
> "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> the
> scheduled
> this
>
>|||Hi Ana,
But if i schedule at my local machine using (at.exe + dtsrun.exe) then my
scheduled job will try to open the local C:\foobar.csv right ?
Thanks,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> Yes. If you need to read a remote file, make share on remote location, set
> appropriate permission for SQL Server Agent Service and in your DTS
specify[vbcol=seagreen]
> UNC name for that file (\\Server\Share\foobar.csv)
> Hope this help
> "Victor Pereira" wrote:
>
Server[vbcol=seagreen]
execute[vbcol=seagreen]
this[vbcol=seagreen]
Wizard,[vbcol=seagreen]
security[vbcol=seagreen]
job[vbcol=seagreen]
?[vbcol=seagreen]|||If your DTS is saved on SQL server on your local machine, yes. But if your
DTS is on remote server, then your DTS will run on remote machine and with
account specified in dtsrun.exe command.
"Victor Pereira" wrote:

> Hi Ana,
> But if i schedule at my local machine using (at.exe + dtsrun.exe) then my
> scheduled job will try to open the local C:\foobar.csv right ?
> Thanks,
> Victor
> "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> specify
> Server
> execute
> this
> Wizard,
> security
> job
> ?
>
>|||Ana, thanks for your help, i solved this "misterious" problem, god bless you
;-)
thanks,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:2A1013F8-EEE1-4EA7-98B2-40FE38ACA849@.microsoft.com...
> If your DTS is saved on SQL server on your local machine, yes. But if your
> DTS is on remote server, then your DTS will run on remote machine and
with[vbcol=seagreen]
> account specified in dtsrun.exe command.
> "Victor Pereira" wrote:
>
my[vbcol=seagreen]
set[vbcol=seagreen]
But[vbcol=seagreen]
but[vbcol=seagreen]
Agent[vbcol=seagreen]
run[vbcol=seagreen]
it a[vbcol=seagreen]
permission[vbcol=seagreen]

DTS Problem

Hi,
When i create a DTS and schedule it, the DTS don't run, but if i run this
DTS using the SQL Enterprise manager, everything works fine! Is it a
permission problem ? A Scheduled DTS must have a specific permission ?
Thanks in advance,
Victor
Did you start SQL Server Agent ?
Jens Suessmeyer.
"Victor Pereira" <taintmode@.yahoo.com.br> schrieb im Newsbeitrag
news:eLIohxRRFHA.3296@.TK2MSFTNGP15.phx.gbl...
> Hi,
> When i create a DTS and schedule it, the DTS don't run, but if i run this
> DTS using the SQL Enterprise manager, everything works fine! Is it a
> permission problem ? A Scheduled DTS must have a specific permission ?
> Thanks in advance,
> Victor
>
|||From BOL
Usually, a package run from DTS Designer, the DTS Import/Export Wizard, the
DTS Run utility, or from the command prompt executes under the security
context of the user who is currently logged in. However, a package scheduled
for execution runs under the security context of the SQL Server Agent job
that runs the package.
"Victor Pereira" wrote:

> Hi,
> When i create a DTS and schedule it, the DTS don't run, but if i run this
> DTS using the SQL Enterprise manager, everything works fine! Is it a
> permission problem ? A Scheduled DTS must have a specific permission ?
> Thanks in advance,
> Victor
>
>
|||My DTS read a file C:\foobar.csv and import it into SQL Server. SQL Server
Agent scheduled jobs run on the SQL Server, while interactive ones execute
on the same system on which they were launched. So, when i run the
interactive job, i read the local C:\foobar.csv and everyting works! But
scheduled job will try to open a C:\foobar.csv at the SQL Server, but this
file won't exist so, the process fail! Am i right ?
Thanks in advance,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> From BOL
> Usually, a package run from DTS Designer, the DTS Import/Export Wizard,
the
> DTS Run utility, or from the command prompt executes under the security
> context of the user who is currently logged in. However, a package
scheduled[vbcol=seagreen]
> for execution runs under the security context of the SQL Server Agent job
> that runs the package.
>
> "Victor Pereira" wrote:
this[vbcol=seagreen]
|||Yes. If you need to read a remote file, make share on remote location, set
appropriate permission for SQL Server Agent Service and in your DTS specify
UNC name for that file (\\Server\Share\foobar.csv)
Hope this help
"Victor Pereira" wrote:

> My DTS read a file C:\foobar.csv and import it into SQL Server. SQL Server
> Agent scheduled jobs run on the SQL Server, while interactive ones execute
> on the same system on which they were launched. So, when i run the
> interactive job, i read the local C:\foobar.csv and everyting works! But
> scheduled job will try to open a C:\foobar.csv at the SQL Server, but this
> file won't exist so, the process fail! Am i right ?
> Thanks in advance,
> Victor
> "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> the
> scheduled
> this
>
>
|||Hi Ana,
But if i schedule at my local machine using (at.exe + dtsrun.exe) then my
scheduled job will try to open the local C:\foobar.csv right ?
Thanks,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> Yes. If you need to read a remote file, make share on remote location, set
> appropriate permission for SQL Server Agent Service and in your DTS
specify[vbcol=seagreen]
> UNC name for that file (\\Server\Share\foobar.csv)
> Hope this help
> "Victor Pereira" wrote:
Server[vbcol=seagreen]
execute[vbcol=seagreen]
this[vbcol=seagreen]
Wizard,[vbcol=seagreen]
security[vbcol=seagreen]
job[vbcol=seagreen]
?[vbcol=seagreen]
|||If your DTS is saved on SQL server on your local machine, yes. But if your
DTS is on remote server, then your DTS will run on remote machine and with
account specified in dtsrun.exe command.
"Victor Pereira" wrote:

> Hi Ana,
> But if i schedule at my local machine using (at.exe + dtsrun.exe) then my
> scheduled job will try to open the local C:\foobar.csv right ?
> Thanks,
> Victor
> "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> specify
> Server
> execute
> this
> Wizard,
> security
> job
> ?
>
>
|||Ana, thanks for your help, i solved this "misterious" problem, god bless you
;-)
thanks,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:2A1013F8-EEE1-4EA7-98B2-40FE38ACA849@.microsoft.com...
> If your DTS is saved on SQL server on your local machine, yes. But if your
> DTS is on remote server, then your DTS will run on remote machine and
with[vbcol=seagreen]
> account specified in dtsrun.exe command.
> "Victor Pereira" wrote:
my[vbcol=seagreen]
set[vbcol=seagreen]
But[vbcol=seagreen]
but[vbcol=seagreen]
Agent[vbcol=seagreen]
run[vbcol=seagreen]
it a[vbcol=seagreen]
permission[vbcol=seagreen]

DTS Problem

Hi,
When i create a DTS and schedule it, the DTS don't run, but if i run this
DTS using the SQL Enterprise manager, everything works fine! Is it a
permission problem ? A Scheduled DTS must have a specific permission ?
Thanks in advance,
VictorDid you start SQL Server Agent ?
Jens Suessmeyer.
"Victor Pereira" <taintmode@.yahoo.com.br> schrieb im Newsbeitrag
news:eLIohxRRFHA.3296@.TK2MSFTNGP15.phx.gbl...
> Hi,
> When i create a DTS and schedule it, the DTS don't run, but if i run this
> DTS using the SQL Enterprise manager, everything works fine! Is it a
> permission problem ? A Scheduled DTS must have a specific permission ?
> Thanks in advance,
> Victor
>|||From BOL
Usually, a package run from DTS Designer, the DTS Import/Export Wizard, the
DTS Run utility, or from the command prompt executes under the security
context of the user who is currently logged in. However, a package scheduled
for execution runs under the security context of the SQL Server Agent job
that runs the package.
"Victor Pereira" wrote:
> Hi,
> When i create a DTS and schedule it, the DTS don't run, but if i run this
> DTS using the SQL Enterprise manager, everything works fine! Is it a
> permission problem ? A Scheduled DTS must have a specific permission ?
> Thanks in advance,
> Victor
>
>|||My DTS read a file C:\foobar.csv and import it into SQL Server. SQL Server
Agent scheduled jobs run on the SQL Server, while interactive ones execute
on the same system on which they were launched. So, when i run the
interactive job, i read the local C:\foobar.csv and everyting works! But
scheduled job will try to open a C:\foobar.csv at the SQL Server, but this
file won't exist so, the process fail! Am i right ?
Thanks in advance,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> From BOL
> Usually, a package run from DTS Designer, the DTS Import/Export Wizard,
the
> DTS Run utility, or from the command prompt executes under the security
> context of the user who is currently logged in. However, a package
scheduled
> for execution runs under the security context of the SQL Server Agent job
> that runs the package.
>
> "Victor Pereira" wrote:
> > Hi,
> >
> > When i create a DTS and schedule it, the DTS don't run, but if i run
this
> > DTS using the SQL Enterprise manager, everything works fine! Is it a
> > permission problem ? A Scheduled DTS must have a specific permission ?
> >
> > Thanks in advance,
> >
> > Victor
> >
> >
> >|||Yes. If you need to read a remote file, make share on remote location, set
appropriate permission for SQL Server Agent Service and in your DTS specify
UNC name for that file (\\Server\Share\foobar.csv)
Hope this help
"Victor Pereira" wrote:
> My DTS read a file C:\foobar.csv and import it into SQL Server. SQL Server
> Agent scheduled jobs run on the SQL Server, while interactive ones execute
> on the same system on which they were launched. So, when i run the
> interactive job, i read the local C:\foobar.csv and everyting works! But
> scheduled job will try to open a C:\foobar.csv at the SQL Server, but this
> file won't exist so, the process fail! Am i right ?
> Thanks in advance,
> Victor
> "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> > From BOL
> > Usually, a package run from DTS Designer, the DTS Import/Export Wizard,
> the
> > DTS Run utility, or from the command prompt executes under the security
> > context of the user who is currently logged in. However, a package
> scheduled
> > for execution runs under the security context of the SQL Server Agent job
> > that runs the package.
> >
> >
> > "Victor Pereira" wrote:
> >
> > > Hi,
> > >
> > > When i create a DTS and schedule it, the DTS don't run, but if i run
> this
> > > DTS using the SQL Enterprise manager, everything works fine! Is it a
> > > permission problem ? A Scheduled DTS must have a specific permission ?
> > >
> > > Thanks in advance,
> > >
> > > Victor
> > >
> > >
> > >
>
>|||Hi Ana,
But if i schedule at my local machine using (at.exe + dtsrun.exe) then my
scheduled job will try to open the local C:\foobar.csv right ?
Thanks,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> Yes. If you need to read a remote file, make share on remote location, set
> appropriate permission for SQL Server Agent Service and in your DTS
specify
> UNC name for that file (\\Server\Share\foobar.csv)
> Hope this help
> "Victor Pereira" wrote:
> > My DTS read a file C:\foobar.csv and import it into SQL Server. SQL
Server
> > Agent scheduled jobs run on the SQL Server, while interactive ones
execute
> > on the same system on which they were launched. So, when i run the
> > interactive job, i read the local C:\foobar.csv and everyting works! But
> > scheduled job will try to open a C:\foobar.csv at the SQL Server, but
this
> > file won't exist so, the process fail! Am i right ?
> >
> > Thanks in advance,
> > Victor
> > "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> > news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> > > From BOL
> > > Usually, a package run from DTS Designer, the DTS Import/Export
Wizard,
> > the
> > > DTS Run utility, or from the command prompt executes under the
security
> > > context of the user who is currently logged in. However, a package
> > scheduled
> > > for execution runs under the security context of the SQL Server Agent
job
> > > that runs the package.
> > >
> > >
> > > "Victor Pereira" wrote:
> > >
> > > > Hi,
> > > >
> > > > When i create a DTS and schedule it, the DTS don't run, but if i run
> > this
> > > > DTS using the SQL Enterprise manager, everything works fine! Is it a
> > > > permission problem ? A Scheduled DTS must have a specific permission
?
> > > >
> > > > Thanks in advance,
> > > >
> > > > Victor
> > > >
> > > >
> > > >
> >
> >
> >|||If your DTS is saved on SQL server on your local machine, yes. But if your
DTS is on remote server, then your DTS will run on remote machine and with
account specified in dtsrun.exe command.
"Victor Pereira" wrote:
> Hi Ana,
> But if i schedule at my local machine using (at.exe + dtsrun.exe) then my
> scheduled job will try to open the local C:\foobar.csv right ?
> Thanks,
> Victor
> "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> > Yes. If you need to read a remote file, make share on remote location, set
> > appropriate permission for SQL Server Agent Service and in your DTS
> specify
> > UNC name for that file (\\Server\Share\foobar.csv)
> >
> > Hope this help
> >
> > "Victor Pereira" wrote:
> >
> > > My DTS read a file C:\foobar.csv and import it into SQL Server. SQL
> Server
> > > Agent scheduled jobs run on the SQL Server, while interactive ones
> execute
> > > on the same system on which they were launched. So, when i run the
> > > interactive job, i read the local C:\foobar.csv and everyting works! But
> > > scheduled job will try to open a C:\foobar.csv at the SQL Server, but
> this
> > > file won't exist so, the process fail! Am i right ?
> > >
> > > Thanks in advance,
> > > Victor
> > > "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> > > news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> > > > From BOL
> > > > Usually, a package run from DTS Designer, the DTS Import/Export
> Wizard,
> > > the
> > > > DTS Run utility, or from the command prompt executes under the
> security
> > > > context of the user who is currently logged in. However, a package
> > > scheduled
> > > > for execution runs under the security context of the SQL Server Agent
> job
> > > > that runs the package.
> > > >
> > > >
> > > > "Victor Pereira" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > When i create a DTS and schedule it, the DTS don't run, but if i run
> > > this
> > > > > DTS using the SQL Enterprise manager, everything works fine! Is it a
> > > > > permission problem ? A Scheduled DTS must have a specific permission
> ?
> > > > >
> > > > > Thanks in advance,
> > > > >
> > > > > Victor
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Ana, thanks for your help, i solved this "misterious" problem, god bless you
;-)
thanks,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:2A1013F8-EEE1-4EA7-98B2-40FE38ACA849@.microsoft.com...
> If your DTS is saved on SQL server on your local machine, yes. But if your
> DTS is on remote server, then your DTS will run on remote machine and
with
> account specified in dtsrun.exe command.
> "Victor Pereira" wrote:
> > Hi Ana,
> >
> > But if i schedule at my local machine using (at.exe + dtsrun.exe) then
my
> > scheduled job will try to open the local C:\foobar.csv right ?
> >
> > Thanks,
> >
> > Victor
> > "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> > news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> > > Yes. If you need to read a remote file, make share on remote location,
set
> > > appropriate permission for SQL Server Agent Service and in your DTS
> > specify
> > > UNC name for that file (\\Server\Share\foobar.csv)
> > >
> > > Hope this help
> > >
> > > "Victor Pereira" wrote:
> > >
> > > > My DTS read a file C:\foobar.csv and import it into SQL Server. SQL
> > Server
> > > > Agent scheduled jobs run on the SQL Server, while interactive ones
> > execute
> > > > on the same system on which they were launched. So, when i run the
> > > > interactive job, i read the local C:\foobar.csv and everyting works!
But
> > > > scheduled job will try to open a C:\foobar.csv at the SQL Server,
but
> > this
> > > > file won't exist so, the process fail! Am i right ?
> > > >
> > > > Thanks in advance,
> > > > Victor
> > > > "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> > > > news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> > > > > From BOL
> > > > > Usually, a package run from DTS Designer, the DTS Import/Export
> > Wizard,
> > > > the
> > > > > DTS Run utility, or from the command prompt executes under the
> > security
> > > > > context of the user who is currently logged in. However, a package
> > > > scheduled
> > > > > for execution runs under the security context of the SQL Server
Agent
> > job
> > > > > that runs the package.
> > > > >
> > > > >
> > > > > "Victor Pereira" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > When i create a DTS and schedule it, the DTS don't run, but if i
run
> > > > this
> > > > > > DTS using the SQL Enterprise manager, everything works fine! Is
it a
> > > > > > permission problem ? A Scheduled DTS must have a specific
permission
> > ?
> > > > > >
> > > > > > Thanks in advance,
> > > > > >
> > > > > > Victor
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >sqlsql

DTS PACKAGES SECURITY ISSUE

Hi,
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can still
see other DTS packages and open them. IS there any way of restricting the DTS
packages so that he can only see what he had created and not others?
Thanks
Anp
Hi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:

> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can still
> see other DTS packages and open them. IS there any way of restricting the DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp
|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:

>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can still
>see other DTS packages and open them. IS there any way of restricting the DTS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp
sqlsql

DTS PACKAGES SECURITY ISSUE

Hi,
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can still
see other DTS packages and open them. IS there any way of restricting the DTS
packages so that he can only see what he had created and not others?
Thanks
AnpHi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:
> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can still
> see other DTS packages and open them. IS there any way of restricting the DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:
>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can still
>see other DTS packages and open them. IS there any way of restricting the DTS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp

DTS PACKAGES SECURITY ISSUE

Hi,
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can stil
l
see other DTS packages and open them. IS there any way of restricting the DT
S
packages so that he can only see what he had created and not others?
Thanks
AnpHi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:

> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can st
ill
> see other DTS packages and open them. IS there any way of restricting the
DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:

>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can sti
ll
>see other DTS packages and open them. IS there any way of restricting the D
TS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp

dts package?

I have a DTS package schedule to run once each day and the package is save in Enterprise Manager. Does Enterprise Manager have to be loaded for the DTS package to run on schedule? Thanks.EM is just an application interface to sql server.

sql server stores the jobs and dts packages in the master database.

sql server agent takes care of the execution of all your jobs, and knows where to find your "stuff"

The is service the is constantly running

Anyone know how the internals of this works.|||To answer the original question, no SQL Enterprise Manager does not need to be running for a scheduled package to run. SQL Agent needs to be running on the server.

The DTS packages and the Job scheduling information are actually stored in the MSDB database, not in master.

While I don't know nearly as much as I'd like to, I know enough to get both of us into major trouble without even breaking a sweat!

-PatP|||msdb, huh...

Hell, failed that interview...

Had a dba here who wanted to "clean up" his server and get rid of un-needed databases...

Northwind
Pubs
model
msdb
master

scrub...

He didn't last very long...|||How do I get slq agent running? I keep getting that error that sqlagent is not running.

Thanks|||The easy way is to start the SQL Service Manager, select the correct server in the top drop down box, select SQL Server Agent in the lower box, then click the button with the green "start" triangle.

-PatP|||I have heard of some places that will drop pubs and Northwind. I never do. Too useful for testing stuff.

As for the DTS internals, I will take an ill-advised stab at explaining it all.

When you create a new DTS package, you are really creating a VB script which will do all the things that you told (not necessarily wanted) the DTS package to do. Technically, you could write a VB script in notepad to run a DTS package, but I already tried it. It stank.

The generated script is stored by default in the msdb database (sysdtspackages), but can be stored as a VB script, a proprietary DTS formatted file, or in the SQL Server metadata repository (have not touched that, myself).
A VB script version could be run on any windows machine, but will promptly choke, if it can not find the .dlls in order to get all the fancy functions it needs.

Actual package formatted DTS packages (from msdb, Metadata, or the proprietary file format) can all be run by the dtsrun.exe utility. This is what SQL Agent calls, when you schedule a package to run. It also happens to be the same executable that Enterprise Manager calls to run a package for you on your laptop. This is where the client dependencies start. If you have a SQL 2000 Enterprise Manager, you can run your package locally no problem. When you try to run the "same" package via SQL Agent on a SQL 7.0 server, you get nothing but errors. This is because you have asked the script to created with one library, and run with a separate library, and your package has only one library card (sorry, it is past 5:00).

So, now that you are no doubt utterly confused, the answer is "No, Enterprise Manager does not have to be running, but SQLAgent has to be running (in order to spawn the process), the dtsrun.exe utility has to be there (it is for any SQL Server install), and the dts*.dlls have to be there, and be the right version." Clear as mud?|||Thanks everyone for the help. I tried it and it's working just how I want it too. Thanks agian.

DTS package to import a csv file on a web server

Im trying to schedule a dts package to import a database table from a csv
file.
In enterprise manager when i attempt to create the dts process, im not sure
what datasource should i be using to connect to my csv file that resides on
the web server?
where do i specify me server to connect to; eg: www.myserver.com\dbRight-click Local Packages and select New Package, Look on Connection and
select Text File (Source). Specify the file name location on the network.
Perhaps you will need to create a shared folder on your web server and give
permissions to the SQL Server service account.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"bj" wrote:

> Im trying to schedule a dts package to import a database table from a csv
> file.
> In enterprise manager when i attempt to create the dts process, im not sur
e
> what datasource should i be using to connect to my csv file that resides o
n
> the web server?
> where do i specify me server to connect to; eg: www.myserver.com\db
>
>|||thanks ben
I think my biggest problem is working out what my UNC path to my web server
is to locate my text file
should it look something like this
\\syd2004\www.bradyaust.com.au\db\
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:118D97ED-21FC-4538-8670-53C25A1CF867@.microsoft.com...
> Right-click Local Packages and select New Package, Look on Connection and
> select Text File (Source). Specify the file name location on the network.
> Perhaps you will need to create a shared folder on your web server and
> give
> permissions to the SQL Server service account.
> Hope this helps,
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "bj" wrote:
>|||Go to your web server, select the folder containing the text file,
right-click and select Sharing and Security, Share this folder, give
Permissions (very careful here), maybe remove permissions to Everyone, Add
the SQL Server service account, etc.
Let us suppose you shared your folder as MyData, then SQL Server would be
able to access the file using \\webservername\MyData\MyTextFile.
Again, pay special attention to the permissions you give to the shared folde
r.
Ben Nevarez, MCDBA, OCP
Database Administrator
"bj" wrote:

> thanks ben
> I think my biggest problem is working out what my UNC path to my web serve
r
> is to locate my text file
> should it look something like this
> \\syd2004\www.bradyaust.com.au\db\
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:118D97ED-21FC-4538-8670-53C25A1CF867@.microsoft.com...
>
>

dts package failure when setup as job

HI I have a dts package (SQL 2000) that I can execute from Enterprise manager
opened on a client machine connected to a server. When I schedule it as a
job though Enterprise manager on the client machine connected to the server
the job fails. The package connects to an SQL database on the server as well
as an oracle database on another server. On job failure the event is written
to the windows event log on the server. The error message is Source SQL
Server agent,
status failed, the job failed.
I am thinking it may have to do with credentials, any ideas how to
troubleshoot this?
thanks.
--
Paul G
Software engineer.Paul,
Yes, when you run it from Enterprise Manager, you are running under your
credentials. A scheduled job has different credentials.
When you schedule the DTS package from SQL Agent, it will run either as the
server account or as the account defined in xp_sqlagent_proxy_account for
your server. The SQL Server 2000 Books Online article on
xp_sqlagent_proxy_account has a fairly clear explanation.
Once you determine which credentials your job is using, then you can have
appropriate access granted to that account.
RLF
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:4E204B8C-1174-4713-A420-273E72F92178@.microsoft.com...
> HI I have a dts package (SQL 2000) that I can execute from Enterprise
> manager
> opened on a client machine connected to a server. When I schedule it as a
> job though Enterprise manager on the client machine connected to the
> server
> the job fails. The package connects to an SQL database on the server as
> well
> as an oracle database on another server. On job failure the event is
> written
> to the windows event log on the server. The error message is Source SQL
> Server agent,
> status failed, the job failed.
> I am thinking it may have to do with credentials, any ideas how to
> troubleshoot this?
> thanks.
> --
> Paul G
> Software engineer.|||ok thanks for the information. Another problem is part of the package writes
to an Oracle database but the oracle client software is not installed on the
server.
--
Paul G
Software engineer.
"Russell Fields" wrote:
> Paul,
> Yes, when you run it from Enterprise Manager, you are running under your
> credentials. A scheduled job has different credentials.
> When you schedule the DTS package from SQL Agent, it will run either as the
> server account or as the account defined in xp_sqlagent_proxy_account for
> your server. The SQL Server 2000 Books Online article on
> xp_sqlagent_proxy_account has a fairly clear explanation.
> Once you determine which credentials your job is using, then you can have
> appropriate access granted to that account.
> RLF
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:4E204B8C-1174-4713-A420-273E72F92178@.microsoft.com...
> > HI I have a dts package (SQL 2000) that I can execute from Enterprise
> > manager
> > opened on a client machine connected to a server. When I schedule it as a
> > job though Enterprise manager on the client machine connected to the
> > server
> > the job fails. The package connects to an SQL database on the server as
> > well
> > as an oracle database on another server. On job failure the event is
> > written
> > to the windows event log on the server. The error message is Source SQL
> > Server agent,
> > status failed, the job failed.
> > I am thinking it may have to do with credentials, any ideas how to
> > troubleshoot this?
> > thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||Paul,
So that is the other part. When you run a DTS package from Enterprise
Manager in runs on the same machine that Enterprise Manager is running on.
So, if you are running EM on your desktop, that is where DTS runs as well.
Naturally if you have the Oracle client software on your desktop, it will
work for you.
If that is the case, then you will need to evaluate putting the Oracle
client software on the SQL Server. I don't have any experience with Oracle,
but plenty of people have successfully used DTS, Linked Servers, etc between
SQL Server and Oracle Server.
RLF
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C5E14CA8-6327-4F64-854B-2C08274CE61D@.microsoft.com...
> ok thanks for the information. Another problem is part of the package
> writes
> to an Oracle database but the oracle client software is not installed on
> the
> server.
> --
> Paul G
> Software engineer.
>
> "Russell Fields" wrote:
>> Paul,
>> Yes, when you run it from Enterprise Manager, you are running under your
>> credentials. A scheduled job has different credentials.
>> When you schedule the DTS package from SQL Agent, it will run either as
>> the
>> server account or as the account defined in xp_sqlagent_proxy_account for
>> your server. The SQL Server 2000 Books Online article on
>> xp_sqlagent_proxy_account has a fairly clear explanation.
>> Once you determine which credentials your job is using, then you can have
>> appropriate access granted to that account.
>> RLF
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:4E204B8C-1174-4713-A420-273E72F92178@.microsoft.com...
>> > HI I have a dts package (SQL 2000) that I can execute from Enterprise
>> > manager
>> > opened on a client machine connected to a server. When I schedule it
>> > as a
>> > job though Enterprise manager on the client machine connected to the
>> > server
>> > the job fails. The package connects to an SQL database on the server
>> > as
>> > well
>> > as an oracle database on another server. On job failure the event is
>> > written
>> > to the windows event log on the server. The error message is Source
>> > SQL
>> > Server agent,
>> > status failed, the job failed.
>> > I am thinking it may have to do with credentials, any ideas how to
>> > troubleshoot this?
>> > thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||thanks for the additional information. I was wondering why it worked from my
client machine, but I do have the Oracle client software installed on it. I
had it on the server before but we ran into an issue with Appachi effecting
IIS so someone removed all of the Oracle software.
--
Paul G
Software engineer.
"Russell Fields" wrote:
> Paul,
> So that is the other part. When you run a DTS package from Enterprise
> Manager in runs on the same machine that Enterprise Manager is running on.
> So, if you are running EM on your desktop, that is where DTS runs as well.
> Naturally if you have the Oracle client software on your desktop, it will
> work for you.
> If that is the case, then you will need to evaluate putting the Oracle
> client software on the SQL Server. I don't have any experience with Oracle,
> but plenty of people have successfully used DTS, Linked Servers, etc between
> SQL Server and Oracle Server.
> RLF
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:C5E14CA8-6327-4F64-854B-2C08274CE61D@.microsoft.com...
> > ok thanks for the information. Another problem is part of the package
> > writes
> > to an Oracle database but the oracle client software is not installed on
> > the
> > server.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Russell Fields" wrote:
> >
> >> Paul,
> >>
> >> Yes, when you run it from Enterprise Manager, you are running under your
> >> credentials. A scheduled job has different credentials.
> >>
> >> When you schedule the DTS package from SQL Agent, it will run either as
> >> the
> >> server account or as the account defined in xp_sqlagent_proxy_account for
> >> your server. The SQL Server 2000 Books Online article on
> >> xp_sqlagent_proxy_account has a fairly clear explanation.
> >>
> >> Once you determine which credentials your job is using, then you can have
> >> appropriate access granted to that account.
> >>
> >> RLF
> >>
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:4E204B8C-1174-4713-A420-273E72F92178@.microsoft.com...
> >> > HI I have a dts package (SQL 2000) that I can execute from Enterprise
> >> > manager
> >> > opened on a client machine connected to a server. When I schedule it
> >> > as a
> >> > job though Enterprise manager on the client machine connected to the
> >> > server
> >> > the job fails. The package connects to an SQL database on the server
> >> > as
> >> > well
> >> > as an oracle database on another server. On job failure the event is
> >> > written
> >> > to the windows event log on the server. The error message is Source
> >> > SQL
> >> > Server agent,
> >> > status failed, the job failed.
> >> > I am thinking it may have to do with credentials, any ideas how to
> >> > troubleshoot this?
> >> > thanks.
> >> > --
> >> > Paul G
> >> > Software engineer.
> >>
> >>
> >>
>
>

DTS Package failure

I have a DTS package which keeps failing giving me the error message “A connection with the transaction manager was lost". The DTS package is using two different servers as connection and the DTS package has Use Transaction, Rollback transaction on failure and Join transaction if present ticked. I have checked the MSDTC service is running on both servers, the following options on both servers have been checked; Network DTC Access, Allow Inbound and Outbound. Does anybody know what is causing this error message?

Any suggestions much appreciated.

Regards
AmberThis is no longer a problem as we removed Use Transactions on the DTS package and added additional steps on failure to allow rollback.

DTS opening error on server enterprise manager

We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
created some DTS on this server which were scheduled to run on perticular
time. Few days back all the DTS started failing to execute through scheduler.
While checking from any client machine the DTS is running successfully but on
the server machine it is not. When I tried to open the DTS on the server
console Enterprise Manager it is giving me following error
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
does not exists or access denied
I had tried with reinstalling the SQL Enterprise manager on the server,
reregistered the SQLDMO.dll but without any success.
Can anybody help me?
Hi
It is probably you creared the DTS on your workstation and not on the
server. If you schedule the DTS to run as a job it will be ran under SQL
Server Agent account. Check it out.
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> We have got a SQL server 2000 loaded on a Windows 2000 advance server. We
had
> created some DTS on this server which were scheduled to run on perticular
> time. Few days back all the DTS started failing to execute through
scheduler.
> While checking from any client machine the DTS is running successfully but
on
> the server machine it is not. When I tried to open the DTS on the server
> console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
> does not exists or access denied
> I had tried with reinstalling the SQL Enterprise manager on the server,
> reregistered the SQLDMO.dll but without any success.
>
> Can anybody help me?
>
>
>
|||It is created from the workstation but on the server. That means it is saved
on the server and scheduled on the server under SQlserver Agent account. It
was running still last few days. Now it is giving the problem. it is not
giving me access to open the package also. it is giving me the error that I
had written.
"Uri Dimant" wrote:

> Hi
> It is probably you creared the DTS on your workstation and not on the
> server. If you schedule the DTS to run as a job it will be ran under SQL
> Server Agent account. Check it out.
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> had
> scheduler.
> on
>
>
|||Well,that means that something was changed (an account, a password)
Are you sure?
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> It is created from the workstation but on the server. That means it is
saved
> on the server and scheduled on the server under SQlserver Agent account.
It
> was running still last few days. Now it is giving the problem. it is not
> giving me access to open the package also. it is giving me the error that
I[vbcol=seagreen]
> had written.
>
>
> "Uri Dimant" wrote:
We[vbcol=seagreen]
perticular[vbcol=seagreen]
but[vbcol=seagreen]
server[vbcol=seagreen]
Server[vbcol=seagreen]
server,[vbcol=seagreen]
|||No there is no changes happend, I am able to Open the package and execute the
package from my client pc. But while doing the same on the sever console it
is giving me error. I am convienced that scheduler is not able to run the
package as server is giving the error.
This error is comming only on the Server's Enterprise Manager, not on any
client side.
"Uri Dimant" wrote:

> Well,that means that something was changed (an account, a password)
> Are you sure?
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> saved
> It
> I
> We
> perticular
> but
> server
> Server
> server,
>
>
|||Still the only logical reason can be that there somehow is a difference
between your client and the server.
How do you log on on the server when you try to open the DTS via Enterprise
Mgr? Using your own account or rather via a (local) admin account on that
machine ?
If the latter, check if the sql-connection you speak about is based on a
Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
should verify (or even beter : try to simulate) the account used for
running the SQLAgent is able to connect to the requested database. Likely
something has changed the past week, they just forgot to tell you =)
Good Luck,
Roby
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...[vbcol=seagreen]
> No there is no changes happend, I am able to Open the package and execute
> the
> package from my client pc. But while doing the same on the sever console
> it
> is giving me error. I am convienced that scheduler is not able to run the
> package as server is giving the error.
> This error is comming only on the Server's Enterprise Manager, not on any
> client side.
> "Uri Dimant" wrote:
|||In regards to the packages failing, you need to check the
job history for the DTS packages to determine why they are
failing. Checking the details in the job history will give
you more detailed information on why the packages are
failing to run as schedule.
-Sue
On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
<satyaki@.discussions.microsoft.com> wrote:

>We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
>created some DTS on this server which were scheduled to run on perticular
>time. Few days back all the DTS started failing to execute through scheduler.
>While checking from any client machine the DTS is running successfully but on
>the server machine it is not. When I tried to open the DTS on the server
>console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
>does not exists or access denied
>I had tried with reinstalling the SQL Enterprise manager on the server,
>reregistered the SQLDMO.dll but without any success.
>
>Can anybody help me?
>
>
>
|||I had already checked that, it is giving same error server does not exists or
access denied. this is only happening on the server console enterprise
manager.
I don't thing it is any secured connection problem, nobody has change any
server configurations. Other activity on the enterprise manager is running
perfectly. I am facing this problem only on DTS package opening, may be due
to this the job scheduler is not running as job history is showing the same
problem.
"Sue Hoegemeier" wrote:

> In regards to the packages failing, you need to check the
> job history for the DTS packages to determine why they are
> failing. Checking the details in the job history will give
> you more detailed information on why the packages are
> failing to run as schedule.
> -Sue
> On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
> <satyaki@.discussions.microsoft.com> wrote:
>
>
|||i am using sa login in the server enterprise manager to open the DTS. i had
tried with windows authentication, DTS creators login but without any result.
And no body has change any settings on the server/
"Roby Van Hoye" wrote:

> Still the only logical reason can be that there somehow is a difference
> between your client and the server.
> How do you log on on the server when you try to open the DTS via Enterprise
> Mgr? Using your own account or rather via a (local) admin account on that
> machine ?
> If the latter, check if the sql-connection you speak about is based on a
> Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
> should verify (or even beter : try to simulate) the account used for
> running the SQLAgent is able to connect to the requested database. Likely
> something has changed the past week, they just forgot to tell you =)
> Good Luck,
> Roby
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...
>
>

DTS opening error on server enterprise manager

We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
created some DTS on this server which were scheduled to run on perticular
time. Few days back all the DTS started failing to execute through scheduler.
While checking from any client machine the DTS is running successfully but on
the server machine it is not. When I tried to open the DTS on the server
console Enterprise Manager it is giving me following error
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
does not exists or access denied
I had tried with reinstalling the SQL Enterprise manager on the server,
reregistered the SQLDMO.dll but without any success.
Can anybody help me'Hi
It is probably you creared the DTS on your workstation and not on the
server. If you schedule the DTS to run as a job it will be ran under SQL
Server Agent account. Check it out.
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> We have got a SQL server 2000 loaded on a Windows 2000 advance server. We
had
> created some DTS on this server which were scheduled to run on perticular
> time. Few days back all the DTS started failing to execute through
scheduler.
> While checking from any client machine the DTS is running successfully but
on
> the server machine it is not. When I tried to open the DTS on the server
> console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
> does not exists or access denied
> I had tried with reinstalling the SQL Enterprise manager on the server,
> reregistered the SQLDMO.dll but without any success.
>
> Can anybody help me'
>
>
>|||It is created from the workstation but on the server. That means it is saved
on the server and scheduled on the server under SQlserver Agent account. It
was running still last few days. Now it is giving the problem. it is not
giving me access to open the package also. it is giving me the error that I
had written.
"Uri Dimant" wrote:
> Hi
> It is probably you creared the DTS on your workstation and not on the
> server. If you schedule the DTS to run as a job it will be ran under SQL
> Server Agent account. Check it out.
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> > We have got a SQL server 2000 loaded on a Windows 2000 advance server. We
> had
> > created some DTS on this server which were scheduled to run on perticular
> > time. Few days back all the DTS started failing to execute through
> scheduler.
> > While checking from any client machine the DTS is running successfully but
> on
> > the server machine it is not. When I tried to open the DTS on the server
> > console Enterprise Manager it is giving me following error
> > Error Source : Microsoft OLE DB Provider for SQL Server
> > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
> > does not exists or access denied
> > I had tried with reinstalling the SQL Enterprise manager on the server,
> > reregistered the SQLDMO.dll but without any success.
> >
> >
> >
> > Can anybody help me'
> >
> >
> >
> >
> >
> >
>
>|||Well,that means that something was changed (an account, a password)
Are you sure?
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> It is created from the workstation but on the server. That means it is
saved
> on the server and scheduled on the server under SQlserver Agent account.
It
> was running still last few days. Now it is giving the problem. it is not
> giving me access to open the package also. it is giving me the error that
I
> had written.
>
>
> "Uri Dimant" wrote:
> > Hi
> > It is probably you creared the DTS on your workstation and not on the
> > server. If you schedule the DTS to run as a job it will be ran under SQL
> > Server Agent account. Check it out.
> >
> >
> >
> >
> > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> > news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> > > We have got a SQL server 2000 loaded on a Windows 2000 advance server.
We
> > had
> > > created some DTS on this server which were scheduled to run on
perticular
> > > time. Few days back all the DTS started failing to execute through
> > scheduler.
> > > While checking from any client machine the DTS is running successfully
but
> > on
> > > the server machine it is not. When I tried to open the DTS on the
server
> > > console Enterprise Manager it is giving me following error
> > > Error Source : Microsoft OLE DB Provider for SQL Server
> > > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
Server
> > > does not exists or access denied
> > > I had tried with reinstalling the SQL Enterprise manager on the
server,
> > > reregistered the SQLDMO.dll but without any success.
> > >
> > >
> > >
> > > Can anybody help me'
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >|||No there is no changes happend, I am able to Open the package and execute the
package from my client pc. But while doing the same on the sever console it
is giving me error. I am convienced that scheduler is not able to run the
package as server is giving the error.
This error is comming only on the Server's Enterprise Manager, not on any
client side.
"Uri Dimant" wrote:
> Well,that means that something was changed (an account, a password)
> Are you sure?
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> > It is created from the workstation but on the server. That means it is
> saved
> > on the server and scheduled on the server under SQlserver Agent account.
> It
> > was running still last few days. Now it is giving the problem. it is not
> > giving me access to open the package also. it is giving me the error that
> I
> > had written.
> >
> >
> >
> >
> > "Uri Dimant" wrote:
> >
> > > Hi
> > > It is probably you creared the DTS on your workstation and not on the
> > > server. If you schedule the DTS to run as a job it will be ran under SQL
> > > Server Agent account. Check it out.
> > >
> > >
> > >
> > >
> > > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> > > news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> > > > We have got a SQL server 2000 loaded on a Windows 2000 advance server.
> We
> > > had
> > > > created some DTS on this server which were scheduled to run on
> perticular
> > > > time. Few days back all the DTS started failing to execute through
> > > scheduler.
> > > > While checking from any client machine the DTS is running successfully
> but
> > > on
> > > > the server machine it is not. When I tried to open the DTS on the
> server
> > > > console Enterprise Manager it is giving me following error
> > > > Error Source : Microsoft OLE DB Provider for SQL Server
> > > > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
> Server
> > > > does not exists or access denied
> > > > I had tried with reinstalling the SQL Enterprise manager on the
> server,
> > > > reregistered the SQLDMO.dll but without any success.
> > > >
> > > >
> > > >
> > > > Can anybody help me'
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
>
>|||Still the only logical reason can be that there somehow is a difference
between your client and the server.
How do you log on on the server when you try to open the DTS via Enterprise
Mgr? Using your own account or rather via a (local) admin account on that
machine ?
If the latter, check if the sql-connection you speak about is based on a
Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
should verify (or even beter : try to simulate) the account used for
running the SQLAgent is able to connect to the requested database. Likely
something has changed the past week, they just forgot to tell you =)
Good Luck,
Roby
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...
> No there is no changes happend, I am able to Open the package and execute
> the
> package from my client pc. But while doing the same on the sever console
> it
> is giving me error. I am convienced that scheduler is not able to run the
> package as server is giving the error.
> This error is comming only on the Server's Enterprise Manager, not on any
> client side.
> "Uri Dimant" wrote:
>> Well,that means that something was changed (an account, a password)
>> Are you sure?
>>
>>
>> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
>> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
>> > It is created from the workstation but on the server. That means it is
>> saved
>> > on the server and scheduled on the server under SQlserver Agent
>> > account.
>> It
>> > was running still last few days. Now it is giving the problem. it is
>> > not
>> > giving me access to open the package also. it is giving me the error
>> > that
>> I
>> > had written.
>> >
>> >
>> >
>> >
>> > "Uri Dimant" wrote:
>> >
>> > > Hi
>> > > It is probably you creared the DTS on your workstation and not on the
>> > > server. If you schedule the DTS to run as a job it will be ran under
>> > > SQL
>> > > Server Agent account. Check it out.
>> > >
>> > >
>> > >
>> > >
>> > > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
>> > > news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
>> > > > We have got a SQL server 2000 loaded on a Windows 2000 advance
>> > > > server.
>> We
>> > > had
>> > > > created some DTS on this server which were scheduled to run on
>> perticular
>> > > > time. Few days back all the DTS started failing to execute through
>> > > scheduler.
>> > > > While checking from any client machine the DTS is running
>> > > > successfully
>> but
>> > > on
>> > > > the server machine it is not. When I tried to open the DTS on the
>> server
>> > > > console Enterprise Manager it is giving me following error
>> > > > Error Source : Microsoft OLE DB Provider for SQL Server
>> > > > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
>> Server
>> > > > does not exists or access denied
>> > > > I had tried with reinstalling the SQL Enterprise manager on the
>> server,
>> > > > reregistered the SQLDMO.dll but without any success.
>> > > >
>> > > >
>> > > >
>> > > > Can anybody help me'
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > >
>> > >
>> > >
>>|||In regards to the packages failing, you need to check the
job history for the DTS packages to determine why they are
failing. Checking the details in the job history will give
you more detailed information on why the packages are
failing to run as schedule.
-Sue
On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
<satyaki@.discussions.microsoft.com> wrote:
>We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
>created some DTS on this server which were scheduled to run on perticular
>time. Few days back all the DTS started failing to execute through scheduler.
>While checking from any client machine the DTS is running successfully but on
>the server machine it is not. When I tried to open the DTS on the server
>console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
>does not exists or access denied
>I had tried with reinstalling the SQL Enterprise manager on the server,
>reregistered the SQLDMO.dll but without any success.
>
>Can anybody help me'
>
>
>|||I had already checked that, it is giving same error server does not exists or
access denied. this is only happening on the server console enterprise
manager.
I don't thing it is any secured connection problem, nobody has change any
server configurations. Other activity on the enterprise manager is running
perfectly. I am facing this problem only on DTS package opening, may be due
to this the job scheduler is not running as job history is showing the same
problem.
"Sue Hoegemeier" wrote:
> In regards to the packages failing, you need to check the
> job history for the DTS packages to determine why they are
> failing. Checking the details in the job history will give
> you more detailed information on why the packages are
> failing to run as schedule.
> -Sue
> On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
> <satyaki@.discussions.microsoft.com> wrote:
> >We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
> >created some DTS on this server which were scheduled to run on perticular
> >time. Few days back all the DTS started failing to execute through scheduler.
> >While checking from any client machine the DTS is running successfully but on
> >the server machine it is not. When I tried to open the DTS on the server
> >console Enterprise Manager it is giving me following error
> > Error Source : Microsoft OLE DB Provider for SQL Server
> > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
> >does not exists or access denied
> >I had tried with reinstalling the SQL Enterprise manager on the server,
> >reregistered the SQLDMO.dll but without any success.
> >
> >
> >
> >Can anybody help me'
> >
> >
> >
> >
> >
>|||i am using sa login in the server enterprise manager to open the DTS. i had
tried with windows authentication, DTS creators login but without any result.
And no body has change any settings on the server/
"Roby Van Hoye" wrote:
> Still the only logical reason can be that there somehow is a difference
> between your client and the server.
> How do you log on on the server when you try to open the DTS via Enterprise
> Mgr? Using your own account or rather via a (local) admin account on that
> machine ?
> If the latter, check if the sql-connection you speak about is based on a
> Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
> should verify (or even beter : try to simulate) the account used for
> running the SQLAgent is able to connect to the requested database. Likely
> something has changed the past week, they just forgot to tell you =)
> Good Luck,
> Roby
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...
> > No there is no changes happend, I am able to Open the package and execute
> > the
> > package from my client pc. But while doing the same on the sever console
> > it
> > is giving me error. I am convienced that scheduler is not able to run the
> > package as server is giving the error.
> >
> > This error is comming only on the Server's Enterprise Manager, not on any
> > client side.
> >
> > "Uri Dimant" wrote:
> >
> >>
> >> Well,that means that something was changed (an account, a password)
> >> Are you sure?
> >>
> >>
> >>
> >>
> >> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> >> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> >> > It is created from the workstation but on the server. That means it is
> >> saved
> >> > on the server and scheduled on the server under SQlserver Agent
> >> > account.
> >> It
> >> > was running still last few days. Now it is giving the problem. it is
> >> > not
> >> > giving me access to open the package also. it is giving me the error
> >> > that
> >> I
> >> > had written.
> >> >
> >> >
> >> >
> >> >
> >> > "Uri Dimant" wrote:
> >> >
> >> > > Hi
> >> > > It is probably you creared the DTS on your workstation and not on the
> >> > > server. If you schedule the DTS to run as a job it will be ran under
> >> > > SQL
> >> > > Server Agent account. Check it out.
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> >> > > news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> >> > > > We have got a SQL server 2000 loaded on a Windows 2000 advance
> >> > > > server.
> >> We
> >> > > had
> >> > > > created some DTS on this server which were scheduled to run on
> >> perticular
> >> > > > time. Few days back all the DTS started failing to execute through
> >> > > scheduler.
> >> > > > While checking from any client machine the DTS is running
> >> > > > successfully
> >> but
> >> > > on
> >> > > > the server machine it is not. When I tried to open the DTS on the
> >> server
> >> > > > console Enterprise Manager it is giving me following error
> >> > > > Error Source : Microsoft OLE DB Provider for SQL Server
> >> > > > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
> >> Server
> >> > > > does not exists or access denied
> >> > > > I had tried with reinstalling the SQL Enterprise manager on the
> >> server,
> >> > > > reregistered the SQLDMO.dll but without any success.
> >> > > >
> >> > > >
> >> > > >
> >> > > > Can anybody help me'
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>

DTS opening error on server enterprise manager

We have got a SQL server 2000 loaded on a Windows 2000 advance server. We ha
d
created some DTS on this server which were scheduled to run on perticular
time. Few days back all the DTS started failing to execute through scheduler
.
While checking from any client machine the DTS is running successfully but o
n
the server machine it is not. When I tried to open the DTS on the server
console Enterprise Manager it is giving me following error
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Serve
r
does not exists or access denied
I had tried with reinstalling the SQL Enterprise manager on the server,
reregistered the SQLDMO.dll but without any success.
Can anybody help me'Hi
It is probably you creared the DTS on your workstation and not on the
server. If you schedule the DTS to run as a job it will be ran under SQL
Server Agent account. Check it out.
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> We have got a SQL server 2000 loaded on a Windows 2000 advance server. We
had
> created some DTS on this server which were scheduled to run on perticular
> time. Few days back all the DTS started failing to execute through
scheduler.
> While checking from any client machine the DTS is running successfully but
on
> the server machine it is not. When I tried to open the DTS on the server
> console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
Server
> does not exists or access denied
> I had tried with reinstalling the SQL Enterprise manager on the server,
> reregistered the SQLDMO.dll but without any success.
>
> Can anybody help me'
>
>
>|||It is created from the workstation but on the server. That means it is saved
on the server and scheduled on the server under SQlserver Agent account. It
was running still last few days. Now it is giving the problem. it is not
giving me access to open the package also. it is giving me the error that I
had written.
"Uri Dimant" wrote:

> Hi
> It is probably you creared the DTS on your workstation and not on the
> server. If you schedule the DTS to run as a job it will be ran under SQL
> Server Agent account. Check it out.
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> had
> scheduler.
> on
>
>|||Well,that means that something was changed (an account, a password)
Are you sure?
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> It is created from the workstation but on the server. That means it is
saved
> on the server and scheduled on the server under SQlserver Agent account.
It
> was running still last few days. Now it is giving the problem. it is not
> giving me access to open the package also. it is giving me the error that
I[vbcol=seagreen]
> had written.
>
>
> "Uri Dimant" wrote:
>
We[vbcol=seagreen]
perticular[vbcol=seagreen]
but[vbcol=seagreen]
server[vbcol=seagreen]
Server[vbcol=seagreen]
server,[vbcol=seagreen]|||No there is no changes happend, I am able to Open the package and execute th
e
package from my client pc. But while doing the same on the sever console it
is giving me error. I am convienced that scheduler is not able to run the
package as server is giving the error.
This error is comming only on the Server's Enterprise Manager, not on any
client side.
"Uri Dimant" wrote:

> Well,that means that something was changed (an account, a password)
> Are you sure?
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> saved
> It
> I
> We
> perticular
> but
> server
> Server
> server,
>
>|||Still the only logical reason can be that there somehow is a difference
between your client and the server.
How do you log on on the server when you try to open the DTS via Enterprise
Mgr? Using your own account or rather via a (local) admin account on that
machine ?
If the latter, check if the sql-connection you speak about is based on a
Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
should verify (or even beter : try to simulate) the account used for
running the SQLAgent is able to connect to the requested database. Likely
something has changed the past week, they just forgot to tell you =)
Good Luck,
Roby
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...[vbcol=seagreen]
> No there is no changes happend, I am able to Open the package and execute
> the
> package from my client pc. But while doing the same on the sever console
> it
> is giving me error. I am convienced that scheduler is not able to run the
> package as server is giving the error.
> This error is comming only on the Server's Enterprise Manager, not on any
> client side.
> "Uri Dimant" wrote:
>|||In regards to the packages failing, you need to check the
job history for the DTS packages to determine why they are
failing. Checking the details in the job history will give
you more detailed information on why the packages are
failing to run as schedule.
-Sue
On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
<satyaki@.discussions.microsoft.com> wrote:

>We have got a SQL server 2000 loaded on a Windows 2000 advance server. We h
ad
>created some DTS on this server which were scheduled to run on perticular
>time. Few days back all the DTS started failing to execute through schedule
r.
>While checking from any client machine the DTS is running successfully but
on
>the server machine it is not. When I tried to open the DTS on the server
>console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL S
erver
>does not exists or access denied
>I had tried with reinstalling the SQL Enterprise manager on the server,
>reregistered the SQLDMO.dll but without any success.
>
>Can anybody help me'
>
>
>|||I had already checked that, it is giving same error server does not exists o
r
access denied. this is only happening on the server console enterprise
manager.
I don't thing it is any secured connection problem, nobody has change any
server configurations. Other activity on the enterprise manager is running
perfectly. I am facing this problem only on DTS package opening, may be due
to this the job scheduler is not running as job history is showing the same
problem.
"Sue Hoegemeier" wrote:

> In regards to the packages failing, you need to check the
> job history for the DTS packages to determine why they are
> failing. Checking the details in the job history will give
> you more detailed information on why the packages are
> failing to run as schedule.
> -Sue
> On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
> <satyaki@.discussions.microsoft.com> wrote:
>
>|||i am using sa login in the server enterprise manager to open the DTS. i had
tried with windows authentication, DTS creators login but without any result
.
And no body has change any settings on the server/
"Roby Van Hoye" wrote:

> Still the only logical reason can be that there somehow is a difference
> between your client and the server.
> How do you log on on the server when you try to open the DTS via Enterpris
e
> Mgr? Using your own account or rather via a (local) admin account on that
> machine ?
> If the latter, check if the sql-connection you speak about is based on a
> Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
> should verify (or even beter : try to simulate) the account used for
> running the SQLAgent is able to connect to the requested database. Likely
> something has changed the past week, they just forgot to tell you =)
> Good Luck,
> Roby
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...
>
>