Skip to content

The news behind the software that runs companies, explained for everyone.

Software business

Microsoft published two temporary workarounds for its database connection problem. Closing connections or restarting can interrupt active queries or transactions.

Microsoft has published two temporary workarounds for a database connection problem following its 13 October update.

ERP LEADERS news desk · · First reported by The Register · Edition no. 69
Photo: Coolcaesar/Wikimedia, CC BY-SA 4.0 · original

Connections opened by SQL Server linked-server queries "might remain open", The Register reported on 12 November. A linked server lets one SQL Server query another database, such as Oracle or PostgreSQL.

"As additional queries are performed, connections to external databases can accumulate instead of closing as expected," Microsoft said.

Teams can find idle connections and close them by hand, or restart the SQL service. Microsoft warns that either workaround can interrupt active queries or transactions. The problem can return after enough running time.

A mitigation is available only through Microsoft's business support. The Register said on 12 November that a separate fix should follow within days. The glitch affects Windows Server versions from 2012 to 2025.

For teams whose reports or ERP interfaces pull data through linked servers every night, open connections can pile up as the queries run.

Sources

Spotted an error? Tell us. Every correction is logged on Standards.

Your reading room

Companies in this story

Our file on Microsoft

  1. 19 NovFiled later

    Microsoft's finance saves over 250,000 hours yearly with AI, it reports. It runs on SAP, though Microsoft sells ERP.

  2. 19 NovFiled later

    Microsoft's CEO said a lot of its Dynamics business is now usage, not seats. CFOs still budget software per seat.

  3. 19 NovFiled later

    Microsoft's cloud replaces a Basque hospital's Navision ERP in a €194,240 contract, a notice shows. Navision's last release loses support in 2028.

  4. 18 NovFiled later

    Microsoft is how 98% to 99% of UK civil servants communicate, a minister said. No date was given for moving away.

  5. 17 NovFiled later

    Microsoft data gives Claude under a tenth of Copilot's weekly Office users, The Information reported. Microsoft stock dipped after Claude's new tools.

All 92 Microsoft stories

Every story here is open to read. The ERP LEADERS brief goes one step further.

Today's enterprise software news in one short email, each story with its source. Get the brief, free to join.

Founding reader

Welcome back. · Issue 01

3 comments under this story on LinkedIn. Read the discussion

Keep reading

The ERP LEADERS brief Get the brief