Login failed for user '\ASPNET' error

[Schetan]

hi ,
In my application use connection string in web config file like
<add name="sqlConnectionString" connectionString="Data Source=CHETAN;Initial Catalog=bazar; Integrated Security=True" providerName="sqloedb"/>

by using that connection my application will run but when i am running same appli cation in IIS it gives me error:

Cannot open database "bazar" requested by the login. The login failed. Login failed for user 'CHETAN\ASPNET'

and one thing again same my application access on other machine by using ip address it display proper home page but when enter login and password it gives error like aboe

so help me please , I ties various ways but dont get any success
please tell me solution for that problem soon

Thanks & Regards
Chetan Chopkar

[kenobewan]

Have you been into sql server and set up the logins and permissions that you want to use?

[Curtis Rutland]

You need to allow the ASPNET windows user account access to your SQL Server. Alternatively, you can create a Sql Server account inside the Sql Server, and provide a username and password in your connection string.