Forum Discussion
BLopes
Nimbostratus
NimbostratusF5 LTM - SQL Virtual Server
Hi all, I've implemented a F5 with several vips and now I need to create one more but for SQL. This one will must to handle the request. For example, when the SQL request is made to vip_db1.locald...
BLopesNimbostratus
NimbostratusHi Mike757,
I'm not also an specialist in SQL, but the information that I have from the costumer is that in that server have some instances of SQL, and this is the way that we call the instances.
This need appears because one partner is installing a solution that not suport this, he can not in is aplication tell what is the sql instance that to need to access.
Thanks.
Mike757
MVP
MVPI don't want to make you unhappy, but I think I will...
That I know of, there are no SQL iRule commands like there are for HTTP. So this kind of manipulation seems to be impossible. LTM's role in this scenario would be only up to layer 4.
If the client does not support named SQL instances, the only way I see for this to work is to use default instances. From https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-instances-sql-server?view=sql-server-ver16 :
« If a connection request specifies only the name of the computer, the connection is made to the default instance. A named instance is one where you specify an instance name when installing the instance. A connection request must specify both the computer name and instance name in order to connect to the instance. »
Maybe you'll have to work around this "feature". I really have no ideas, and it seems there were no other takers for your question 😢
/Mike