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.
Showing posts with label loaded. Show all posts
Showing posts with label loaded. Show all posts
Wednesday, March 21, 2012
Wednesday, March 7, 2012
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...
>
>
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'
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>
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...
>
>
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...
>
>
Subscribe to:
Posts (Atom)