 | |
Re: cmdExec Problem
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: cmdExec Problem -
08-11-2004
, 03:36 PM
|
hi, I am having problems with the Package Execution in Jobs. I created a Job and a step for the job to execute the Package with subsystem option is cmdExec (I think that's the right one) and dtsrun in the command line with options. If I run on the sql server client command line using dtsrun, it works fine. But, If I run the above created job using sp_start_job, then it is failing saying "nonsysadmin denied cmdExec job steps". How to fix the problem? I need to run the package on demand from .NET. Thanks, |
#2
| |||
| |||
|
|
Where do I see the SQL Server Agent Properties? I have only SQL Server Enterprise Edition Client installation. Does it show on server installation? Sreenath "Allan Mitchell" wrote: You need to look in SQL Server Agent properties. You can disallow/allow non sysadmins to run this type of job step -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message news:AFCDF631-3DCE-4610-995E-719955F0F9AC (AT) microsoft (DOT) com... hi, I am having problems with the Package Execution in Jobs. I created a Job and a step for the job to execute the Package with subsystem option is cmdExec (I think that's the right one) and dtsrun in the command line with options. If I run on the sql server client command line using dtsrun, it works fine. But, If I run the above created job using sp_start_job, then it is failing saying "nonsysadmin denied cmdExec job steps". How to fix the problem? I need to run the package on demand from .NET. Thanks, |
#3
| |||
| |||
|
|
Go to the SQL Server Agent of the Server on which your job runs in EM Right Click | Properties | Job System tab -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message news:2AA12D0C-F9F8-4A51-A1A4-4747656B71C3 (AT) microsoft (DOT) com... Where do I see the SQL Server Agent Properties? I have only SQL Server Enterprise Edition Client installation. Does it show on server installation? Sreenath "Allan Mitchell" wrote: You need to look in SQL Server Agent properties. You can disallow/allow non sysadmins to run this type of job step -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message news:AFCDF631-3DCE-4610-995E-719955F0F9AC (AT) microsoft (DOT) com... hi, I am having problems with the Package Execution in Jobs. I created a Job and a step for the job to execute the Package with subsystem option is cmdExec (I think that's the right one) and dtsrun in the command line with options. If I run on the sql server client command line using dtsrun, it works fine. But, If I run the above created job using sp_start_job, then it is failing saying "nonsysadmin denied cmdExec job steps". How to fix the problem? I need to run the package on demand from .NET. Thanks, |
#4
| |||
| |||
|
|
But, what kind of permissions/rights the non-sysadmin needs to run the job? thanks, Sreenath "Allan Mitchell" wrote: Go to the SQL Server Agent of the Server on which your job runs in EM Right Click | Properties | Job System tab -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message news:2AA12D0C-F9F8-4A51-A1A4-4747656B71C3 (AT) microsoft (DOT) com... Where do I see the SQL Server Agent Properties? I have only SQL Server Enterprise Edition Client installation. Does it show on server installation? Sreenath "Allan Mitchell" wrote: You need to look in SQL Server Agent properties. You can disallow/allow non sysadmins to run this type of job step -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message news:AFCDF631-3DCE-4610-995E-719955F0F9AC (AT) microsoft (DOT) com... hi, I am having problems with the Package Execution in Jobs. I created a Job and a step for the job to execute the Package with subsystem option is cmdExec (I think that's the right one) and dtsrun in the command line with options. If I run on the sql server client command line using dtsrun, it works fine. But, If I run the above created job using sp_start_job, then it is failing saying "nonsysadmin denied cmdExec job steps". How to fix the problem? I need to run the package on demand from ..NET. Thanks, |
#5
| |||
| |||
|
|
Thank you Allan, But, still I had some other problems with that approach. so, I followed the approach in www.sqldts.com/225 by registering the DLLs etc. Then I have having anothing problem of "Invalid Class String". It seems to me that the class id of the DTS Package is not matching. I am getting the following error in my log file: Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Invalid class string (Microsoft Data Transformation Services (DTS) Package (80004005): Invalid class string ) Step Error code: 800401F3 Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100 HOw to solve this? "Allan Mitchell" wrote: Have a look at this http://support.microsoft.com/?kbid=269074 -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message news:A54BBBDF-229D-49E9-9485-4BBD78F46933 (AT) microsoft (DOT) com... But, what kind of permissions/rights the non-sysadmin needs to run the job? thanks, Sreenath "Allan Mitchell" wrote: Go to the SQL Server Agent of the Server on which your job runs in EM Right Click | Properties | Job System tab -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message news:2AA12D0C-F9F8-4A51-A1A4-4747656B71C3 (AT) microsoft (DOT) com... Where do I see the SQL Server Agent Properties? I have only SQL Server Enterprise Edition Client installation. Does it show on server installation? Sreenath "Allan Mitchell" wrote: You need to look in SQL Server Agent properties. You can disallow/allow non sysadmins to run this type of job step -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message news:AFCDF631-3DCE-4610-995E-719955F0F9AC (AT) microsoft (DOT) com... hi, I am having problems with the Package Execution in Jobs. I created a Job and a step for the job to execute the Package with subsystem option is cmdExec (I think that's the right one) and dtsrun in the command line with options. If I run on the sql server client command line using dtsrun, it works fine. But, If I run the above created job using sp_start_job, then it is failing saying "nonsysadmin denied cmdExec job steps". How to fix the problem? I need to run the package on demand from ..NET. Thanks, |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.