Re: error when connecting to sql db
- From: jho <jhogan0101@xxxxxxxxx>
- Date: Sun, 13 Jan 2008 14:44:39 -0800 (PST)
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.....
.
- Follow-Ups:
- Re: error when connecting to sql db
- From: Bob Barrows [MVP]
- Re: error when connecting to sql db
- References:
- error when connecting to sql db
- From: jho
- error when connecting to sql db
- Prev by Date: error when connecting to sql db
- Next by Date: Re: error when connecting to sql db
- Previous by thread: error when connecting to sql db
- Next by thread: Re: error when connecting to sql db
- Index(es):
Relevant Pages
|