SQL Server authentication

[jhunt]

If you are using windows authentication then the user the WWWserver is authenticating as on the SQL server must be also be a user in the SQL server machine. OK thats confusing.

If logged in user on machine 1(WWW server) is Eric, then there must also be an Eric on MAchine2(SQL Server).

If this is still OK, post the connection string that you are using so we can see if there is a problem there. (You are using ADO?)

[artsapimp]

This is failing with this error:

SQL Server does not exist or access denied.

<%
Set cnn = Server.CreateObject("ADODB.Connection")

ConnectString = "Driver={SQL Server}; " & _
                "Server=MySQLServer; " & _
                "Database=Master; " & _
                "Uid=SQLUser; " & _
                "Pwd=SQLUser;"

cnn.Open ConnectString
%>
test 

[jhunt]

Ok I think if you want to connect to an SQL server using wiondows auth you may ned this is in your connection string

;Integrated Security=SSPI;

In addition you can't use Windows Auth from Win95/98/ or ME. What OS is your client on?