IT has our SQL server running under a normal domian user.. thus it is not able to run properly: get the error:

Cannot execute as the user 'RADAC\willis', because it...

Thanks, it works for me.. but even though I gave the uses execute access to the SP, it comes up with an error that the job does not exist. Is...

The account has access to SQL server... I have heard that to run SSIS through a job, the user has to have admin permissions... is this correct?

Lowell,

Thanks for your help.

You know ... I am begining to wonder if the problem lies in SSAS, I have passed this mornings information off to the team that handles our cubes.

If I just take the Individual Query and run an estimated plan

Plan A: it does not show any suggested index's .. you start with a Clustered Index Scan (cost 74%),...

This morning when it failed there were only 7 SIPDs running on the server, we can subtract two... one was the base Trace and the second was database mail.

So that...

Currently our Cost of THreshold for Parallelism is 5 and the Max Degree of Parallelism is 0.

We have 24 cores.

Does that change your suggestion any?

My data conversion is giving... Error at Data Flow Processing Data, conversion from DT_STR with code 65001 to DT_STR with code page 1252 is not supported... so just how do...

Just figured out that Data Flow Path Editor is not the place to make the change... Source Connection is.. then I have to do a data conversion, thank god for...

Erland Sommarskog (10/16/2013)

---

dwilliscp (10/16/2013)

---

So if you have one SPID, but 700 rows, that means the server is trying to do parallel processing? They all show CXPacket.. So how do I...

Willis02 is the name I am using to describe the link to the...

So if you have one SPID, but 700 rows, that means the server is trying to do parallel processing? They all show CXPacket.. So how do I track down whay...

I ran a trace.. and it added the following:

Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

dan-572483 (10/8/2013)

---

"Have you tried turning it off and on again?"

If you're able to schedule a downtime, do it. Simpley stopping the SQL Service and restarting will return the TempDB...