Can I use Sql Server Database file in VS 2010 with SQL server 2008 r2 Developer Edition instance? Because every time I tried to add a database file to the VS solution to App_Data (which is an ASP.Net) folder it creates an error saying that "A network related error or instance related error occurred while establishing a connection to SQL Server".
I have googled with every possible scenarios but unfortunately I cannot find the fault. I even changed the SQL Server 2008 R2 Developers' TCP/IP and other network configuration but no use of them! This is very critical to me!