x

SQL 2005, SQL 2008 and SQL Express 2005

I've got a new development machine that I'm configuring. I want to put both SQL Server and Visual Studio 2008 onto this box. It's running Windows 7, so I'll put the developer edition onto it. I'd been wondering if the order in which I install Visual Studio (VS) and SQL Server makes a difference, and it doesn't look as though it does. But one person suggested that I install VS first, but not install SQL Server 2005 Express, which normally goes on when you install VS. I've been thinking of putting SQL Server 2008 Developer Edition on (I have no experience with it, but do with SQL 2005, and now would be a good time to give the new version of SQL Server a try.)

However, I'm wondering if there's some good reason why I should not install SQL Express, if I want to put on SQL Server 2008?

more ▼

asked Oct 20, 2009 at 06:11 PM in Default

avatar image

Rod
801 48 51 55

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

Generally I would have installed SQL Server 2008 first, then either VS or 2005 Express. Once you get the base established with 2008, the other installs don't seem to cause issues.

more ▼

answered Oct 20, 2009 at 10:41 PM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left

Ha funny you should say that - I am at this very moment installing 2K8 on a fresh Windows 7 install...

For 2005 you need Service Pack 3, and for 2008 you need Service Pack 1 - so get downloading those if you haven't already.

I skipped the 2005 express that VS2008 wanted to install, and just went with developer editions of both SQL Server 2005 and 2008.

The good reason to not install SQL Express is that if you have access to developer edition, then there's no reason to install it.

more ▼

answered Oct 20, 2009 at 07:36 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

(comments are locked)
10|1200 characters needed characters left

There is no significant reason that it matters, but do be careful with the defaults.

By default the first instance of SQL Server you install is the primary one and all others are named. You can of course change that and name the first instance and force a later one to be primary, but it is generally simpler just to install the one you want to be the primary instance first.

more ▼

answered Oct 20, 2009 at 06:25 PM

avatar image

TimothyAWiseman
15.6k 22 51 38

(comments are locked)
10|1200 characters needed characters left

I have heard some anecdotal evidence where installing Express with VS does then cause issues later on if you want to install dev edition, but never actually experienced it.

more ▼

answered Oct 20, 2009 at 08:26 PM

avatar image

Kev Riley ♦♦
64.2k 48 62 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2091
x2017
x56

asked: Oct 20, 2009 at 06:11 PM

Seen: 2265 times

Last Updated: Oct 20, 2009 at 06:11 PM

Copyright 2016 Redgate Software. Privacy Policy