error when connecting to sql db

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.

.

Relevant Pages

  • Active Directory & web application?
    ... We have developed a web application (Asp 3.0, MS SQL, ... IIS). ... The customer wants to connect the web application ... to there existing Active Directory - so the application ...
    (microsoft.public.inetserver.asp.general)
  • error when connecting to sql db
    ... iis and sql on same box. ... asp lan app. ... customer or other db dependant actions. ... Microsoft OLE DB Provider for SQL Server ...
    (comp.databases.ms-sqlserver)
  • Re: OOP - a question about database access
    ... >>and project so much better in SQL DBMSes than in ODBMSes, ... >>100x more bytes from the database, just because you want your objects to ... > a related invoice.. ... > assoication from the customer to the invoice collection and have done ...
    (comp.object)
  • Re: object databases
    ... Now, tell me, you can do all that with 2 lines of code with SQL ... didn't provide the Customer, Order and OrderDetail classes. ... If you try to map classes to tables, ...
    (comp.object)
  • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
    ... uses NT group based permissons on the SQL Server, ... > transfered to the IIS box and IIS does a local logon. ... > delegation for all accounts. ...
    (microsoft.public.inetserver.iis.security)