Forum Replies Created
Viewing 15 posts - 16 through 30 (of 111 total)
-
RE: Job reported: Unable to terminate process (reason: Access is denied)
Update the developer modified the task to run sequentially instead of having the SSIS package launch the various modules in parallel and it has ran for the last couple days...
-
RE: Job reported: Unable to terminate process (reason: Access is denied)
I do not know if it is wise or not but we run several different SQL Server installations using the same domain username for the SQL Service account and the...
-
RE: Job reported: Unable to terminate process (reason: Access is denied)
No, remember the job sometimes worked initially and then stated to fail as often as not. The job history only has three days in it as of today so I...
-
RE: Job reported: Unable to terminate process (reason: Access is denied)
I will have to inquire on executing the SP as the SQL Server user. All of the SP execute fine when executed as the Application user.
-
RE: Job reported: Unable to terminate process (reason: Access is denied)
The job runs at the SQL Agent user which is the same as the database server user and the user is a System Administrator on the box.
- -
The... -
RE: Job reported: Unable to terminate process (reason: Access is denied)
SSCertifiable, I have asked the developer about your concerns on some of the routines running twice.
- -
Here is the developer response >> -
RE: Job reported: Unable to terminate process (reason: Access is denied)
Here is the description of the diagram boxes:
There is a procedure under everytask as shown in diagram below.
-
RE: Job reported: Unable to terminate process (reason: Access is denied)
Here is the SSIS package functionality as provided by the developer. I have asked for a brief description of what each box does.
-
RE: Job reported: Unable to terminate process (reason: Access is denied)
All,
1- I have asked the developer for a detailed but still high level description of what the packages does. I will post back when I get it. Last night... -
RE: Create EndPoint
Why not just revoke connect on the endpoint from the user? That is, after you in fact determine the privilege is on an end-point and not something else.
-
RE: Executing as my own context
Appear where?
-
RE: Executing as my own context
I haven't looked at the details but if EXECUTE AS SELF runs the stored procedure as the owner then I do not consider that dangerous at all as this improves...
-
RE: Function to count set bits in a signed integer
Unless I typed over the comment by accident there is an error in the comments since BitsIn returns 4 for an input of 15 while the comment lists 3 as...
-
RE: Investigate Report Server Security
Thanks. I had tried a search in my downloaded version of Books Online but I just found a slew of hits for general articles on the system views and...
-
RE: Investigate Report Server Security
That is what I thought and used though I use "?" instead of "" for unknown. By the way do you know what a type = 8 would be?...
Viewing 15 posts - 16 through 30 (of 111 total)