Web Development

I'm almost sure this is a secutity-problem.
check your security-settings of the sql-server

hi,

The 80004005 error message indicates that your data cannot be accessed. When your ASP attempts to access database located on remote machine, the problem stem from the fact that ASP is operating in the context of the IUSR_MACHINE account. On servers that are not primary or backup domain controllers, the IUSR_MACHINE account is a local account. Since this local account is not recognized on the remote machine, access is denied to the database.

The 2 possible workarounds for this problem are:

1. Change the Anonymous Logon account on the IIS server from IUSR_MACHINE to a domain account that is recognized by both machines and has sufficient permissions to the resource. In addition, be sure that this account has the log on locally user right on the IIS machine. Recall that the Anonymous Logon account is configured through Internet Service Manager.

2. Add a local account to the remote machine that exactly matches the username and password of the IUSR_MACHINE account on the IIS machine, and give this account access to the database.

Also note that:
If IIS and SQL servers are in different domains, either a trust must be setup between the two domains or the IUSR_WEB account has to be added to the SQL domain.

A special license one-user license (per SQL Server) is necessary to allow unlimited Internet access.

If challenge authentication is enabled in IIS, it prevents logging onto remote SQL server. You will need to use basic authentication, or install SQL server on same server as IIS.

Try it this way:

Create your connection information:

'********************************************
Private Me.myConnection.ConnectionString = "data source=SQL;password="PASSWORD";initial catalog="CATALOGNAME";persist security info=False;user id="ID";packet size=4096"

'********************************************


SET THE CONNECTION:


'********************************************

Public Sub SetConnection(ByVal ConnStr As String)
Me.myConnection.ConnectionString = ConnStr
End Sub

'********************************************


OPEN AND RUN YOUR QUERY:

'********************************************

Public Function RunQuery(ByVal InQuery As String) As Integer
ClearError()
Dim tempInteger As Integer = 0
myCommand.CommandText = InQuery
Try
If myCommand.Connection.State = ConnectionState.Closed Then
myCommand.Connection.Open()
myCommand.CommandTimeout =10000
End If

tempInteger = myCommand.ExecuteNonQuery()
If myCommand.Connection.State = ConnectionState.Open Then
myCommand.Connection.Close()
End If
Catch E As Exception
If myCommand.Connection.State = ConnectionState.Open Then
myCommand.Connection.Close()
End If
HandleError("DBCOM.RunQuery", InQuery, E.Message)
Finally
'();
End Try
Return tempInteger
End Function

If you are using Integrated Security do not provide the UserName/Password.

You might want to take look aty this aticle on Microsoft Web site Article ID : 306518
It might help you out...

Check your LAN Settings .
Check for the proxy settings
it will not work on proxy