ASP Error

[flitzender_elch]

Hy,

i get a error on a asp-site:

Serverobjekt Fehler "ASP 0177 : 8007007e'
Server.CreateObject-Fehler
/2hand/test.asp, line 16
8007007e

Line 16 on test.asp is
Set oPkg = Server.CreateObject ("DTS.Package")

Backround:
I hava a server with windows 2003, Plesk 8.1, MSSQL-2000 with sp4 and all available updates für windows and plesk are installed.

Have anybody an idea?

The test.asp on a windows 2000 machine with mssql2000, without plesk, work without any problem...

 

[Bogdan]

Can you please check that you have sufficient permissions to run that DTS package using your code?

You may want to check the 'Possible Permissions Issues' section in http://support.microsoft.com/kb/252987

 

[flitzender_elch]

Thanks, for the answer.

But which permissions are needed the IUSR_xxxxx?

On line 17 i delivery the login for a account that have all permissions on the sql-server.

Line 17
oPkg.LoadFromSQLServer sServer, sUID, sPWD, iSecurity , sPkgPWD, "", "", sPkgName

 

[flitzender_elch]

Addition:

Where i set the permission? In SQL-Server or on Windows?

 

[flitzender_elch]

I have the answer for the problem!!!!!!!!!

Yes........

Plesk set permissions on all windows-folders, the group psacln and psasrv access denied for every folders.

Also for the folder C:\Programme\Microsoft SQL Server\80\Tools\Binn
in this folder located all the dll's to run the dts-package, you must set access for the group psacln for this folder and all files under there.
Then you can run the dts-package without any problem.


sincerely,

Peter G.

 

[sergius]

Originally posted by flitzender_elch
Plesk set permissions on all windows-folders, the group psacln and psasrv access denied for every folders.

Also for the folder C:\Programme\Microsoft SQL Server\80\Tools\Binn
in this folder located all the dll's to run the dts-package, you must set access for the group psacln for this folder and all files under there.
Then you can run the dts-package without any problem.

I wish caution against you allow access to system dll for all end-users. Please do it only for trusted persons.