Interview Question in Data Transformation Services (DTS)
Interview Question :: Active X Cannot Create Object - permissions sql server 2005, why
I am having problems instantiating a object. I know this is down to permissions but I am not sure what steps to follow in resolving. Basically I have a asp.net application which calls a stored from sql server 2005. In this stored procedure I am using DTSRUN to kick off a DTS package. Within the DTS package I have a execute process task which call a vb appliocation. It is within the dts application that I instantiate an object but when call this from stored procedure it fails, within EM it's successful.
I know this is down to permissions (sql server service, agent service, sql proxy account, etc...) but I am not sure how to determine what account is actually running the exectue process tasks.
if I am executing stored proc from asp.net on sql server 2005, what account is executing my VB - .exe program file file?
Loading ...