Installing SQL Server Express 2008 R2 when SQL Server 2008 Full version is already installed

Question

0.00/5 (No votes)

See more:

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 ?!?!?

Posted 31-Jan-12 7:10am

Gary Heath

Add a Solution

Comments

Uday P.Singh 31-Jan-12 13:19pm

what is your requirement?

Gary Heath 31-Jan-12 13:35pm

My SQL Server version is Data Centre Edition.

If I try to create a database from within my VS2010 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 I 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 as well, but as usual, these MS instructions are nonsense !!!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Uday P.Singh · Accepted Answer · 2012-01-31T07:25:00

You can refer to this video [^]on youtube, which explains the installation steps.

I would suggest you to go for "New Installation or add shared features" and

the features installed will be automatically selected and not installed features you can select and add. Same thing I did when I had to install.

hope it helps :)