log on failure sql..

[david]

When my asp app tries to log on to the sql database i get
an exception which is as follows:

Exception Details: System.Data.SqlClient.SqlException:
Login failed for user 'ACER\ASPNET'.

i am new to the creation of squ connections and the
permissions that come with it, so i would appreiaiate any
advice on this matter.

thanks for the help.

 

[Chris Jackson]

You are trying to log in to the database using Windows authentication, which
is passing the credentials of the current process. The ASP.NET process uses
the ASPNET user, which is a machine-level user. Either change your
connection string to use SQL authentication (remove the sspi clause) or else
set impersonate=true in your web.config to impersonate another Windows
account. Once you select how you want to authenticate (Windows or SQL) if
you have any problems getting that specific method set up, post back again.

 

[David Binney]

thanks for the help,

i tried to remove the entire sspi clause (;integrated security=SSPI),
from the connection string and i got the following error message:

Exception Details: System.Data.SqlClient.SqlException: Login failed for
user '(null)'. Reason: Not associated with a trusted SQL Server
connection.

i also tried add the impersonate clause to the web.config file and i
recieved a similar message:

Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'ACER\IUSR_ACER'

i would appreciate any more help that you can give me!!!!