The reason is that with SQL Server 2008 and higher and Windows Server 2008 and higher, access to resources is secured via a SID tied to the SQL Server service,...

Search connect.microsoft.com for a submitted request, because likely there is one. The more folks that indicate that a feature is wanted or a bug is a problem, the more likely...

What is the version of the operating system?

Books Online: SQL Server Agent Fixed Database Roles

Covers roles, permissions, etc. From that page:

3 SQLAgentOperatorRole members can enable or disable local jobs they do not own by using the stored...

In SQL Server 2008, the SQLAgentOperator role can, but they must do so via use of stored procedures.

Download procmon from SysInternals and see if there's a registry or file system hit that's causing the issue.

If you uncheck password expiration, no they won't expire. This is the same as in Windows where you check "Password never expires" for a Windows user account. The rest of...

The action will be carried out as you. Do you have permissions to the log folder? I know you're likely an administrator, but you probably want to check permissions. The...

Start/Stop a Service is an operating system function. For SSMS, that means it actually performs it under the context of the user who start SSMS. Unless you used runas, that...

SQL Server is default DENY. So if the user doesn't have explicit permissions, is not a member of a role that gives implicit permission (note: I hate these), or ownership...

The short answer is, "You can't." Each databases security is independent.

There are really two ways to handle this:

Ownership Chaining:

You can turn on ownership chaining on both databases (don't do it...

Since CCR does not own the dbo schema, you must give permission to ALTER it, too.

GRANT ALTER ON SCHEMA::dbo TO ccr;

However, you probably want to create a role, given the...

Ugh. In that case I would move it off to its own instance and lock that instance down using Logon Triggers. There's not a whole lot of other options available...

Actually, I typed this wrong because...

Things I have come to accept over time:

- If I depend on my organization to take care of my technical skill set and level of competence and they don't and...