PROBLEM Receiving exception: "ASNA.DataGate.Common.dgException: Error not set" when attempting to connect to SQL Server or DataGate for Windows Servers database in a web or Monarch app

The information in this article applies to:

• Datagate for SQL Server, Release 7.x and Higher
• DataGate for Windows Servers and Desktops, Release 7.x and Higher
• Web
• Monarch

SYMPTOMS:

When attempting to connect to a  database in a web or Monarch application, error "Server Error in /[application name]: Error not set" is displayed in the browser.

Additional information appears in the Exception Details:  "ASNA.DataGate.Common.dgException: Error not set"

CAUSE:

This error occurs because the Username property of the database name configured for the application is set to *DOMAIN.

A web or Monarch application runs under the ASPNET user account, which is not a domain user and cannot login to the Datagate server with *DOMAIN credentials.  The default is *DOMAIN and must be modified to use a valid domain\username and password.
 

RESOLUTION:

The default username is *DOMAIN and must be modified to use a valid domain\username and password.  For example:

User: ASNAUS\BarryM
Password: MyPassword
 

MORE INFORMATION:

Keywords: web, Monarch, ASPNET, authenticate, dbname, dgException.