GSquared (11/29/2011)

---

(By the way, a few laps around the building/block/parking lot/whatever, just clearing thought-debris and looking at scenery, can be very, very helpful to getting a clear concept of whatever...

Back in college, I got a lot of odd looks when people saw my two (and later three) 19" CRT monitors on my huge desk. Working after college, I brought...

Just wanted to say thanks for all the input! I settled on putting tempdb in with the mdfs on the RAID 10. The single production log will remain...

russell (10/26/2007)

---

In your case:

If there is only ONE .ldf on the log drive, I'll put tempdb log AND data file on the data drive.

If there is more than one .ldf...

While I'd love to put tempdb on its own RAID, I have to settle for sharing, at least for now. And I really don't like the idea of sharing...

Thanks Brian. I'll be reviewing the backup and optimization job histories to see if I need to make any adjustments. Sundays have always been a zero-activity day for...

Ran kill 63 with statusonly and discovered the rollback was 100% complete, meaning the process was orphaned. So, I killed the two backup processes, checked their rollback statuses, and...

Well, for now I'm gonna let it sit, see if the rollback runs its course. Based on history, I figure it'll finish before 2am. Then I'll kill the...

FYI: I just tried this on SSRS 2005 (no SP) and it still works. Saved me a ton of time, too!

Thanks..

..jeremy.

This article also has a good explanation of what's going on.

I noticed the same thing when we added optimization to our weekend routine. We ran a nightly full...

Yeah, SSRS is meant more for orgs that have a development staff that can build onto it. It is not meant as a turnkey solution except for the simplest...

Well, shucks. I think this is the first time I've not received a response here! When I do find an answer, I'll be sure to post it.

Responses thus far have focused on the server not accepting connections via tcp/ip. Could it be that the client requesting connection is at fault, instead?

SQLBill: tried removing my sql login (it did match), but that did not solve the problem. However, that's not to say it wasn't a problem, just that there...

Thanks for responding, SQLBill.

I think you're right about not getting my credentials. Running a profile, I noticed that information that came through when logging in from the terminal server...