Getting started with SQL Server Express Edition - total newbie

[Robert]

Hello

I installed SQL Server Express Edition on my computer but I can't figure
out how to get into the Enterprise Manager to create a database. When in
click on SQL Server in programs I get Configuration Tools. When I click on
Configuration Tools I get SQL Server Configuration Manager, SQL Server Error
and Usage Reporting, and SQL Server Surface Area Configuration. That's all.
How to go to the screen to create a database?

Roibert

[Ivan Delic]

You'll have to download and install SQL Server Management Studio from
Microsoft's web site and to install it unto your computer.

It is the sam tool like Enterprise Manager for SQL Server 2000.

After it, when you start the Studio, you'll have to connect to your
Server, default instance is (LocalMachine)\SQLEXPRESS. After it, it's
all the same like SQL Server 2000. Good luck.

Ivan Delic, Serbia

[Erland Sommarskog]

The plain download of SQL Express comes only with the command-line tools
SQLCMD and OSQL. Which certainly are sufficient to create databases, but
not very fun to work with in the long run.

So you certainly want SQL Server Management Studio Express, which is
available for free from
http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Robert]

Thank you. I tried to install Microsoft Core SML Services (MSXML) 6.0 and I
got this error message:

Installation of MSXML 6.0 Parser failed because a higher version already
exists on the machine. To proceed, uninstall the higher version and then
run MSXML 6.0 Parser Setup again.

Why would I want to replace something with a lower version?

Robert

"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9A559B748...@127.0.0.1...

[Robert]

Thank you. I tried to install Microsoft Core SML Services (MSXML) 6.0 and I
got this error message:

Installation of MSXML 6.0 Parser failed because a higher version already
exists on the machine. To proceed, uninstall the higher version and then
run MSXML 6.0 Parser Setup again.

Why would I want to replace something with a lower version?

Robert

"Ivan Delic" <ivc...@gmail.com> wrote in message
news:cf8c701c-deee-46f5...@64g2000hsw.googlegroups.com...

[Erland Sommarskog]

Robert (cpq1bcle[REMOVE]@verizon.net) writes:
> Thank you. I tried to install Microsoft Core SML Services (MSXML) 6.0
> and I got this error message:
>
> Installation of MSXML 6.0 Parser failed because a higher version already
> exists on the machine. To proceed, uninstall the higher version and then
> run MSXML 6.0 Parser Setup again.
>
> Why would I want to replace something with a lower version?

Did you get this error when you tried to install SSMS Express? Or else why
did you try to install MSXML?

[Robert]

Oh, I see there's another message below step 2 telling you not to do the
step as in step 1. It's working now. Thanks.

"Erland Sommarskog" <esq...@sommarskog.se> wrote in message

news:Xns9A55F002A...@127.0.0.1...