Execute Stored Proceedure from Excel

Last Post 11 Nov 2011 09:57 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
duke442games
New Member
New Member

--
11 Nov 2011 08:00 AM

I have created an excel file that calls a stored procedure to allow users to fetch data on demand. I cannot save the login string in the excel connection. How do I grant all users the ability to run the stored proceedure? I am running SQL server 2008 if that makes any kind of a difference.

I used these instructions for how to call the stored procedure with out using VBA.
http://blogs.office.com/b/microsoft...o-vba.aspx

Any help would be greatly appreciated. I need to get this data out ASAP.

Thank you!

rm
New Member
New Member

--
11 Nov 2011 09:57 AM
You may create app role in the db and grant exec permission to that sp, then use app role in excel when make sql connection.


Acceptable Use Policy
---