When you would like to monitor a Microsoft product like MSSQL server you need to make sure that your user belongs to the Performance Monitor Users group on the server you are trying to monitor.

You get an "Access denied" that means that your user does not have sufficient rights to monitor your machine.

For more information please look at the NeoLoad documentation here