How To Fix: Microsoft OLE DB Provider for SQL Server Error 80040e4d

Updated December 2024: Stop getting error messages and slow down your system with our optimization tool. Get it now at this link

1. Download and install the repair tool here.
2. Let it scan your computer.
3. The tool will then repair your computer.

When you try to use an ODBC data source name (DSN) to open a connection of ActiveX data objects (ADO) to a SQL Server database from an Active Server Pages (ASP) page, you can receive the following error message:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.

What are the causes of this error?

1. You have connected to an incorrect MSSQL server.

2 The database user name and password may be invalid.

Verification of ODBC data sources

It is necessary to check the ODBC data sources used by WhatsUp Gold to access the database, then transfer the changes to the WhatsUp Gold database configuration utility. To do this, you must perform the following steps:

ODBC connection

1. Select from the Windows Start menu: For a 32-bit Windows operating system: Control Panel > Administrative Tools > Data Sources, then the System DSN tab – or – for a 64-bit Windows operating system: Select “Run” and type (without quotation marks) “c:\Windows\SysWOW64\odbcad32.exe”; then select the System DSN tab in the ODBC Data Source Administrator dialog box.
2. Select the DSN “WhatsUp”, then click on the “Configure” button and the configuration wizard appears.
3. Make sure that the name assigned is “WhatsUp” (or “NetFlow” if you are checking NetFlow DSN) and that the Server field is correctly assigned, i. e. \>.
4. In the second dialog box, make sure that the option “With SQL Server authentication with login ID and password entered by the user” is selected. Enter the SQL user name in the Login field.
5. In the Password field, enter the SQL user’s password (default for WUG would be’sa’ user and the password for’WhatsUp_Gold’), then click Next.
6. In the third dialog box, make sure that the Modify default database option is selected and that the WhatsUp database (or NetFlow if configured for NetFlow) appears in the drop-down menu, then click Next.
7. Continue clicking “Next” until you reach the last dialog box, then click Finish.
8. The Microsoft SQL Server Setup ODBC dialog box opens. You can click on Test Data Source or OK to test the configuration.
9. Repeat steps b to f for the DSN “NetFlow” and “iDroneService”.

Check if the UISR account has anonymous access.

1. Log in to the Application Server knowledge base as a user with administrator rights.
2. Right-click on the My Computer icon and choose Manage from the menu option.
3. In the Computer Management window, expand Services and Applications > Internet Information Services Manager (IIS) > Websites.
4. Right-click on ClientPortal and select Properties from the menu option.
5. In the Directory Security tab, in the Authentication and Access Control section, select Edit.
6. Make sure that the Enable anonymous access option is enabled for the UISR user name.
7. Click OK to save all changes.
8. Click OK to close the ClientPortal Properties.
9. Repeat steps 4 to 8 for the customer portal.

Once all problems related to these three causes have been resolved, users should no longer see the error message when they connect to the knowledge base of the administrator control panel.

https://community.oracle.com/thread/89045


Expert Tip: This repair tool scans the repositories and replaces corrupt or missing files if none of these methods have worked. It works well in most cases where the problem is due to system corruption. This tool will also optimize your system to maximize performance. It can be downloaded by Clicking Here