Click here to Skip to main content
15,902,114 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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 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
[no name] 23-Jun-11 1:16am    
it should work properly...

1 solution

Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900