Connecting to SQL Server DB and .NET framework v2

[jstasz]

I have a web ap which works just fine connecting to Sql Server DB on another node when using V1 of the .net framework.

I am getting the following error.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

The event log on the SQL server node indicates a bad user id or password. However I have set (and reset) the ASPNET account password several times.

Can anyone point me to a good reference document on ASPNET security with v2 of the .net framework?

Everything I am finding with my searches is still referencing v1 of the framework, and due to the changes in this area, those solutions don't work!

Thanks

Joyce

 

[bassguy]

Check your web.config to make sure they are the same, also are you using application blocks?

could you post some of your Data aCCESS CODE?


bassguy

 

[jstasz]

This what I did on the development PC which has Visual Studio 2003 and v1.1 of .net framework. I followed a microsoft security document to get this to work.

Sqlconnection:
integrated security=SSPI;data source="ITK-SQL01";persist security info=False;initial catalog=BL3_Warehouse

Set the ASPNET account password on my machine (the machine running iis)
Set the ASPNET account password on ITK-SQL01 to the same password (the machine running Sql Server)
comment out the impersonate tag in the web.config file
Modify the machine.config file on my pc (the iis machine) so that the processsModel
tag has username="machine",Password="the ASPNET account password"

I have tried to do these same things, as well as modify the connection and provider on the asp.net tab in iis on the server with v2 of the framework. Nothing seems to work!

Te event log on the sql server machine is getting a passord error on the ASPNET user account, and the account does get locked out if I test too many times! So it appears the problem is with the ASPNET user password not getting passed correctly.

Thanks

Joyce