If you don't terminate (or don't terminate correctly), the device might still enumerate correctly (i.e. it is seen), but transmissions will most certainly fail. You should see the SCSI driver's complaints in the system event log.
The operating mode of the SCSI chain can be expected from the "verbose" screen output of the LSI BIOS. It'll tell you the detected drives, and the planned transfer speed and width toward each device. If it's LVD (it's not, given the controller you're using) you need an LVD terminator or a multimode one, if it's single-ended UltraSCSI (20 MB/s with Narrow cabling, 40 MB/s with Wide cabling) you'll need an Ultra certified "active" terminator, and with all slower SE modes, you /should/ have active termination but don't /have/ to.
Also, you need to make sure that termination /power/ is supplied to the cable. The LSI controller does that, but the drive on the far end of the cable should do so too. Check the jumpers, and while you're at it, check whether the tape drive happens to have onboard termination itself.
Six feet is a tad optimistic for single-ended "Ultra" mode, but feasible with two devices and really good cable.
The LSI BIOS lets you limit the SCSI mode to a lower speed than auto-negotiated - per controller channel, and/or per individual device. This is your last resort if you don't get it going at the best possible speed despite doing everything else correctly.