BWFC (11/5/2015)

---

Woolly nebulous request of the month alert.

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...

AAAAAAHHHHHH!

Found it! Found it!

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...

Ed Wagner (11/4/2015)

---

If that's the case, then try recreating the procedure and tell it to execute as you and grant execute on the procedure to the login being used by...

I have not tried this yet. The login does need access to certain...

Erland Sommarskog (11/4/2015)

---

NET HELPMSG 1385 says:

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...

Okay, so the problem is that I can't post the code for my stored procedure. Grrrrr.

See attached text file.

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...

Nope. It's this one: http://www.sqlservercentral.com/Forums/Topic1733767-1526-1.aspx

And apparently it's just that thread. How terribly annoying.

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...

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...

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...

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...

Is the tea really that good?

Jeff Moden (11/3/2015)

---

Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed "expert" Database Developer. It amazing how they don't know...