So these are pre-exisiting stored procedures created where - in the SCCM database? They were created by Remedy themselves? Any word in their documentation on this? From: [email protected] To: [email protected] Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Date: Mon, 2 Jun 2014 20:30:12 +0100
Thanks for all the replies (x2 Jason ;-) Yes this is CM12 SP1 and the reason for doing this (sorry should have said), is to have the Scheduled Tasks run to dump the data into the CSVs from where they can be imported to Remedy. I’m inheriting this solution – agree it’s not the most elegant but my brief is purely to get it working which it isn’t at the moment as seems to be permission-related (if I run the Scheduled Task as my Admin account works fine, but not when they use the Service Account they’ve created). Sure I could clone my admin account but that would give the Service Account too many permissions and access to things it shouldn’t have. Many thanks and kind regards,Cliff From: [email protected] [mailto:[email protected]] On Behalf Of Jason Wallace Sent: 02 Jun 2014 16:48 To: [email protected] Subject: RE: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? Yes, I also responded in kind elsewhere. Also (for info) pointed to using Excel directly on the database http://blogs.technet.com/b/manageabilityguys/archive/2013/04/11/mms-2013-udb-338-additional-content.aspx was an excellent MMS session on this Date: Mon, 2 Jun 2014 08:40:01 -0700 From: [email protected] Subject: Re: [mssms] Permissions to run SQL Stored Procedures to extract data from the Site Database? To: [email protected] may be "devil's advocate"... but is this CM? and that database is the CM database? If so, what's the blocker to use SRS, creating a report with whatever it is you need to dump, and in SRS scheduling that to run and export the results in CSV to a share somewhere? (or email it to some poor admin) Sherry KissingerOn Monday, June 2, 2014 9:58 AM, Cliff Hobbs <[email protected]> wrote: Hi all, I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I’m not overly sure what permissions are required on the SQL side to get this to work. Ideally I’d like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that’s it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards,Cliff
