BIG-IPLTM supports only basic authentication when acting as a proxy for an MS SQL database. You must configure user names and passwords on the database servers and the database servers must handle user authentication. Therefore, the user names and passwords must be synchronized across all database servers.
You can configure BIG-IP LTM for user-based access to database servers. With user-based access, you configure a pool of database servers and indicate whether users write by default. Then, you configure either a read-only list of users or a write-enabled list of users.
Ensure that a custom MS SQL monitor exists in the configuration.
Optionally, you can create a custom OneConnect profile. With this profile, the LTM system minimizes the number of server-side TCP connections by sharing idle connections among TDS connections owned by the same user name.