Communicating between ASP.NET and SQL Server on separate servers

17 Aug 2005 10:55 PM

Marc Butenko

I have an ASP.NET (version 1.1) application that needs to read data from a
SQL Server 2000 database. Both IIS and the SQL Server are running Windows
2000.

My first attempt to get this to work was to create mirrored local ASPNET
accounts (same user name and password) on both boxes and give this account
rights to the database. This caused a "Server Application Unavailable"
message, which referred me to the event log. The event log had an error:
"aspnet_wp.exe could not be launched because the username and/or password
supplied in the processModel section of the config file are invalid.
aspnet_wp.exe could not be started.
HRESULT for the failure: 80004005"

So, after some research I modified the <processModel> portion of the
Machine.config file to specify the same password as the local ASPNET
accounts. I still get the same error.

Does anyone have a clue how to resolve this?

A second question is what is the "best practice" for connecting to SQL
Server when it is on a different server than IIS?

Thanks,
Marc Butenko
mbute***@mt.gov

19 Aug 2005 6:34 AM

Dominick Baier [DevelopMentor]

Hello Marc,

because of the limitations of the process modell under IIS5 - i would recommend
using sql accounts (that means specifying username/password in the connection
string) - or better - upgrade to IIS6.

---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

Show quoteHide quote

> I have an ASP.NET (version 1.1) application that needs to read data
> from a SQL Server 2000 database. Both IIS and the SQL Server are
> running Windows 2000.
>
> My first attempt to get this to work was to create mirrored local
> ASPNET
> accounts (same user name and password) on both boxes and give this
> account
> rights to the database. This caused a "Server Application
> Unavailable"
> message, which referred me to the event log. The event log had an
> error:
> "aspnet_wp.exe could not be launched because the username and/or
> password
> supplied in the processModel section of the config file are invalid.
> aspnet_wp.exe could not be started.
> HRESULT for the failure: 80004005"
> So, after some research I modified the <processModel> portion of the
> Machine.config file to specify the same password as the local ASPNET
> accounts. I still get the same error.
>
> Does anyone have a clue how to resolve this?
>
> A second question is what is the "best practice" for connecting to SQL
> Server when it is on a different server than IIS?
>
> Thanks,
> Marc Butenko
> mbute***@mt.gov