I know this is an old post but I can tell you everything I had to go through to correct this. Hopefully it can help some.

One of the biggest problems I had was when our IT Net Admins makes changes to group policies or does not give the correct permissions in the first place. Per previous tickets with Sage support, users must have full permissions to their Sage folders and BI Files. In this example it was just being able to run he SIR add-on in Excel. Not only was I not able to install it properly, but missing action options in Sage client software as well. Blocking clients from have full access to the MAS 90 driver caused problems because they could not find the driver that they had created prior to the change and now they required admin privileges to set it up. If Admin ran ODBC as Admin and setup a System DSN, the user still couldn't use it. That was actually a couple years nightmare  for me.

The majority of my findings with this particular error message, was the server odbc service would suddenly stop because it was overloaded. Tickets would flood in because they couldn't complete tasks in Sage. I found that they did not build the server to the required specs and it did not have enough resources to process all the user accounts that had tasks set to spawn from the server. All this killing resources. I was constantly having to log onto the server to start the task again. We had a script scheduled to run if the service stopped, but only up to three times so we could investigate. But the service fails for a reason and if an ODBC task is still running somewhere, it fails pretty quickly back-to-back.

I would love for someone to tell me how to create a log to target what user and what table(s) are causing a server-side odbc service failure. Because there have been times it was a locally save custom Crystal Report and an Access Db with just about every table available connected all refreshing at the same time. The only way I figured it out was because they were connected via TS.

Other items to check:

• user role has correct permissions on top of their user account having ODBC enabled. One missing check in the roles assigned can cause this
• Decide if task is spawned locally or server-side. Check requirements for either are correct and meet the needs of any query. The bigger the query the more demand.
• If you have 64-bit version of Sage Server, they recommend installing 32-bit first when upgrading from a 32-bit, then installing the 64 bit. I can only assume the same would apply to client-side. At some point in time I was began to have issue, I had only 32 installed then added 64 and it fixed it. I find Sage install processes are finicky in the order it's complete too. Older --> Newer

Today, 2024, the issue has returned. Back to investigating and seeing what was changed without notice......again. Good luck and if anyone finds the full outcome, PLEASE share

I know this is an old post but I can tell you everything I had to go through to correct this. Hopefully it can help some.

One of the biggest problems I had was when our IT Net Admins makes changes to group policies or does not give the correct permissions in the first place. Per previous tickets with Sage support, users must have full permissions to their Sage folders and BI Files. In this example it was just being able to run he SIR add-on in Excel. Not only was I not able to install it properly, but missing action options in Sage client software as well. Blocking clients from have full access to the MAS 90 driver caused problems because they could not find the driver that they had created prior to the change and now they required admin privileges to set it up. If Admin ran ODBC as Admin and setup a System DSN, the user still couldn't use it. That was actually a couple years nightmare  for me.

The majority of my findings with this particular error message, was the server odbc service would suddenly stop because it was overloaded. Tickets would flood in because they couldn't complete tasks in Sage. I found that they did not build the server to the required specs and it did not have enough resources to process all the user accounts that had tasks set to spawn from the server. All this killing resources. I was constantly having to log onto the server to start the task again. We had a script scheduled to run if the service stopped, but only up to three times so we could investigate. But the service fails for a reason and if an ODBC task is still running somewhere, it fails pretty quickly back-to-back.

I would love for someone to tell me how to create a log to target what user and what table(s) are causing a server-side odbc service failure. Because there have been times it was a locally save custom Crystal Report and an Access Db with just about every table available connected all refreshing at the same time. The only way I figured it out was because they were connected via TS.

Other items to check:

• user role has correct permissions on top of their user account having ODBC enabled. One missing check in the roles assigned can cause this
• Decide if task is spawned locally or server-side. Check requirements for either are correct and meet the needs of any query. The bigger the query the more demand.
• If you have 64-bit version of Sage Server, they recommend installing 32-bit first when upgrading from a 32-bit, then installing the 64 bit. I can only assume the same would apply to client-side. At some point in time I was began to have issue, I had only 32 installed then added 64 and it fixed it. I find Sage install processes are finicky in the order it's complete too. Older --> Newer

Today, 2024, the issue has returned. Back to investigating and seeing what was changed without notice......again. Good luck and if anyone finds the full outcome, PLEASE share