MSSQL Health Monitor Issue
We're currently using the F5 to load balance across read-only shards for a specific feature within our infrastructure. I have had success getting a MSSQL monitor to work initially, but every time the backend servers are rebooted, the monitor stops functioning. If I make enough cosmetic changes to the health monitor, it eventually works again. What's odd is if I connect via management studio to the backend nodes and run the exact query in the monitor (with same credentials), the receive string is what is expected. If I change the pool's monitor to a basic TCP connect, and then connect via management studio to the VS's IP, I can execute the health monitor successfully. But if I set the actual monitor on the pool, it's still not functional. The monitor is doing a simple select to a function that returns a single row/column with a 0 or 1 to signify whether the service is available for use. Any thoughts on what might be the issue here? F5 Software: BIG-IP 11.4.0 Build 2425.0 Hotfix HF4 F5 Platform: BIG-IP 5000
Database Proxy
I have a scenario where I want to perform database proxying (using multiple databases - Oracle; MSSQL; MySQL) etc. I want to send to different pools based on read/write queries. I have seen there was a fair amount of chatter about this years ago (2013) but I haven't seen anything recently. Is this something F5's can do? Are there any iApps or do you have to create a custom iRule? Any help would be much appreciated!
LTM Layer 4 SQL VIP
Hello everyone, I currently have multiple layer 4 virtual servers configured for our SQL Cluster. So far everything has been working great, users and apps can connect to the virtual servers to access databases as expected. We aren't using the layer 4 virtual servers for load balancing, but more as a proxy to allow users to connect to SQL servers on the other side of a firewall. We ran into one problem where our DBA is attempting to utilize SQL Analytics, but when Analytics is making a call to the virtual server it's failing. The errors we're seeing are: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: 10.x.x.x] Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10..x.x.x] We're not using our BigIP in routed mode, but instead running it in one armed mode. Due to this we have a SNAT pool for our network segments that we assign to each VIP. The client IP is one of our SNAT pool addresses. So it seems like for some reason the analytics piece of SQL doesn't recognize the SNAT IP as being a trusted domain computer? None of the other functions of SQL seem to care, but this one functionality does. Has anyone else run into this? Has anyone successfully deployed F5 virtual servers to proxy connections for SQL Analytics? I don't know much about SQL Analytics and I'm not sure what it wants or how I can give it what it wants from the F5 standpoint.Does remote access on mssql have to be enabled for monitoring to work?
I have been using a third party application for monitoring of my mssql databases availability. The issue i am having is that in order for it to work i must enable remote access in order for the application to do its work. I would like to know if this is also needed with f5 mssql monitor.MS SQL Health Monitor Using Dummy Database
I am attempting to set up a MS SQL health monitor that authenticates with a SharePoint database, issues a query, and looks for a certain return string. I have applied the health monitor to a server pool that contains the SharePoint database. The database being monitored is called Test and it contains one table called Test_Table, which has a single column called Value. I have inserted one entry in the first column and row of this table with a value of NULL. The health monitor is currently resolving to a down state. I tried to upload an image of the health monitor, but it didn't work. Here is a text description of the health monitor: Type: MSSQL (parent = mssql) Send String: SELECT CASE WHEN Value IS NULL THEN 'UP' ELSE '' END FROM Test_Table Receive String: UP Username and password belongs to the same account that SharePoint uses to interact with the database Database: Test Receive Row and Column each set to 1
Can you insert node_ip or node_name into the send strings on MSSQL monitor?
I am exploring using an MSSQL monitor where it is configured to use an alias IP and port to connect to a central DB server and in this DB server we have a table that lists the UP or DOWN status of our servers. What I then want to do is have the Send string of the monitor dynamically pick up the ip or name of the node it runs against and pass this into the SQL statement (i.e. the send string)... e.g. SELECT Server_Name, Server_IP, Server_Status FROM LB_STATUS WHERE Server_IP = %node_IP% This doesn't work, so either it is the wrong syntax or it just isn't possible. Does anyone know if this can be done?
