Why is My SQL Query Lagging on Entra ID Devices?

0
1
Asked By TechWizard42 On

I've got this add-in for Outlook that performs a SQL query to return numbers as you type, using SQL authentication to connect to the database. On domain-joined devices, this feature works perfectly with no noticeable lag. However, after transitioning to Entra ID devices, I'm experiencing significant lag during lookups, and sometimes it even overlooks key inputs. Since all devices are on the same local network, I've ruled out DNS issues because we're using the SQL server's IP directly and named pipes are disabled. I've seen some discussions suggesting that non-domain devices might rely on NTLM if Kerberos fails, which could introduce delays, but since we're using SQL authentication, I don't think that should be a factor. Does anyone have any insights on why there's lag on Entra ID devices compared to domain-joined ones?

3 Answers

Answered By NetworkNinja On

Relying on a direct IP might not be the best choice. If possible, switch to using a DNS name instead—it could help streamline your connections and avoid delays.

Answered By DataNerd99 On

First off, check if you're truly using SQL authentication. If you’re using Windows Authentication, it might revert to NTLM, which could cause the delay. That said, if it’s set up correctly with SQL auth, ensure that the add-in is not falling back on domain credentials. Also, switching to using a DNS name for the SQL server can help with Kerberos authentication if you decide to go that route. Make sure your Entra ID setup supports Kerberos SSO too!

InfoSeeker007 -

It's definitely SQL auth since we input credentials directly in the add-in. I'd prefer not to use SQL auth, but the app isn’t being updated anymore.

Answered By SQLGuru88 On

NTLM lag typically comes into play when logins fail, but if your connection string is wrong or the app logic triggers connections while typing, that could slow things down. Just a thought—if Integrated Security is on, it may be trying to use the domain account first, which might add delays on Entra ID devices. It might be worth checking how the connection is being established during user input.

UserExperiencePro -

Good point, I read that the connection process can time out trying to use domain credentials before switching to SQL auth, which is not ideal.

SupportedFunctionality -

Interesting catch! Authentication overhead could definitely contribute to the sluggishness.

Related Questions

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.