Older versions of SQL Server did not have a role that allowed execution of all stored procedures. You can get around this by granting EXECUTE on an entire schema:
GRANT EXECUTE ON SCHEMA :: dbo TO [username]
Older versions of SQL Server did not have a role that allowed execution of all stored procedures. You can get around this by granting EXECUTE on an entire schema:
GRANT EXECUTE ON SCHEMA :: dbo TO [username]