Check this:
In Backup Exec, go to Device tab, can you see the drive there?
If so, right click and see if ENABLED is checked. If not, go to properties and check the box for Enable device for Backup Exec.
If it's not showing up in BE, stop the Backup Exec services. Reboot your tape device. When the device is backup restart the BE Services.
Mark