Upgrade to SQL Server 2012 Express causes Login failed error

This is exactly what I tried last night and the answer is No, not able to connect. The same error: "Login failed for...".

Is there anything which is turned off by default after a fresh install that can block the connection? The SQL server and the ASP.NET application run on the same machine.

That means the logins are not created properly

Then try accessing through integrated security login and create the logins again.

I can connect to the DB using Integrated Security and then it gives me the following connection string:

Data Source=RAPOPC\SQLEXPRESS;Initial Catalog=dobrycajcz;Integrated Security=True

If I put it into a web.config and run the application, it comes back with the following error:

"Cannot open database "dobrycajcz" requested by the login. The login failed.  Login failed for user 'IIS APPPOOL\DefaultAppPool'."

Yes it will not work as ASP.Net does not use your windows login to connect to SQL Server. So best way is to create logins in SQL Server if you are able to login through Management Studio

I got back to SQL 2008 and it works fine for me. Thanks anyway.