first of all hello, I have a questions regarding the data connections process between Microsoft SQL 2005 and Microsoft Visual Web Express 2010.
I had a database (.mdf) file already attached on the server, when I initiate to create a database connection for the first time, visual web express cannot establish the connection, but after i drop the database file and proceed it was successful, is this a common thing? i tried the same step using Microsoft SQL 2008 and everything works fine, whether the database file it attached or not.
my step were as the following;
from database explorer
1.right click data connections
2.select add connections
3.from data source I chose Microsoft SQl Client(sqlClient)
4.from server name I chose the local server name
5.use window authentication
6.chose attach a database file
7.test connection