came in this morning and found my asp webpage is erroring out when trying to connect to a sql server database it has been connecting to for 2 years. although the error i get is "access denied" - it takes a long time for the error to appear - as though it is timing out rather than an actual "access denied". i can take the asp page and place it on other servers and it connects just fine. it just won't connect from one particular server. the page was running fine friday afternoon. no work was done over the weekend. i just don't get it. could there be a service which is supposed to be running and isn't?

here's my connection process:

Const cConnection = "PROVIDER=SQLOLEDB;DATA SOURCE=CLUSTERSQL;UID=webuser;PWD=;DATABASE=PartsF inder"
Dim objConnection

Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.ConnectionString = cConnection
objConnection.CursorLocation = 3 '* adUseClient
objConnection.Open

what in the world could be wrong?

Maybe someone put a password on your database. As it stands right now, that connection string you listed suggests that your database isn't especially secure.

the exact same asp page works fine from other machines.
i am really baffled. my only guess is that some needed service isn't running but i don't know what the minimum services are which i'd need to make this connection. do you?

From other machines? Do you mean you placing your ASP web pages on another machine to access the database on the original server? Or you mean placing both your web pages and database to another new machine?

If it can run from other servers to the same SQL server the problem will likely be the IUSR_machinename account on the first server.

Maybe the password has been corrupted (it does happen from time to time)

i grab the asp page off of my web server and place it on pretty much any other machine and it runs fine and connects to the database. it just won't work from my web server.


i think you might be on to something as far as the iusr_machine account goes...
it kinda makes sense but i'm not sure where to start.