Connect to SQL Server 2K through ODBC

Does anyone know a way to still authenticate to a SQL
Server 2000 server using SQL Authentication when Anonymous
Access is turned off?176380 How To Use ASP with a SQL Trusted Connection with Guest Account
http://support.microsoft.com/?id=176380
169377 How to access SQL Server in Active Server Pages
http://support.microsoft.com/?id=169377
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks for your post, but this still requires Anonymous
Access to be turned on... It just changes the account
from IUSR_MACHINENAME to an account that you create. I
need it turned off because I am trying to get the logged
in user via Request.ServerVariables("LOGIN_USER") and it
won't work with Anonymous Access turned on.
Are there any other ways?
Thanks again for any help.
Yong
>--Original Message--
>
>176380 How To Use ASP with a SQL Trusted Connection with
Guest Account
>http://support.microsoft.com/?id=176380
>169377 How to access SQL Server in Active Server Pages
>http://support.microsoft.com/?id=169377
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||What security are you using in IIS and SQL?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Integrated Windows Authentication.
>--Original Message--
>What security are you using in IIS and SQL?
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>