General information
Category:
Internet applications
>>>Ooops! Right. Well, lets go at it a different way then. There's really only one reason a dialog would pop up and that's due to an authentication challenge. When you set up your DSN, did you tell it to use SQL Server's authentication instead of NT's?
>>>
>>Yes,
>>I use the SQL Server's authentication.
>>Why would this be a problem?
>
>IIS users a special user ID, IUSR_YourServerName, to gain access to web sites. If you had not specified SQL Server authentication in the ODBC setup, IIS would have passed the special ID to SQL Server for access. Unless you specifically added it, SQL Server would issue an authentication challenge. Remember that your DLL is running in the IIS process.
>
>Having said this, something else just occured to me. Do you have any ASPs that access the SQL Server data via ADO? If not, how is your SQL Server security set up? ASP can only deal with SQL Server if the security is set up as Standard. If its Mixed or Integrated, it won't work. I assume this is due to what I discussed above about IIS's special anonymous user ID.
SQL Server use Standard security.
Also, other ASP pages create a ADO connection to SQL with no problem.
What is the pooling connection in the error message?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only