Re: Problem install SQL Server 2005 Express

Tech-Archive recommends: Fix windows errors by optimizing your registry

Have tried it all the ways I can think of and keep getting:

C:\sqlcmd-s.\sqlexpress
The system cannot find the path specified.
C:\sqlcmd –s . \sqlexpress
‘sqlcmd’ is not recognized as an internal or external command operable
program or batch file.

C:\SQLCMD –S . \SQLEXPRESS
‘SQLCMD’ is not recognized as an internal or external command operable
program or batch file.

=====================

Looked into C:\WINDOWS – I notice the following – can this give you a clue?

C:\WINDOWS\SQL9_KB948109_ENU
C:\WINDOWS\SQL9_KB960089_ENU
C:\WINDOWS\SQLTools9_KB948109_ENU
C:\WINDOWS\SQLTools9_KB960089_ENU
==================

If as you indicated in your first response that it's possible to have
several instance of
SQL Server installed on the same machine - could I uninstall the one that
shows up in the "Windows Install Clean up" and reinstall following the "How
to: Install SQL Server Express" (SQL Server 2005 Books Online[Nov 2008]) and
this time select "Named instance".
---------------
The directions say:
On the Instance Name page, select a Default instance or a Named instance for
your installation. If you select Default instance, an existing default
instance will be upgraded. If you select Named Instance, specify an instance
name or the default named instance of SQLExpress is used. Click Next.

Click Installed Instances to view a list of installed SQL Server Express
instances and components on the computer where SQL Server Express Setup is
running. The installed instance details pane will display upgrade options for
installed instances.

SQL Server Express Setup checks whether the instance name SQLExpress exists
at startup.

If SQLExpress instance exists, then by default, the Instance name page
appears.

If SQLExpress instance does not exist, then by default, the Instance name
page is hidden from the user. However, if you clear the Hide Advanced
configuration options check box on the Registration Information page, the
Instance name dialog box appears at all times.

-----------------------------

Appreciate you help.


--
Bettyc


"Aaron Bertrand" wrote:

Maybe you should leave the spaces intact? In Erland's example, there is a
space before and after "-S" ...


On 9/17/09 12:20 PM, in article
0EC10E72-4F31-404B-9C8E-0461BC72777D@xxxxxxxxxxxxx, "bettyc"
<bettyc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Trying to learn ASP.Net and Visual Web Developer I was using book from Scott
Mitchell - installed disk that came with that.

I am new at this - how/where do I write the line? Do I go to
Start
Accessories--
Command Prompt
c:\SQLCMD-S.\SQLEXPRESS

?? AND KEEP GETTING MESSAGE NO RECOGNIZED.

Would appreciate your help.

Bettyc


"Erland Sommarskog" wrote:

bettyc (bettyc@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
My System is Windows XP Professional - have installed Visual Web
Developer 2005 Express Edition and trying to install SQL Server 2005
Express and keep having problems. I have tried several time to remove
and reinstall both programs following directions from the Microsoft
site, used the Window Install Clean Up etc.

So which instance name do you specify when you install SQL Server?
It seems that you already have an instance called SQLEXPRESS, so
you would need to choose a different name - or use this instance you
apparently already have.

This is the background: it's possible to have several instance of
SQL Server installed on the same machine. The instance can be of
different versions of SQL Server, different editions, or be all the
same. They are entirely independent from each other with their own
logins etc.

One instance can be a default instance, to which you refer the with
servername only. All others are named instance to which you refer
as MACHINE\INSTANCE. When you install SQL Server Express, it is by
default installed as a named instance (in case you install one of
the major editions later), and by default the name for that instance
is SQLEXPRESS.

You may already have SQL Express installed, because it may come
with some third-party software. You may also get it when you install
Visual Studio.

Try opening a command-line window and run:

SQLCMD -S .\SQLEXPRESS

(The dot is a shorthand for the local machine.)

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx




.

Relevant Pages

  • Installing Report Services with Named Instance
    ... The preparing To Install doc states under "Choosing a Named Instance" quote: ... Windows XP or Windows 200, and the local SQL Server is a named instance. ...
    (microsoft.public.sqlserver.tools)
  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: windows xp update weirdness
    ... Make sure the SQL Server service [SQL Server (SQLEXPRESS)]is set to startup automatically in the Services console Start> Run> type in services.msc ... showing for the updates that failed to install or, see if there were KBxxxxxx.logs ...
    (microsoft.public.windowsupdate)
  • Re: Critical Alert Update - W32.Slammer
    ... The .net SDK 1.0 sp1 comes with a very basic SQL Server engine for testing ... >> Microsoft SQL Desktop ... >>>cumulative SQL security patch, is completely safe from ... >> may install SQL ...
    (microsoft.public.security)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)