visual studio web developer 2010 SQL Connection

I only need to import a SQL database file into my project. (I'm a beginner in C#.net) When I import the file and click OK, it gives me the following error. Please look at the attachment. Pleases provide clear instructions step by step. I also included a copy of my configuration in the screenshot. The SQL file that I need to import was created with the same project but even though I imported all the files from the previous project into visual studio, I cannot import the SQL file.

Thank you all,
Paul
 error
pauledwardianAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EyalCommented:
I assume it's something related to security
0
pauledwardianAuthor Commented:
can u be more specific based on the screenshot I uploaded?
0
EyalCommented:
first I would try to add user Everyone to the file and see what happens

can you access the database from the same machine?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

pauledwardianAuthor Commented:
I got the same error.
0
EyalCommented:
can you connect the database from management studio on the server?
0
pauledwardianAuthor Commented:
The server that has managment studio is my personal computer at home. Anyways, I recieved an error. Please look at the attachment:
 Error in SQL
0
EyalCommented:
can you post the mdf file here?
0
pauledwardianAuthor Commented:
Here you go:

 Address.MDF
0
EyalCommented:
you have to have this 2 files in order to open the file

C:\Program Files\Microsoft SQL Server\MSSQL\data\AddressBook_Data.MDF
C:\Program Files\Microsoft SQL Server\MSSQL\data\AddressBook_Log.LDF

can you do a full backup of the original database?
0
pauledwardianAuthor Commented:
I downloaded these two files that was included in an open source project on the web.
I changed the extension of log file from LDF to MDF so I can upload both here:
 Address.MDF
 AddressBook-Log.MDF
0
EyalCommented:
now it worked in my side :)

put the ldf right next to the mdf and try.
if not helping attach the database to your local instance of sql express
0
pauledwardianAuthor Commented:
can you tell me how you did it? I have windows 7 64 bit with sql management studio 2008 visual studio 2010 web developer (express) installed on my computer. Maybe im doing it wrong!
0
pauledwardianAuthor Commented:
Eval would you please tell me how you did it? I have windows 7 64 bit with sql management studio 2008 visual studio 2010 web developer (express) installed on my computer. Maybe im doing it wrong!
I basically need to open this MDF sql database in my web developer visual studio 2010 project. Please advice.
0
EyalCommented:
1) take the 2 files and put them where you want them to be
2) from the database node in the management studio select attach
3) on the opened screen press the add and select the mdf file (must be on same machine)
4) after you select the MDF you will get on the bottom of the screen 2 records.
5) fix the paths of the files on both rows
6) press OK
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pauledwardianAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.