I had an .mdf file in the app_data folder and now i have attached the database to the my SQL server 2008 r2 express server.
The database got attached successfully.
Then i deleted the app_data folder from the website and changed the connection string as.
cn = new SqlConnection("Data Source=.;Initial Catalog=RNW;User id=sa;Password=sqluser");
When i am trying to connect to the database i am getting the following error
"An attempt to attach an auto-named database for file F:\Real Estate Web\App_Data\RealEstate.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share"
I checked everything and even created a new website and added all the files manually without the app_data folder but it is still giving the same error.