Well I might have some good news for you! After A LOT of trial and error and BSOD and hitting things...it works! I am writing this connect through the the card! There is a unique set of steps to make it work.
Go to:
https://support-nic.xilinx.com/wp/drivers
Go to windows
Go to SFN5000, SFN6000, SFN7000 and SFN8000 series adapters
Download the
Windows x64 (64-bit) Driver Package version 4.12 package.
Make sure you card is NOT connected to your computer.
Install this .exe as admin with all options
Once its done don't restart yet.
Disable current network port
Turn off PC
Install the card in your computer DO NOT connect any cables to it! This causes it to pull drivers from windows and f*** it up so we purposely don't want any internet access.
Turn on the PC: hopefully it finally passes the BSOD
Go to device manager
> Network adapters
You should see Solarflare Server Adapter with probably a yellow exclamation point
Right click and update drivers
Browse my computer
Let me pick
It should have you pick the type so go pick network adapter
Then select have disk
Navigate to the drivers installed from the .exe which should be at: C:\Program Files\Solarflare\Solarflare Driver Package
Go into the drivers folder
Select SFN6 go in that folder then click open or ok whatever it says to select that location
Then install the driver and you should be good to go!