Except as otherwise provided by law, service shall be made by the sheriff of the parish where service is to be made or of the parish where the action is pending.