In webconfig - connectionstrings in Visual Studio 2010 I have following:
<add name="MyConnectionString" connectionString="Data Source=MyComputer\SQLEXPRESS;Initial Catalog=MyDatabase;Integrated Security=True" providerName="System.Data.SqlClient"/>
The servername in Microsoft Sql Server Management Studio 2008 R2 is MyComputer\SQLEXPRESS. I use Window Authentication.
When I run my website locally I am not able to connect to the database with this connectionstring. What am I doing wrong?