"RedStain" <RedSt***@redstain.com> wrote in message
news:eAtcsqBoGHA.4800@TK2MSFTNGP04.phx.gbl...
> CONTENTS
>    summary
>    setup
>    error messages
>    compensation attempts
>    comment
>
> SUMMARY
> I have an IIS6.0 server which has recently been upgraded to ASP 2.0 as a
> result of some of the patch requirements of some products I have installed
> on my server.
> These patches have installed a SQLEXPRESS upon which ASP 2.0 seems to have
> some connection to. ASP pages have now failed when the web site was
> switched
> from ASP 1.1 because it is constantly asking for 'authentication' on the
> IIS
> page and no credentials. I need two things:
>    1) stop it from rejecting the authentication and get ASP to work.
>    2) SQLEXPRESS database to migrate to SQL2005 server which is working in
> the same server.
>
> SETUP
>    Win2003 Std R2
>    Office 2003
>    SQL 2005 std (db, client and books only)
>    Sharepoint 2003 + ('STS SP2' patch, then 'Portal SP2' patch')
>    Biztalk 2006 eval.
>    Portal Website is created. Website is then switched to ASP 2.0. STSADM
> was run.
>
> ERROR MESSAGES
>    When sharepoint website was running on ASP 1.1, everthing was ok. When
> ASP2.0 was added, The web site would request for authentication as it
> normally does and if you authenticated as administrator it should normall
> let you in. This time no credentials would work (administrators, service
> accounts) and it would continually request for authentication - failure
> with
> 403 after third password failure.
>    On checking the IIS 6.0 (properties of website), go to ASP tab, you
> will
> see the ASP version is 2.0 (when we changed it earlier). On checking the
> config (GLOBAL and other one). The connection string show something like
> this (I am recalling as I am rebuilding the box at the moment).
>    LocalServer "data source=.\SQLEXPRESS; Security=SSPI;Files=|\Data
> Files\datafile.mdf;Option=ua"
> The line is not wrong - I just can't remember it properly, the pertinent
> point it that it wasn't altered.
>
> COMPENSATION ATTEMPTS
>    After checking google, I am on unfamiliar ground but I have attempted
> two things:
>
>    Attempt 1
>    run aspnet_iisreg to create new asp database in MSSQLSERVER (the local
> install on SQL2005) called ASPNET
>    LocalServer "data source=.\MSSQLSERVER; Security=SSPI;Initial
> Catalog=ASPNET;Option=ua"
>    LocalServer "data source=.\MSSQLSERVER;
> Security=SSPI;database=ASPNET;Option=ua"
>    (note MSSQLSERVER is the virtual server and ASPNET is the database I
> created via aspnet_iisreg)
>
>    Attempt 2
>    returned connection strings of BOTH ask configs back to normal.
>    granted service accounts full access to SQLEXPRESS instance
>
> COMMENT
>    Any pointers to documentation will be welcome. I am in process of
> rebuilding workstation again, so additional requests for more info might
> be
> sparse as I have blown the box away. I dare say I will get the problem
> again. I am going to try to install the machine and see whether the pre
> requesites can be configured not use an EXPRESS/MSDE instance - though I
> doubt it.