Frickin fracking g***amn locked down idiot nitwit domains!!!

Fracking place implemented / started enforcing a policy that prevents ANY accounts from having the "replace a process level token" privilege, thereby BREAKING...

Stefan Krzywicki (4/19/2013)

---

This is ... interesting. The town I live in is shut down for a manhunt. MBTA completely shut down. Thanks to the magic of technology, it is still...

Lynn Pettis (4/17/2013)

---

Brandie Tarvin (4/17/2013)

---

So I have this ridiculous thought of doing a series of articles for my blog on how to build a SQL Server database for a comic...

I may have found the solution to this...

It seems the SQL Agent Service Account may need the "Replace a Process Level Token" right. Seeing as the domain is locked...

Further note on this:

I tried logging into the server as the Proxy account, and was able to log in with no issues, copy a file, etc.

So the account does have...

Three days of nothing...

It's quiet...

TOO quiet...

Lynn Pettis (4/15/2013)

---

jasona.work (4/15/2013)

---

You want to use "With NoRecovery" not "With Standby."

Standby will roll back any uncommited transactions and put the DB in read-only. NoRecovery basically tells SQL Server...

You want to use "With NoRecovery" not "With Standby."

Standby will roll back any uncommited transactions and put the DB in read-only. NoRecovery basically tells SQL Server that there's more...

Webrunner, my home lab has been set up comparitively on the cheap, using VMs.

One Technet account (gives me both the OS and SQL) ~$350

One "home-brew" server (Xeon 55xx, 24GB RAM,...

Jack, I must apologize, as your answer was on the right track...

Turns out there's a few things I didn't know about the network here...

1. While *.domain.com is in the...

I hate Reporting Services in a locked down network...

That is all.

The security policies of the workplace don't allow users to add / remove entries from their Trusted Sites list. Also, the domain that the servers (both QA and prod...

Cool thanks!

I'll give it a go on Monday.

Jason

Won't that just create a new trace?

Or will it alter that setting for the existing trace?

Jason

You may still need to "re-associate" the SQL Login with the DB user.

I've found these two queries to do a bang-up job for finding and fixing orphaned users (and possibly...