Installed SQL 2005 for the first time. I noticed Enterprise Manager is
missing. So I went into Configuration Manager since it sounded similar and
low and behold I discovered that all the databases that get created in SQL
Server 2000 like Master, Model, Northwind, etc are missing. My question is
are they actually missing or do I need to install an add-on to see them?
Spin
> Installed SQL 2005 for the first time. I noticed Enterprise Manager is
> missing.
It is not Enterprise Manager anymore. EM & Query Analyzer have been
combined into a single GUI tool called Management Studio. It should be
under the program files folder for SQL Server 2005, and if not, perhaps you
didn't pay close attention during install. You need to specify that
Management Studio is to be installed by going into Workstation Components.
> low and behold I discovered that all the databases that get created in SQL
> Server 2000 like Master, Model, Northwind, etc are missing.
Well, master and model are certainly there. What does "missing" mean? I
think you need to get Management Studio up and running before you can make
any judgment calls on what's there and what's not.
Oh, and Northwind is no longer a database that ships with SQL Server (same
as pubs). You can install AdventureWorks which is found under Sample
Databases in setup.
|||> What is the name of the file that I click on to bring up the Management
> Studio tool?
The executable is sqlwb.exe. However, the full name should be in a shortcut
on your start menu.
|||I do not have this executable. So I put the CD back in and do what?
Why does Microsoft have to make this so hard?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OY4FPGFfHHA.1244@.TK2MSFTNGP04.phx.gbl...
> The executable is sqlwb.exe. However, the full name should be in a
> shortcut on your start menu.
>
|||>I do not have this executable. So I put the CD back in and do what?
Since you already have the server installed, then open the CD, go to the
tools folder, run setup.exe, and when you get to the screen that asks which
components you want to install, slow down. First you'll go through these
steps:
(a) check "I accept the licensing terms and conditions"
(b) hit " Next > "
(c) wait for prerequisites to be installed (yes it will have to do this
every time)
(d) hit " Next > "
Now you will be at "Welcome to the Microsoft SQL Server Installation Wizard.
(a) hit " Next > "
(b) as long as you don't have any errors on the config check, hit " Next > "
(c) enter your name and company (or leave blank if desired)
(d) hit " Next > "
(e) on the feature selection page, expand Client Components
(f) I would select Connectivity Components and Management Tools (you may
choose others if you wish)
(to select a component, you click on the down arrow next to a component,
and choose "Will be installed on local hard drive")
(g) if you want sample database and/or Books Online, expand the
Documentation, Samples... node
(h) hit " Next > " ... I assume you'll be okay without assistance from here?
> Why does Microsoft have to make this so hard?
I don't think they made it as hard as you make it out to be. And be honest,
did you read "ReadmeSQL2005.htm" and setup instructions, and pay attention
to all screens while you were installing the product?
|||Thank you!
To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
simply expect the products to have the same tools in the same places as the
previous versions. We're all too busy in this life to have company software
throw us curveballs. I think MS should recognize that everyone is busy and
have products be intuitive enough to the point where you don't have to RTM.
Well, maybe RTM is a good thing b/c it keep us IT people in a job! Well,
it's off to the manual and this thing now.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ucElrmKfHHA.2376@.TK2MSFTNGP04.phx.gbl...
> Since you already have the server installed, then open the CD, go to the
> tools folder, run setup.exe, and when you get to the screen that asks
> which components you want to install, slow down. First you'll go through
> these steps:
> (a) check "I accept the licensing terms and conditions"
> (b) hit " Next > "
> (c) wait for prerequisites to be installed (yes it will have to do this
> every time)
> (d) hit " Next > "
> Now you will be at "Welcome to the Microsoft SQL Server Installation
> Wizard.
> (a) hit " Next > "
> (b) as long as you don't have any errors on the config check, hit " Next >
> "
> (c) enter your name and company (or leave blank if desired)
> (d) hit " Next > "
> (e) on the feature selection page, expand Client Components
> (f) I would select Connectivity Components and Management Tools (you may
> choose others if you wish)
> (to select a component, you click on the down arrow next to a
> component, and choose "Will be installed on local hard drive")
> (g) if you want sample database and/or Books Online, expand the
> Documentation, Samples... node
> (h) hit " Next > " ... I assume you'll be okay without assistance from
> here?
>
> I don't think they made it as hard as you make it out to be. And be
> honest, did you read "ReadmeSQL2005.htm" and setup instructions, and pay
> attention to all screens while you were installing the product?
>
|||> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
> simply expect the products to have the same tools in the same places as
> the previous versions.
I don't think this expectation is very realistic. If a product does not
evolve, then don't bother upgrading beyond v1.0.
A
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
> I don't think this expectation is very realistic. If a product does not
> evolve, then don't bother upgrading beyond v1.0.
> A
You're right, I was just b%tching and moaning, trying to get my voice heard
by Microsoft. Thanks for listening.
|||Aaron, that tip worked btw! Nice job!
"Spin" <Spin@.spin.com> wrote in message
news:586md5F2ftkduU1@.mid.individual.net...
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
> You're right, I was just b%tching and moaning, trying to get my voice
> heard by Microsoft. Thanks for listening.
