ASP app upgrade to IIS6 with new Authentication scheme

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

.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Windows security
    ... sp_change_users_password only works with SQL Server ... Authentication, not Windows Authentication. ... > Windows NT environment but still have entries in the Microsoft SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Very basic login question
    ... Both computers are NOT members of a domain. ... In order to use Windows Authentication the two computers have to be ... you should have a login at the SQL Server on the XP Pro ...
    (microsoft.public.sqlserver.security)
  • Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
    ... connecting using a Windows account or using a SQL Server account? ... For Windows authentication, SQL Server need to enumerate the SIDs for the account you pass with Windows. ...
    (microsoft.public.sqlserver.clients)
Loading