Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vodkasoda
Starting Member
15 Posts |
 Posted - 2012-01-31 : 12:51:13
|
| I have SQL Server 2008 R2 up & running, but I want to use .mdf files within my Project. Apparently I have to have SQL Server Express installed as well in order to do this. However, when installing SQL Server 2008 Express I am asked whether I want to do a "New Installation or add shared features" or if I would rather "Add features to an existing instance of SQL Server 2008 R2" ... Which do I need to do ? The first option says to select "if you want to install a new instance of SQL Server or install shared components such as SQL Server Management Studio or Integrated Services" (I already have Management Studio installed) and the second option says to install if I want to, for example "add the Analysis Service features to the instance that contains the Database Engine".This is as clear as mud ... which choice do I make ?!?!? |
|
|
sqldch
Starting Member
1 Post |
Posted - 2012-01-31 : 13:09:42
|
An .mdf file is simply a database file. If you installed SQL Server 2008R2, did you create a database? Which edition of SQL Server 2008R2 did you install (Express, Standard, Enterprise etc)? You can find this using:select @@version SQL Server Express has nothing to add to the other editions, so not sure what is needed from Express. |
 |
|
|
vodkasoda
Starting Member
15 Posts |
Posted - 2012-01-31 : 13:31:20
|
The version is Data Centre Edition.I realise that it's just a type of DB file within SQL, but if I try to create a database from within my Project, it insists that it must be a .mdf file and these can only be created (the Microsoft Error Message states this and I have googled it too) if you have the Express version installed.If I create it a DB outside of the project it is a .dbo file and is stored in my SQL folders on a different drive to my VS2010 folders and whilst this may not be a problem when I compile the project and transfer it to another PC (which is the ultimate plan) it is a problem now as VS2010 is not allowing me to do what my C# courses are telling me to do !!!I have no real problem installing Express, but as usual, these MS instructions are nonsense !!!quote:
Originally posted by sqldch
An .mdf file is simply a database file. If you installed SQL Server 2008R2, did you create a database? Which edition of SQL Server 2008R2 did you install (Express, Standard, Enterprise etc)? You can find this using:select @@version SQL Server Express has nothing to add to the other editions, so not sure what is needed from Express.
|
|
|
|
|
|
|
|
|
SQL Server Express Installation Type