Updated March 2023: Stop getting error messages and slow down your system with our optimization tool. Get it now at this link
- Download and install the repair tool here.
- Let it scan your computer.
- 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.
March 2023 Update:
You can now prevent PC problems by using this tool, such as protecting you against file loss and malware. Additionally it is a great way to optimize your computer for maximum performance. The program fixes common errors that might occur on Windows systems with ease - no need for hours of troubleshooting when you have the perfect solution at your fingertips:
- Step 1 : Download PC Repair & Optimizer Tool (Windows 10, 8, 7, XP, Vista – Microsoft Gold Certified).
- Step 2 : Click “Start Scan” to find Windows registry issues that could be causing PC problems.
- Step 3 : Click “Repair All” to fix all issues.
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:
- 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.
- Select the DSN “WhatsUp”, then click on the “Configure” button and the configuration wizard appears.
- 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. \>.
- 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.
- 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.
- 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.
- Continue clicking “Next” until you reach the last dialog box, then click Finish.
- The Microsoft SQL Server Setup ODBC dialog box opens. You can click on Test Data Source or OK to test the configuration.
- Repeat steps b to f for the DSN “NetFlow” and “iDroneService”.
Check if the UISR account has anonymous access.
- Log in to the Application Server knowledge base as a user with administrator rights.
- Right-click on the My Computer icon and choose Manage from the menu option.
- In the Computer Management window, expand Services and Applications > Internet Information Services Manager (IIS) > Websites.
- Right-click on ClientPortal and select Properties from the menu option.
- In the Directory Security tab, in the Authentication and Access Control section, select Edit.
- Make sure that the Enable anonymous access option is enabled for the UISR user name.
- Click OK to save all changes.
- Click OK to close the ClientPortal Properties.
- 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.
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
CCNA, Web Developer, PC Troubleshooter
I am a computer enthusiast and a practicing IT Professional. I have years of experience behind me in computer programming, hardware troubleshooting and repair. I specialise in Web Development and Database Design. I also have a CCNA certification for Network Design and Troubleshooting.