Unable to connect to sql database only from asp

Question

In a VB6 program:

Dim conn As Object
Set conn = CreateObject("ADODB.Connection") 
conn.Open "DRIVER={SQL Server}; Server=(local)\aaa; Database=bbb; UID=ccc; PWD=ddd"

In an ASP program:

Sub ProcessSqlServer(conn)
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "DRIVER={SQL Server}; Server=(local)\aaa; Database=bbb; UID=ccc; PWD=ddd"

The VB6 program works, the ASP program does not (see error below). I tried checking the event log for errors, but found nothing. Or more precisely, I did find local an activation permission error, but this was fixed once I added local launch/activation permission for Network Service to the Machine Debug Manager via the component services tool.

Error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC SQL Server Driver]Timeout expired

Answer 1

Take a look at these. They may be of some help

http://support.microsoft.com/kb/165671

http://www.connectionstrings.com/sql-server

Answer 2

The problem was that NETWORK SERVICE needed lots of permissions on C:\Users\USERNAME\AppData\Local\Temp .