August 10, 2013 at 5:00 am
We have a shrink job from maintenance plan. When the owner is sa, job gets completed within 2 min. But if the owner is changed to a windows login, it continue running. Any idea why this happen?
I guess, this might be permission issue. The windows account might be permission issue on the drives where the database files are located. Please advice.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
August 10, 2013 at 3:21 pm
Is it a local windows account or domain account?
I've dealt with issues where the account was unable to resolve the domain and the job hangs or fails.
Does the job consistently hang or does it also fail?
August 12, 2013 at 12:16 am
Hi,
The eventviewer is showing "Windows cannot determine the user or computer name (The RPC Server is unavailable). Group Policy Processing aborted"
The job takes 1 hr to complete which usually takes 2-3 min when owner is SA.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply