Viewing 15 posts - 211 through 225 (of 6,105 total)
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,...
May 17, 2011 at 11:33 am
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...
May 17, 2011 at 9:28 am
What is the version of the operating system?
May 17, 2011 at 7:28 am
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...
May 17, 2011 at 7:27 am
In SQL Server 2008, the SQLAgentOperator role can, but they must do so via use of stored procedures.
May 16, 2011 at 11:32 am
Download procmon from SysInternals and see if there's a registry or file system hit that's causing the issue.
May 16, 2011 at 11:29 am
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...
May 15, 2011 at 4:11 am
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...
May 13, 2011 at 9:13 pm
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...
May 13, 2011 at 9:05 pm
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...
May 13, 2011 at 7:47 am
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...
May 12, 2011 at 4:35 pm
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...
May 12, 2011 at 12:13 pm
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...
May 11, 2011 at 11:47 am
tyson.price (5/11/2011)
- Under what security context does the back-end database get run?I don't know the answer to that. Maybe if you worded it differently.
Actually, I typed this wrong because...
May 11, 2011 at 10:00 am
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...
May 11, 2011 at 9:57 am
Viewing 15 posts - 211 through 225 (of 6,105 total)