VBScript and ActiveX: CreateObject - Permission denied

[jpicks]

I posted this to the SQL Server Forum, but have not recieved any feedback. So I thought I'd try here.

I'm using MS SQL Server.

I have a DTS package that includes several ActiveX Script Tasks that write to a log file. The package runs fine on my machine and at the server using Enterprise Manager. I created a stored procedure that executes the DTS package using xp_cmdshell. I want to be able to call the stored procedure from an asp page to allow users to execute the DTS package.

The problem I am having is that the DTS package fails when I execute it using the stored procedure. I am recieving a VBScript Runtime Error: Permission Denied.

This error is occurring when I call CreateObject in my ActiveX script:

Set fso = CreateObject("Scripting.FileSystemObject&quot

I found a MS Knowledge base article that said that this error is due to the fact that SQL Server Agent does not have default access permissions set in the resistry.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q298725

I changed the permissions to include Administrators and changed SQL Server Agent from a local login to an Administrator login, but it did not seem to change anything.

Has anybody else had a similar problem?
Any Suggestions?

 

[JohnYingling]

Do you have some kind of anti-virus Script Blocking turned on that is specificall blocking FileSystemObject. I believe Norton has caused this problem on some machines.

But I'm also not sure about the effect of
Set fso = CreateObject("Scripting.FileSystemObject&quot
not going through Server.CreateObject.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[spazman]

If it is permisiions there is a DLL from Micrsoft that allows you to impersonate a user. I use it to get around the fact that the IIS user is not a domain user, when I need to access mapped drives.

Its simple to use the entire code in you VB wouls be like this.

Set objLogon = Server.CreateObject("LoginAdmin.ImpersonateUser&quot
objLogon.Logon "USERNAME" , "PASSWORD", "DOMAIN"

YOUR CODE HERE

objLogon.Logoff
Set objLogon = Nothing

But I can't find the KB article on the MS site where I found this. If you want this dll reply back to this post and I'll send it to you.

 

[dilettante]

Hmm. Have you looked at

http://support.microsoft.com/default.aspx?scid=KB;en-us;252711

to see if this fits your situation?

 

[jpicks]

Thanks for your replies.

-I don't have any anti-virus software running on the server.

-The code is running within a stored procedure, so it is running on the server.

-I can't logon as a different user, because the CreateObject is not supported and the stored procedure is executed by the SQL Server Agent Service. I have tried logging this service in as myself, Administrator on that box, and as a domain Administrator to no avail.

Any other ideas?

Thanks in advance.

-Jim