Attaching SQL Server Express DB and adding to setup project in VS2008

See more:

SQL-Server

Visual-Studio

Hi,
1) I added mdf file through Visual Studio. I am trying to attach it to SSMS but it gives error. How to attach it? Do I always need to create them through SSMS?

2) I created an mdf through SSMS and the physical path was of my DataDirectory of my application. It is running fine. Now I need to make Setup of this application.

a) Am I supposed to Add this database to my setup project? If yest, does my user need to attach it manually to the instance of SQL Server? My connection string uses MyServer\SQLExpress

b) I tried to add this database to setup project but it says you need administrator rights for this. What is that? How to set it up? I am already using computer with administrator rights.

Please reply as I have put up the questions point wise.
Thanks a lot.