This error usually indicates that SQLServer (or MSDE) is configured to use Windows Authentication. If you want to use a SQL login, you will need to enable SQL Authentication (mixed mode authentication).
For more details refer PRB: ASP/ODBC/SQL Server Error 0x80040E4D ‘Login Failed for User ’(Null)’’
Share with