Re: Cscript from a SQL Stored Procedure?

From: Carlos (Carlos_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 12:47:02 -0700

Sue,

Thank-you for your help. I revisted our security & proxy accout setup.
Turns out the proxy acccount we setup didn't have log-in permissions
to our Sql Server. The application that was calling the stored procedure
and making the xp_cmdshell call was on another server. Once I changed
the proxy account to a valid login on the Sql Server everything worked
fine. Again thanks!

Carlos

"Sue Hoegemeier" wrote:

> You may want to check the proxy account. When non-sysadmins
> execute xp_cmdshell, it will run under the security context
> of the SQL Server Agent proxy account. You'll want to check
> how the proxy account is configured and what permissions it
> has.
>
> -Sue
>
> On Mon, 25 Oct 2004 14:27:04 -0700, Carlos
> <Carlos@discussions.microsoft.com> wrote:
>
> >Hopefully, someone can help me out with this.
> >
> >I'm trying to run a .vbs script using cscript from a stored procedure that
> >gets called from a powerbuilder application (our commerce software)
> >that uses SQL SERVER 2000 as it's database.
> >
> >Basically we are trying to add code that calls the .vbs script so that when
> >an invoice prints it also calls the .vbs script to print a packing list as
> >well.
> >
> >The .vbs file simply formats some data, and creates a file.
> >
> >I can run everything fine from Query Analyzer, however when the
> >stored procedure gets called from the application. I get this error :
> >
> >CScript Error: Loading your settings failed. (Access is denied.)
> >
> >Here is how the .vbs script is being called :
> >
> >DECLARE @STR varchar(255)
> >SET @STR = 'cscript //nologo c:\PACKING_LIST.vbs 2265440 > c:\OUTPUT.DAT'
> >exec master..xp_cmdshell @STR, NO_OUTPUT
> >
> >2265440 is simply an invoice no passed in as a parameter.
> >
> >I've been able to establish that xp_cmdshell does run. Using :
> >
> >SET @STR = 'dir /p > c:\OUTPUT.TXT'
> >
> >I was able to get the directory listing redirected to the output.txt file
> >successfully.
> >However, when the stored procedure is being called from the application
> >'cscript'
> >doesn't seem to execute.
> >
> >Also our SQL Server is running under an administrator login, versus sa.
> >
> >Any help is appreciated.
> >
> >Carlos
> >
>
>

Relevant Pages

  • RE: ssis, sql job and windows authentication - how to impersonate
    ... You'll want to setup an agent proxy. ... I want to put this ssis on a sql server. ... Do not really want to give to this particular sql server agent account any ... different domain account there. ...
    (microsoft.public.sqlserver.dts)
  • LRe: Primary vs Secondary Site
    ... Proxy Management points are those installed from secondary sites. ... Clients can only be "assigned" to a primary site but when they sit within ... Proxy MPs, by default, will connect to their parent site's SQL server. ...
    (microsoft.public.sms.setup)
  • Connecting to SQL server 7 behind ISA server
    ... [ODBC SQL Server Driver] ... I can telnet the ISA external IP on both ports. ... I ran thru a similar problem when I configured it for the proxy 2 years ago ...
    (microsoft.public.sqlserver.connect)
  • Connecting to SQL server 7 behind ISA server
    ... [ODBC SQL Server Driver] ... I can telnet the ISA external IP on both ports. ... I ran thru a similar problem when I configured it for the proxy 2 years ago ...
    (microsoft.public.isaserver)
  • Re: Cscript from a SQL Stored Procedure?
    ... >Turns out the proxy acccount we setup didn't have log-in permissions ... >the proxy account to a valid login on the Sql Server everything worked ... >> of the SQL Server Agent proxy account. ...
    (microsoft.public.sqlserver.server)