Re: error when connecting to sql db

On Jan 13, 4:42 pm, jho <jhogan0...@xxxxxxxxx> wrote:
iis and sql on same box. asp lan app.

I can open the initial page but get this error when i try to look up
a
customer or other db dependant actions.

Microsoft OLE DB Provider for SQL Server (0x80040e4d)
Login failed for user 'sa'
/ctservice/view_edit_service/getindex.asp, line 22

the code on line 21-22:
Set connEditService = Server.CreateObject("ADODB.Connection")
connEditService.Open conString

This started when i tried to change the sa password so that i could
access the db for a mail merge. I don't have the original sa password
and i don't know if i enabled it by accident. If so how do i remove
it
or fix this error? thanks jho.

I found the password for sa after searching all of the pages in the
site for, you guessed it, password duh.....
.

Relevant Pages

  • Re: error when connecting to sql db
    ... customer or other db dependant actions. ... Microsoft OLE DB Provider for SQL Server ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Injection ASP + SQL Server (problem) ?!
    ... First Thkz for help and attention. ... Microsoft OLE DB Provider for ODBC Drivers ...
    (Pen-Test)
  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
    ... >Oracle 10g Client is installed on the Windows Server. ... >This is my standard DSN Less connection. ... >Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.iis)
  • RE: My Frustrations
    ... to communicate the value of what we do in business terms. ... That problem confuses the customer and often times ends up ... landing the customer in a very poor security state, ... presenting the same face and message as the quality provider. ...
    (Pen-Test)
  • Re: My Frustrations
    ... While I appreciate your response I only partially agree with you; and frankly I wasn't asking you for a lesson in business. ... That problem confuses the customer and often times ends up landing the customer in a very poor security state, then they wonder why they get hacked. ... At that point it is not a matter of the good provider conveying the message better its a matter of the customers learning how to tell fact from fiction, but they can't do that without being educated first. ...
    (Pen-Test)