It's certainly possible and not all that rare. Personally, I would never take my wife and my dog in a sailing canoe - mostly because they're both extremely hard-headed and neither of them follows directions (at least MY directions) worth a damn. As in any small boat which tends to lean over, there is a certain amount of trust involved and if the wind comes up, somebody needs to be in charge.
In good conditions, the boat should do fine with the load, although sailing is all about weight - weight aloft, weight to counterbalance heeling force, weight in the ends of the hull (which tends to slow your ability to spin it when maneuvering) and weight which needs to be accelerated back up to cruising speed after every tack or jibe. Lucky for us, canoes are also pretty much all about weight and so we're used to the fact that more weight in the boat takes more force to move. There will be days when the sailing canoe feels a bit sluggish with two aboard, compared to solo sailing, but you may also find days when having a passenger and the extra ballast that they provide is helpful.
You are most likely better off if you can put both people fairly close to the middle of the canoe - maybe sitting on the floor in the sections forward of, and aft of, the center thwart. You have more beam there and more ability to slide sideways a little bit when needed for ballast. It also keeps the weight away from the ends. Like any sailing canoe though, you will have to work with (or around) whatever structure the hull and sailing rig installation yields, so there is a pretty big fudge factor if needed.
If two people get used to sailing a canoe together, there may be some really interesting boat-control possibilities down the line if you learn to work together smoothly. Both fore-and-aft trim and heel angle are major factors affecting where the hull wants to go and how badly it wants to go there. Two people making coordinated efforts to specifically affect these factors at the right time could have a major effect on the canoe's ability to maneuver, tack, jibe, etc. - - up to, and possibly even including, "Throw away the rudder because we really don't need it any more".