There are a few posts out there to say that their .Net Framework was corrupt. I tested on our dev server, and going to Control Panels -- Add/Remove Program...

I, along with a system admin here, opened a ticket with Microsoft yesterday. We were on the phone with them for 3.5 hours and still no luck. I...

That is strange...sounds like some cache thing. ...

Schadenfreude-Mei (11/4/2008)

---

ahhh, ok scratch that last comment, hadnt seen you response.

Sounds stupid and im grasping at straws now but are they both defined in the same way in services.

I...

Schadenfreude-Mei (11/4/2008)

---

I'm being told that the 'Local Security Policies' has to be set so the account is in the 'Login as service' group, though not sure if this does or...

Schadenfreude-Mei (11/4/2008)

---

I work in a very heavily security concious environment and at one point found that although services.msc had said the account had been given logon-as-service rights did not actually...

Schadenfreude-Mei (11/4/2008)

---

Is this your only SQL server or a new server to your environment. If so why arent you using domain account to run the services? I always use one...

One more note -- I cannot log into SQL Profiler using windows auth -- I need to use a sql login.

I get the Login failed for user ''. ... ...

I rebooted the server and am getting the same results. 🙁

I ran the following and got NTLM...I think this should be kerberos instead - but, don't know for sure...

select...

I checked and NT Authority\system is sysadmin on the instance. I have added the login for the service as sysadmin -- but, not since a reboot of the server....

Ramu,

Thanks, I have tried starting with a local admin, and the built in accounts as well -- still the same error.

I have also tried starting it 3 different...

Thanks all. I just needed some confirmation. Enjoy the rest of your weekend. 🙂

Jen

Fraggle,

Thanks for the feedback. The situation I am most curious about was a connection from one of the web servers (to the database) that had a...

I believe the indexes are be defragmented in parallel.

Has anyone else encountered this?

Thanks for the tip, I will be sure to defrag the clustered indexes first if I do take...

Thanks for all of your input. I found my error -- more of a user error on this one. 🙂 The steps and jobs are running as...