SQL Server 2K5 and VS.NET: Order of Installation

[Jeremy S.]

I'm about to install VS.NET 2005 and SQL Server 2005 on a new/clean
development machine (XP Pro/SP2 etc).

Is the order of installation important (i.e., which product should I install
first)?

Thanks!

 

[Juan T. Llibre]

I would install SQL Server 2005 *first*, and then install VS 2005.

If you're talking about SQL Server Express 2005, VS 2005 will install it for you,
so -in that case- there's nothing to worry about : install VS 2005 first,
and you won't need to install SQL Server Express 2005: VS 2005 will do it for you.

 

[Niels Berglund]

I'm about to install VS.NET 2005 and SQL Server 2005 on a new/clean
development machine (XP Pro/SP2 etc).

Is the order of installation important (i.e., which product should I install
first)?

I have always installed SQL before VS. I don't know what it's like now
after RTM, but at one stage during the betas you had to install SQL
before VS, so I'm always doing that now.

Niels

 

[Guest]

VS first, SQL later.

The SQL 2005 Server installation won't let you choose the install folder for
the BI Management Studio, so you won't be able to change the destination when
installing VS 2005.

But then again, maybe you don't care about that.


ML

 

[Juan T. Llibre]

re:

you won't be able to change the destination when installing VS 2005

OK, I'll bite : why is choosing the install folder for BI Management Studio important to me?

Does Business Intelligence Management Studio take up that much hard disk space ?

VS first, SQL later.

 

[Jeremy S.]

I have the Professional edition of each.

On another machine I installed SQL SQL Server first, but it apparently
installed some version of VS.NET (perhaps for Management Studio). Thus my
question. Prior to the 2K5 versions, I installed SQL Server by itself
first - but apparently we now get both. Maybe it doesn't really matter.

-J

 

[Juan T. Llibre]

re:

On another machine I installed SQL SQL Server first, but it apparently installed some version of
VS.NET (perhaps for Management Studio).

I'm not sure I follow you.

How can SQL Server 2005 Professional install VS.NET ?

re:

but apparently we now get both.

If by "both" you mean both SQL Server 2005 and SQL Server Express 2005,
which is -optionally- installed by VS.NET, not the other way around,
you can install VS.NET using the "Personalized" option, and then you can
de-select SQL Server Express 2005 so that VS.NET doesn't install it,
if you only want to work with SQL Server 2005.

re:

Maybe it doesn't really matter.

It does. It's important to share information, so others aren't misguided.

 

[MSDN]

I don't remember the order I did but SQL Server Management Studio did not
install for me.
I had to uninstall then reinstall in the reverse order. Sorry don't
remember the order.
Did anyone find this to be true or had this situation?

Thanks

SA

 

[Jeremy S.]

Okay, rather than trying to recall what happened before, I just went through
the installation of SQL Server and VS.NET 2005 on a clean machine. Here's
what happened.

1. I installed SQL Server 2005 Standard first (before VS.NET).
2. On the first attempt I received the following error message:
"SQl Server Setup failed to obtain system account information for the ASPNET
account. To proceed, reinstall the .NET Framework, and then run SQL Server
Setup again."

Rather than following those instructions, I went backwards in the setup
wizard and deselected various components until I disovered that including
Reporting Services is what caused that error message to appear. Once I
deselected Reporting Services, the installation of SQL Server proceeded
without further incident.

3. Prior to installing VS.NET, I observed that my Start menu had an item for
"Microsoft Visual Studio 2005" - curious to me because I had only installed
SQL Server Standard at this point. I opened it and, sure enough, there was
the VS.NET IDE. I opened Help | About Microsoft Visual Studio and it listed
the version as Version 8.0.50727.42 (RTM.050727-4200).
The list of Installed products included only these:
__ SQL Server Analysis Services
__ SQL Server Integration Services
__ SQl Server Reporting Services (curious because I didn't install that! at
least I had it DESELECTED in the SQL Server installation wizard)

I then navigated, in the VS.NET IDE to File | New | Project and the only
project types available were "Other Project Types" ---> Visual Studio
Solutions ---> Blank Solution.
Obviously this is not a full installation - but the SQL Server Standard
edition installation does install VS.NET.

So this, Juan, is what I was recalling in my earlier post as "we apparently
get both" when you install one of the products. Sorry I wasn't more clear on
that.

4. I then proceeded to install VS.NET Professional from the DVD. That
installation proceeded smoothly. I then checked Help | About Microsoft
Visual Studio and it listed the version was of course still Version
8.0.50727.42 (RTM.050727-4200).
But now the list of Installed products included 6 additional items, like
each of the languages (C#, etc) and Crystal Reports. And, of course, all of
the possible/expected project types were available via File | New | Project.

So, that's what happens when one installs SQL Server prior to VS.NET. I
suppose I'll have to go back and add Reporting Services now.

-J

 

[Guest]

BI Studio is automatically installed in the "Visual Studio 8" folder, which
means:
"%system%\Program Files\Visual Studio 8\", unless VS has been installed to a
different folder prior to the SQL Server installation.

VS install won't allow you to change the destination folder if you install
SQL Server before VS.

I personally don't keep my development tools on the system disk.


ML

 

[Juan T. Llibre]

Thanks, a lot, for going the extra mile, Jeremy.

 

[Juan T. Llibre]

re:

I personally don't keep my development tools on the system disk.

I figured that was at the root of this.
I do the same...plus I keep my temp directories and paging file in a different disk, too.

 

[Cowboy \(Gregory A. Beamer\)]

The order is not important, as SQL Server installs a VS shell that VS adds
on to and visa versa. Note that the GUI parts of SQL Server will install to
the same directory that VS is installed to. If you are using default paths,
there is no issue. If you put apps on another drive, make sure the GUI bits
are correct for whichever you install first.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[Cowboy \(Gregory A. Beamer\)]

This is incorrect ML. You can specify a path, if you click the advanced
button and go to the client tools and choose a folder. SQL will not let you
choose a path, however, if VS is already installed. Nor will VS let you
choose a path if the client tools for SQL is already installed.

The order is unimportant, overall. I prefer SQL first, as I can get up and
running as soon as the VS install is done, but it is not critical either
way.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[Cowboy \(Gregory A. Beamer\)]

BI studio and the SQL Management tool are Visual Studio, or at least the VS
shell. When you install the client tools, you install VS ... period.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[Guest]

I've looked at all the Advanced options of the SQL Server setup but found no
way of selecting a different destination path for the BI Management Studio.
Once BI Management studio is installed, the destination path for the VS 2005
installation cannot be changed.

Please explain your experience if you've found the installation(s) to behave
differently.


ML

 

[Juan T. Llibre]

Sure, the tools are installed as a part of VS.NET.
That's not the same as installing *VS.NET*, though.

 

[parleer]

I wish I had read this earlier. I was installing this morning and figured I should install SQL Server 2005 before VS2005 because that's how I remembered having to do it. Now my C drive is full and I'll have to uninstall.

BI Studio is automatically installed in the "Visual Studio 8" folder, which
means:
"%system%\Program Files\Visual Studio 8\", unless VS has been installed to a
different folder prior to the SQL Server installation.

VS install won't allow you to change the destination folder if you install
SQL Server before VS.

I personally don't keep my development tools on the system disk.


ML

---
http://milambda.blogspot.com/