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/ [quoted text, click to view] <pwarda@gmail.com> wrote in message
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
>
