RE: XP_CMDSHELL & RS.EXE and access rights

SSC Guru

Points: 1003888

February 25, 2017 at 3:38 pm

#1930357

John Mitchell-245523 - Friday, February 24, 2017 5:19 AM
Have you tried running SQL Server under a named Windows account (either domain or local) instead?
John

+1000 to that. For the most part, the SQL Server Login should be assigned as a regular Windows user for reasons just like this one.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)