I created a database in SQLExpress that I can connect to fine from C# console and windows forms apps.
However, when I try and open a connection using ASP.NET, the connection fails with:
"Cannot open database "AutoLot" requested by the login. The login failed.
Login failed for user 'KINKLADZE\ASPNET'.
It seems that ASP.net webapps will run under a user called <machine name>\ASPNET, but my SQLExpress db doesn#t know about this user.
How can I add this user to SQLExpress, or is there another way around this ?