For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

Matt_58992's avatar
Matt_58992
Icon for Nimbostratus rankNimbostratus
10 years ago

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/prod...
application delivery
LTM
Samir_Jha_52506's avatar
Samir_Jha_52506
Icon for Noctilucent rankNoctilucent
10 years ago

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
    10 years ago

    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
    10 years ago

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