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

Jeff_Nyquist_44's avatar
Jeff_Nyquist_44
Icon for Nimbostratus rankNimbostratus
Mar 26, 2010

MS SQL Database Redirect

I have a problem that I am wondering if iRules can assist with.     We have a MS SQL server running 120-150 databases. Unfortunately, we only have a single generic "token" that the develop...
application delivery
dev
devops
iRules
Nat_Thirasuttakorn's avatar
Nat_Thirasuttakorn
Icon for Employee rankEmployee
Mar 26, 2010
I am not MSSQL export so I might be wrong.

 

I think this might be possible if you just want to balance based on tcp connection (not by request inside tcp connection) and there is unique information in pre-login message (assume it is TDS protocol). you may take packet capture and check first tcp payload from client to find unique information (for example, database instance name)

 

 

btw, I am not sure what do you mean by generic "token". could you provide more information? how does client connect to database?