SQL Server

[tseh]

I have a connection using the following code:
An administrator can run this asp from our intranet but a user gets the generic 8000405 error message. I have tried giving the user full access to the folder but no success.

The only way it seems that a user can run the asp is to be added to the domain admins group.

How can I get around this?

<% Dim dbCxn
Dim rsEmp
Dim strSQL

Set dbCxn = Server.CreateObject(&quot;ADODB.Connection&quot
dbCxn.Open &quot;DSN=myDB;UID=user;PWD=password&quot;

strSQL = &quot;SELECT emp_id, emp_name &quot;
strSQL = strSQL & &quot;FROM tblEmployees &quot;
strSQL = strSQL & &quot;ORDER BY emp_name &quot;

Set rsEmp = dbCxn.Execute(strSQL)
%>

 

[Spacie]

Try creating a new usergroup (eg. &quot;Intranet Users&quot, and add the &quot;IUSR_MachineName&quot; user to that Usergroup. Then, allow the new usergroup access by Adding them to the security panel for that directory. Then give them &quot;Read & Execute&quot; and &quot;Read&quot; Permissions. They should then be allowed to Access the ASP!

Hope this helps