Error fixE2 Shop System (Shoptech)Database / Client connection

E2 Shop System Error 5093: Causes and How to Troubleshoot

Error
e2 shop system error 5093

Also searched as

  • shoptech e2 error 5093
  • e2 shoptech error 5093
  • e2 shop system database error

Short answer

We could not find an authoritative public definition of E2 error 5093, so treat any single-cause answer with caution. In practice, numbered E2 errors raised at login or while opening a module come from the client talking to the database: a changed server name, a SQL permission or login problem, a missing or mismatched driver, or a network or firewall change. Isolate which with the checks below and give Shoptech support the exact context.

Applies to: E2 Shop System by Shoptech, client-server installations on SQL Server. Exact message wording differs by version, confirm with Shoptech support.

Isolate the cause of error 5093

  1. 1Write down exactly where the error appears: at login, opening a particular module, printing a report, or saving a record. Take a screenshot of the full message.
  2. 2Test whether it affects one workstation or all. If only one, suspect the client install, driver or local permissions.
  3. 3Test from the server console. If it works there but not from clients, suspect network, DNS name, firewall or the share permissions on the E2 folder.
  4. 4Confirm the SQL Server service is running and that the database is online and not in single-user or recovery state.
  5. 5Check what changed recently: Windows updates, server rename, IP change, antivirus, SQL or E2 updates, new user accounts.
  6. 6Verify the SQL login E2 uses still exists, is enabled, and has rights on the E2 database. Do not change roles blindly, record the current state first.
  7. 7Take a verified backup before any repair, then contact Shoptech support with the message, the version and the findings from steps 1 to 5.

How to read a numbered error

A bare number tells you almost nothing without the code path that raised it. The most useful information is the context: which action, which user, which machine, and what changed. The same number can surface from different layers, such as the application, the database driver or the operating system.

Search results for numbered E2 errors often repeat advice for unrelated codes. Be skeptical of any forum answer that does not ask where the error appears.

The usual suspects

Connection and permission changes cause a large share of post-update errors. A server renamed or moved to a new IP leaves clients pointing at a name that no longer resolves. A Windows update can change TLS or driver defaults. A new antivirus policy can block the E2 client from its data folder.

Check the Windows Event Viewer on both the client and the server at the exact time of the error, as well as the SQL Server error log. These often name the underlying cause even when E2 shows only a number.

Before you call support

Gather the E2 version and build, SQL Server version, operating system versions, screenshot, time of error and a list of recent changes. Support can then work out whether it is a known issue in your build or an environmental problem, which is much faster than a general description.

Try it here, free

E2 Shop System Private AI Layer Blueprint Generator

Open full tool

Fill in your version, database, hosting and use cases to get an architecture plan for a private, on-prem AI assistant on E2 Shop System, ready to share with IT and security.

Common pitfalls

  • !Reinstalling the client on every PC before checking whether the server side is healthy.
  • !Granting broad SQL permissions as a quick test and leaving them in place.
  • !Trying fixes without a fresh verified backup.
  • !Following forum advice written for a different error number.

How an ERP-grounded AI assistant handles this

For shops with a tangle of tribal fixes, a private assistant over your own support notes, event logs and past tickets can find how a similar error was resolved last time without sending any data outside. Netray's DataRay does exactly that kind of on-prem chat over documents and logs.

Frequently asked questions

What does E2 error 5093 mean?

We could not confirm a published meaning, so we do not assert one. Numbered E2 errors at login or module open typically trace to the database connection, permissions or drivers. Confirm with Shoptech support using the exact message and version.

Does the error mean my data is corrupt?

Not necessarily. Most connection-type errors do not damage data. Still, take a verified backup before any change, and check the SQL Server log for signs of database problems.

Who supports E2 Shop System?

Shoptech provides support through its support plans, and many shops also use independent E2 consultants. Have your customer or serial information ready.

Can I fix this myself?

Often you can isolate it, for example a changed server name or permission. Anything that touches the database should follow a backup and ideally a call with support.

Related

How-to

E2 Shop System 7.2 (Shoptech): Versions, Manuals, Training, Support and Reporting

E2 Shop System is Shoptech's ERP and MRP software for job shops and make-to-order manufacturers, covering quoting, orders, scheduling, purchasing, inventory, shop floor tracking and accounting integration. Version 7.2 is one release in its line. For manuals, training, support and upgrade eligibility, Shoptech and its resellers are the authoritative source, so confirm details for your own license.

How-to

How to Create a Quote in E2 Shop System

A quote in E2 Shop System starts with a header identifying the customer and part, then adds routing operations with time and rate, material and outside processing costs, and a markup to reach a sell price. Once accepted, the quote converts directly into a job or sales order so the estimate carries forward as the job's cost basis.

How-to

Fixing a Slow Epicor BAQ (Business Activity Query)

A slow BAQ in Epicor is usually caused by unindexed join columns, a subquery or calculated field forcing a table scan, or the BAQ pulling far more rows than the dashboard actually displays before filtering client-side. Fix it by reading the SQL Server execution plan Epicor generates, moving filters into the BAQ criteria instead of the dashboard filter panel, and replacing subqueries with joins where possible.

How-to

JobBOSS Public API: What Integration Options Exist for JobBOSS and JobBOSS2

Classic JobBOSS stores data in Microsoft SQL Server, so most custom integrations read it by SQL and write through supported import tools or the vendor's SDK rather than by raw inserts. JobBOSS2 is a newer product and its API and database access depend on how it is hosted and licensed, so confirm with the vendor what is available for your edition before designing around it.

How-to

JobBOSS Custom Reports: Building and Editing Crystal Reports

JobBOSS reports are Crystal Reports (.rpt) files that read the JobBOSS SQL Server database. To customise one, copy the standard report, open the copy in Crystal Reports, point it at your database, change the fields or layout, and place it where JobBOSS looks for custom reports. JobBOSS2 reporting differs, so check the supported report tooling for your edition.

How-to

JobBOSS and QuickBooks Online Integration: What Works and What to Check

JobBOSS and JobBOSS2 are job-shop ERP systems that run quoting, job costing, scheduling and shipping; QuickBooks is an accounting package. The usual pattern is that JobBOSS owns jobs, inventory and invoices, and a summarised accounting interface pushes invoices, receipts and bills into the general ledger. Which QuickBooks flavours (Desktop or Online) and which transactions are supported depends on your edition and release, so confirm with ECI before you buy or plan around it.

AI for ERP

AI for ECI JobBOSS2 and E2 Shop System

Add AI to ECI JobBOSS2 or E2 Shop System for faster quoting, tighter scheduling, and shop-floor answers, without sending your job data to the cloud.

Stuck on E2 Shop System (Shoptech)?

Talk to engineers who work inside E2 Shop System (Shoptech) every week, and who build private AI that answers these questions from your own ERP data.

Keep exploring

Free tools

ERP fixes and how-tos

Guides

AI on your ERP

Integrations

Software