Really need help!

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.

I have reinstalled everything again and this time I am getting an "instance"
error.
Summary.txtMicrosoft SQL Server 2005 9.00.4035.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build
2600)
Time : Tue Sep 15 23:10:03 2009

Machine : BETTYCOCHRAN
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.4035.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_BETTYCOCHRAN_SQLS upport_1.log
--------------------------------------------------------------------------------
Machine : BETTYCOCHRAN
Product : Microsoft SQL Server Native Client
Product Version : 9.00.4035.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_BETTYCOCHRAN_SQLN CLI_1.log
--------------------------------------------------------------------------------
Machine : BETTYCOCHRAN
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.4035.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_BETTYCOCHRAN_SqlW riter_1.log
--------------------------------------------------------------------------------
Machine : BETTYCOCHRAN
Product : MSXML 6.0 Parser
Product Version : 6.10.1129.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_BETTYCOCHRAN_MSXM L6_1.log
--------------------------------------------------------------------------------
Machine : BETTYCOCHRAN
Product : SQL Server Database Services
Error : An instance with the same name is already installed on
this computer. To proceed with SQL Server Setup, provide a unique instance
name.
--------------------------------------------------------------------------------
Machine : BETTYCOCHRAN
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.3.4035.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_BETTYCOCHRAN_SQL. log
Last Action : DetectInstanceClash
Error String : An instance with the same name is already installed on
this computer. To proceed with SQL Server Setup, provide a unique instance
name.
Error Number : 28086
--------------------------------------------------------------------------------
The Registry shows:
{HKEY_LOCAL-MACHINE]\Software\Microsoft\Microsoft SQL Server\
90
ExceptionMessageBox
Instance Names\SQL (Name - SQLEXPRESS Type- REG-SZ Data- MSSQL.1
MSSQL.1
MSSQL.2
Services
SQLEXPRESS

=====================
I would appreciate anything you can do to assist me. I am trying to learn
ASP.Net 2 and Visual Web Developer - but am now stuck.
Thanking you in advance.

--
Bettyc

bettyc (bettyc (AT) discussions (DOT) microsoft.com) writes:
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 (AT) sommarskog (DOT) se

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/prodinf...ons/books.mspx

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:

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...soft (DOT) com, "bettyc"
<bettyc (AT) discussions (DOT) microsoft.com> wrote:

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:

bettyc (bettyc (AT) discussions (DOT) microsoft.com) writes:
It may be that it is not in your path. Try this:

"C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE" -S
..\SQLEXPRES

Notes:

1) This should be all one line.
2) This may not be the exact location (but it is the one I would expect),
so you may have to look around.

Yes, you defintely have an instance of SQL Server on the machine. Those
files are from patches to it.

You could, but if you already have one, the easiest is to use it.

Oh, also check in the Start Menu, if you have a Microsoft SQL Server
program group. In that case, you should find the SQL Server Configuration
Manager there where you can tell which instances you currently have
installed.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

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/prodinf...ons/books.mspx

tried the things you suggest - but did not find the file.

Then did a "search" of SQLCMD.exe and found one in each of the following
files in in each of the folders:
C:\WINDOWS\SQL9_KB948109_ENU
C:\WINDOWS\SQL9_KB960089_ENU
C:\WINDOWS\SQLTools9_KB948109_ENU
C:\WINDOWS\SQLTools9_KB960089_ENU

Are these the files I need?




--
Bettyc


"Erland Sommarskog" wrote:

bettyc (bettyc (AT) discussions (DOT) microsoft.com) writes:
Normally you would not run SQLCMD from such a directory, but for this
purpose it should work.

It seems that you have an Express instance installed by some third-party
software. Probably that software did not install any tools at all.
Which makes sense, since you are probably not able to play with it
on your own.

Anyway, your Setup file clearly says that there is an instance SQLEXPRESS,
so you have two options:

1) Install a second instance with a new name.
2) Only install tools (so that you get SQLCMD and that).

I think you have to select Advanced somewhere in the Setup wizard
to get to these options.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

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/prodinf...ons/books.mspx