AO Classic Freezing in Windows 11
Hello, all.
I have an accountant client who is experiencing freezes when they are using AO Classic on Windows 11. They're getting the following error in the Event Viewer:
Failed to get IntegrationType when send login telemetry data, error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Error in ExceptionWindow
Exception Source: .Net SqlClient Data Provider
Exception Type: System.Data.SqlClient.SqlException
Exception Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Exception Target Site: EmployeeCacheWrite
---- Stack Trace ----
at Solution6.VPM.BusinessLogic.Core.EmployeeCacheWrite(String ConnectionKey, Int32 EmployeeID, String CacheType, String XMLData)
at Solution6.VPM.Client.UIHelperClasses.EmployeeSettings.WriteEmployeeSettings()
at Solution6.VPM.Client.ClientFrameWork.FrameWork.Main(String[] params)
Any ideas?
Hi, ITWorx_NZ,
Yes, AO Classic does not have any SQL integration, so this sounds like an SQL connectivity issue related to Accountant's Office.If you are your client's IT provider, please work through these support articles:
- Error: “A network-related or instance-specific error occurred while establishing a connection to SQL Server”
https://practice-support.myob.com/supps/error-a-network-related-or-instance-specific-err-1 - Configuring your Firewall or Proxy for MYOB AE/AO
https://practice-support.myob.com/supps/configuring-your-firewall-or-proxy-for-myob-ae-ao - Checking the Data Source Connection via ODBC (to test the connection from the affected workstation)
https://practice-support.myob.com/supps/checking-the-data-source-connection-via-odbc
If you're still having issues after checking the above, please raise a support case with our practice team, and we will be happy to investigate further.
Thanks,
Scott
Client Accounting- Error: “A network-related or instance-specific error occurred while establishing a connection to SQL Server”