Wednesday, June 17, 2009

SQL Server Setup failed to obtain system account information for the ASPNET account.

Situation:

Upgrade from a production win 2000 server to win 2003.Installing: MSSQL Server Standard Edition 2005 (although enterprise will almost certainly behave the same way)Identical Error message as the original poster detailed:SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.

Solution 1:

A previously installed website app had reconfigured IIS to run in "IIS 5.0 isolation mode"The default for IIS 6.0 is to be running in "worker process isolation mode"Go to Start>Programs>Administrative Tools>Internet Information Services ManagerRight click the "web sites" folder and select propertiesselect the "service" tab and under the "isolation mode" header - CLEAR the checkbox "Run WWW service in IIS 5.0 isolation mode"If this is your problem - Removing and replacing the IIS services from add remove programs WILL NOT fix it - the configuration for the IIS server remains intact (although you will likely accidentally blow up an exchange server if its on the same machine because you'll likely accidentally remove the SMTP service which is under the web server)More Explicit instructions on how to change the mode in the following Technet Article:http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/ed3c22ba-39fc-4332-bdb7-a0d9c76e4355.mspxIf you can't locate it at that link anymore - search for the following headings:IIS 6.0 Documentation > IIS 6.0 Operations Guide > Server Administration Guide > Configuring Servers for ApplicationsConfiguring Isolation Modes (IIS 6.0)

Solution 2:

like in my case, if the above solution doesnt work it out, we will have to enable the aspnet .netframework user. here is the link to the solution

http://dotnetfish.blogspot.com/2008/11/sql-server-setup-failed-to-obtain.html


1 comment: