SQL Server login ODBC error 80040e4d

Discussion in 'Database Support' started by shetty, Oct 9, 2003.

  1. shetty

    shetty Guppy

    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. Yash

    Yash Bass

    What does your connecting sting look like?
  3. FreeWilly

    FreeWilly Perch

    make sure you have put your sql database's usernamd and password in the connection string
  4. rdwalker

    rdwalker Guppy

    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. rdwalker

    rdwalker Guppy

    This may sound stupid, but iam a beginner. What is 'string connection'?
  6. Ashu

    Ashu Guppy

    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

    <database connectString="Provider=SQLOLEDB;Data Source=APIOS02;Catalog=iMuse_Master;User ID=PCI\sp-cuppsys;Password=password"/>

    Thanks in advance

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services