ERROR[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'HIENDIUSR_HIEND_EMAI

Results 1 to 2 of 2

Thread: ERROR[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'HIENDIUSR_HIEND_EMAI

  1. #1
    thoufiq Guest

    Default ERROR[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'HIENDIUSR_HIEND_EMAI

    Hello,<BR> i&#039m working on a project that involves ASP and SQL Server 7.0.I set the ODBC (with SQL Server authentication). In the code I&#039ve specified the following info.<BR> set dbconn = Server.createObject("ADODB.Connection")<BR> dbconn.open "DRIVER={SQL Server}; SERVER=HIEND_EMAIL; UID=sa; PWD=; DATABASE=images; DSN=images;"<BR> I also tried out odbcping -SHIEND_EMAIL -Usa -P from the command prompt. It seems to work fine. It says "connected to SQL Server 7.0". Ironically it says the same for any User ID and PWD.<BR> This is very very important, If someone has a solution please respond asap.Thanks is advance.<BR>THe error again is:<BR> Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e4d&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user &#039HIENDIUSR_HIEND_EMAIL&#039. <BR><BR>/Images/results.asp, line 5 <BR><BR> <BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    475

    Default RE: ERROR[Microsoft][ODBC SQL Server Driver][SQL S

    I also ran into this problem before. I reinstalled SQL Server, then all problems were solved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •