Does remote access on mssql have to be enabled for monitoring to work?

The BigIP SQL monitors work by sending SQL queries to the pool members. If they're not listening for SQL connections from remote devices, then obviously those queries will not succeed.

Alternatively, you could use a different type of monitor, such as a ping, or tcp connection, but that wouldn't give you the same level of monitoring that an actual SQL query would provide.