Fill in the SP and User you want to run the SP and execute in Query Analyzer. The [User] should be the User ID you are using in your connection string.

Code:
Grant Execute on [Stored Procedure] to [User]