Forum Discussion

Matt_58992's avatar
Matt_58992
Icon for Nimbostratus rankNimbostratus
Nov 04, 2016

Unable to setup MSSQL Database profile - Option Does not Exist

Running 12.1.1 Build 1.0.196 HF1 however i've looked on an 11.5.1 and 12.0 appliance and they don't have the option either.

 

Trying the guide located here: https://support.f5.com/kb/en-us/products/big-ip_ltm/manuals/product/ltm-implementations-12-1-0/18.html

 

The step called: Configuring database access by user

 

On the Main tab, click Local Traffic > Profiles > Databases > MS SQL . The MS SQL Profiles list screen opens.

 

There is no "Database" profile anywhere. I also don't see any iApp or other download to add it. What am I missing?

 

application delivery
LTM

6 Replies

Sort By
  • Samir_Jha_52506's avatar
    Samir_Jha_52506
    Icon for Noctilucent rankNoctilucent
    Nov 04, 2016

    Matt, its Datebase monitoring profile which will apply to pool for checking status of pool member(mysql database).. You will only see in monitor option not on profile.

     

    Go to LTM-->Monitor-->Create-->type "MYSQL"

     

    • Matt_58992's avatar
      Matt_58992
      Icon for Nimbostratus rankNimbostratus
      Nov 04, 2016

      That's the Monitor creation and that works fine - this is actually a profile type, at least as specified in the documentation.

       

      see below: Click Create. The New MS SQL Profile screen opens. In the Profile Name field, type a unique name for the MS SQL profile, for example, mssql_user_access. Select the Custom check box. From the Read/Write Split list, select By User. From the Read Pool list, select the pool of MS SQL database servers to which the system sends read-only requests. From the Write Pool list, select the pool of MS SQL database servers to which the system sends write requests. From the Users Can Write By Default list, select Yes to give write access to all users, except those in the Read-Only Users list. In the Read-Only Users area, add users to whom you want to provide read-only access to the database. Click Finished.

       

    • shawnhirsch_185's avatar
      shawnhirsch_185
      Icon for Nimbostratus rankNimbostratus
      Nov 05, 2016

      You need to upgrade your license if that database profile is missing.

       

  • WendiC_287269's avatar
    WendiC_287269
    Icon for Nimbostratus rankNimbostratus
    Dec 07, 2016

    Hey Matt, did you get an answer for this that makes sense? I found info that said LTM license is all that's needed, but mine is missing too (I'm on 12.1). I opened a support case but was just wondering if you got any info that helped.

     

    Thanks!

     

  • JWhitesPro_1928's avatar
    JWhitesPro_1928
    Icon for Cirrostratus rankCirrostratus
    Dec 07, 2016

    It's part of the "advanced protocols" license. I also heard it was going away though...

     

    • WendiC_287269's avatar
      WendiC_287269
      Icon for Nimbostratus rankNimbostratus
      Dec 07, 2016

      Got a response from support that it's part of that license but they didn't say anything about it going away! Have you heard of a reasonable alternative for triggering on SQL requests? Right now I'm just looking at TCP collect and payload, but I'm not sure that's going to work. :/