SQL Server login ODBC error 80040e4d

Customer Support Database Support
1

Customer support,

I am getting following error in my ASP page.

Microsoft OLE DB Provider for ODBC Drivers error ‘80040e4d’

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘WINPA1\dbuser’.

Please help.

Satish

2

What does your connecting sting look like?

3

make sure you have put your sql database’s usernamd and password in the connection string

4

Hi, i’m getting the same error message as you did. how did you solve it.

Microsoft OLE DB Provider for ODBC Drivers error ‘80040e4d’

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘WINPA1\dbuser’.

Please help.

rdwalker

5

This may sound stupid, but iam a beginner. What is ‘string connection’?

6

Hi All,

I would be glad if anyone help me out. My code connects to SQLServer with no issues when I use local user account but same code fails when it connect using Active directory user account. I got below error

OLE DB Error Record dump for hr = 0x80040e4d
Row #: 0
Source: “Microsoft OLE DB Provider for SQL Server”
Description: “Login failed for user ‘PCI\sp-cuppsys’.”
Help File: “(null)”
Help Context: 0
GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}
OLE DB Error Record dump end
(hr=80040e4d)

Connection String which I am using is

Thanks in advance