ASP app upgrade to IIS6 with new Authentication scheme

14 Mar 2006 11:37 PM

pwarda

Hello all,

we have an existing ASP 3 based application that use to run perfectly
with SQL Server 7.

We have been mandated to migrate the site over to the following
configuration:

WebServer (server 1)
Windows 2003 (with IIS 6 of course)

Database (server 2)
SQL Server 2000
Windows 2003

If that wasn't enough, we've also been TOLD to switch from Mixte mode
authentication to Windows Authentication. While we've found numerous
articles about this for ASP.Net based-apps, we can't quite seem to find
information regarding straight ASP in this situation.

Does anyone know where I can find a how-to guide or can someone provide
information about this type of a migration (The Windows Authentication
modification on Windows 2003 to SQL 2000 is the piece I'm having a
particularly hard time with)

Thanks very much for any input you guys can provide us,
Philippe

15 Mar 2006 7:02 AM

Bernard Cheah [MVP]

What's the complete error msgs? if it's in windows auth mode, does the db
user has right to access the sql server?
Also try reading this kb
How to troubleshoot connectivity issues in SQL Server 2000
http://support.microsoft.com/?id=827422

--
Regards,
Bernard Cheah
http://www.iis-resources.com/
http://www.iiswebcastseries.com/
http://msmvps.com/blogs/bernard/

<pwa***@gmail.com> wrote in message

Show quoteHide quote

news:1142379430.928650.305030@v46g2000cwv.googlegroups.com...
> Hello all,
>
> we have an existing ASP 3 based application that use to run perfectly
> with SQL Server 7.
>
> We have been mandated to migrate the site over to the following
> configuration:
>
> WebServer (server 1)
> Windows 2003 (with IIS 6 of course)
>
> Database (server 2)
> SQL Server 2000
> Windows 2003
>
> If that wasn't enough, we've also been TOLD to switch from Mixte mode
> authentication to Windows Authentication. While we've found numerous
> articles about this for ASP.Net based-apps, we can't quite seem to find
> information regarding straight ASP in this situation.
>
> Does anyone know where I can find a how-to guide or can someone provide
> information about this type of a migration (The Windows Authentication
> modification on Windows 2003 to SQL 2000 is the piece I'm having a
> particularly hard time with)
>
> Thanks very much for any input you guys can provide us,
> Philippe
>