Viewing 15 posts - 2,221 through 2,235 (of 9,720 total)
Ed Wagner (11/5/2015)
First of all, don't forget to revoke that CONTROL SERVER permission you granted earlier. 😉
Did that as soon as I figured out it didn't work.
I thought you were...
November 5, 2015 at 9:15 am
BWFC (11/5/2015)
I've been asked to look into ad-hoc reporting solutions so users can create their own reports.
All I know is it's a SQL Server...
November 5, 2015 at 6:02 am
AAAAAAHHHHHH!
create credential ##xp_cmdshell_proxy_account## with identity = 'Domain\DomainUser', secret = 'password'
This let me create the credential for the service account without having to create a proxy account (which...
November 5, 2015 at 5:56 am
Ed Wagner (11/4/2015)
November 5, 2015 at 5:34 am
Ed Wagner (11/4/2015)
Hopefully, you're creating the procedure WITH EXECUTE AS OWNER instead of granting permission to the login.
I have not tried this yet. The login does need access to certain...
November 5, 2015 at 4:48 am
Erland Sommarskog (11/4/2015)
Logon failure: the user has not been granted the requested logon type at this computer.
But if this was a permission issue on the NAS, I...
November 5, 2015 at 4:45 am
Okay, so the problem is that I can't post the code for my stored procedure. Grrrrr.
See attached text file.
November 4, 2015 at 1:13 pm
EDIT: YAY! I can post now! Except when I try to post the additional info, it craps out on me... Let me try without the code bit and see if...
November 4, 2015 at 1:10 pm
Michael L John (11/4/2015)
Was it this link?http://www.sqlservercentral.com/Forums/Topic527155-359-1.aspx#bm1733766
Nope. It's this one: http://www.sqlservercentral.com/Forums/Topic1733767-1526-1.aspx
November 4, 2015 at 11:54 am
And apparently it's just that thread. How terribly annoying.
November 4, 2015 at 11:49 am
Trying to reply to a post that I just put up in SQL 2008 -> Security and suddenly when I hit "post reply" it can't find sqlservercentral.com. So this is...
November 4, 2015 at 11:49 am
Chowdary,
Just a quick recommendation. Find a place to store a copy of what permissions you give what users. It's really hard to maintain column and table level permissions when new...
November 4, 2015 at 11:28 am
So apparently this thread comes up in a search of xp_cmdshell errors. For those who stumble across this thread in the future, the above post is BAD. Do not grant...
November 4, 2015 at 11:19 am
djj (11/4/2015)
I also interview really badly.
Bridge Guardian: What is your name?
DJJ: Umm. I don't know?
DJJ: AGGGGHHHHH!
Bridge Guardian: Sigh. Usually they get to the swallow question before they go flying off...
November 4, 2015 at 11:16 am
Lynn Pettis (11/4/2015)
Plus, I am trying to convince my supervisor to send me back to Afghanistan for 6 months in June next year.
Is the tea really that good?
November 4, 2015 at 10:11 am
Viewing 15 posts - 2,221 through 2,235 (of 9,720 total)