Much really depends on the SCSI adapter. Does it include an external interface? Is it a multi-channel or single-channel adapter? What other SCSI devices do you have connected to the adapter?
The SureStore DAT40 uses a Wide Ultra-2 interface. While this will work with a standard Ultr-2 adapter, theoretically, you are losing half the possible transfer speed (Wide Ultra-2 - 80 MBps vs. Ultra-2 - 40 MBps). However, since the DAT 40 only has a max sustained (compressed) transfer rate of 21.6MBps, in reality you aren't losing anything.
Therefore, as long as your SCSI adapter includes an external interface, and you have 6 or fewer other SCSI devices connected (Ultra-2 standard allows a max of 8 SCSI devices (including adapter); Wide Ultra-2 standard allows a max of 16 SCSI devices (including adapter)), you should be able to use your existing adapter.