External ssd fails to mount in fedora workstation

I have an external ssd that mounts fine in a fedora server box but fails to mount in a fedora workstation laptop (both fedora versions are 39). This is what sudo dmesg shows:

scsi 6:0:0:0: Direct-Access     ADATA    HDD CH94              PQ: 0 ANSI: 0
sd 6:0:0:0: Attached scsi generic sg2 type 0
sd 6:0:0:0: [sdb] 976773168 512-byte logical blocks: (500 GB/466 GiB)
sd 6:0:0:0: [sdb] Write Protect is off
sd 6:0:0:0: [sdb] Mode Sense: 03 00 00 00
sd 6:0:0:0: [sdb] No Caching mode page found
sd 6:0:0:0: [sdb] Assuming drive cache: write through
sdb: sdb1
sd 6:0:0:0: [sdb] Attached SCSI disk
sd 6:0:0:0: [sdb] tag#0 FAILED Result: hostbyte=DID_OK driverbyte=DRIVER_OK cmd_age=0s
sd 6:0:0:0: [sdb] tag#0 Sense Key : Illegal Request [current] 
sd 6:0:0:0: [sdb] tag#0 Add. Sense: Invalid command operation code
sd 6:0:0:0: [sdb] tag#0 CDB: Read(6) 08 00 08 00 08 00
critical target error, dev sdb, sector 2048 op 0x0:(READ) flags 0x80700 phys_seg 1 prio class 2
sd 6:0:0:0: [sdb] tag#0 FAILED Result: hostbyte=DID_OK driverbyte=DRIVER_OK cmd_age=0s
sd 6:0:0:0: [sdb] tag#0 Sense Key : Illegal Request [current] 
sd 6:0:0:0: [sdb] tag#0 Add. Sense: Invalid command operation code
sd 6:0:0:0: [sdb] tag#0 CDB: Read(6) 08 00 08 00 08 00
critical target error, dev sdb, sector 2048 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 2
Buffer I/O error on dev sdb1, logical block 0, async page read

I booted the laptop (the one on which I have fedora workstation installed) with an Arch Linux live USB stick and I can mount the external ssd succesfully.

Esternal ssd is formated with XFS filesystem.

Any ideas will be appreciated.

Thanks

Added xfs and removed server

You appear to be running workstation which as far as I know does not by default support the xfs file system.

You would need to load the xfs driver module before it could see that ssd.
This can be done in several ways, though I don’t use xfs and do not know the full details.

Once the driver is loaded then dracut would need to be run so the driver is included in the initramfs image. Once that is done then the driver should be available for each boot and the system would then be able to mount the device automatically.

Maybe someone who works with xfs can provide the details of how to load that module and ensure it is loaded with each boot.