Instance specified not valid

Hi,

I'm trying to install MSDE SP3 which I downloaded from MS at http://www.asp.net/msde/.
Following the instructions as best I can I unzipped the file into a Folder now called MSDE located on C: I then went to a command prompt and typed in the command given to start the install:

setup SAPWD=testsite SecurityMode=SQL

Hit enter and the installer started up and ran for a few secs and then came back with

The Instance named specified is invalid

There was no mention of including an instance name or the format for it.

Suggestions please?

Also, if I want to completly uninstall MSDE if I need to how would I do it?

Thanks,
BobWell, I had this message come up if I tried to run setup for the instance that was already on the system.

I used this setup to install msde on my machine.

setup instancename="netsdk" sapwd="your password for sa" securitymode=sql

Reason for using instance name netsdk was that it seems that SDK kit needs this instance to install pubs and nwind database.

After executing this i did not get any error messages but when I started service manager I could not see any servers listed. It took me solid two hours to come up with idea to look into error log and there it was.

2004-03-09 11:57:44.50 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2004-03-09 11:57:44.50 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-03-09 11:57:44.50 server All rights reserved.
2004-03-09 11:57:44.50 server Server Process ID is 3456.
2004-03-09 11:57:44.50 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\LOG\ERRORLOG'.
2004-03-09 11:57:44.52 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2004-03-09 11:57:44.63 server SQL Server configured for thread mode processing.
2004-03-09 11:57:44.63 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-03-09 11:57:44.63 spid2 Warning ******************
2004-03-09 11:57:44.63 spid2 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-03-09 11:57:44.63 spid2 Starting up database 'master'.
2004-03-09 11:57:44.98 spid5 Starting up database 'model'.
2004-03-09 11:57:44.98 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-03-09 11:57:45.03 spid2 Server name is 'PC0491-EPITKA\NETSDK'.
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 5
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 6
2004-03-09 11:57:45.03 spid2 Starting up database 'msdb'.
2004-03-09 11:57:45.17 server SQL server listening on Shared Memory.
2004-03-09 11:57:45.17 server SQL Server is ready for client connections
2004-03-09 11:57:45.38 spid5 Clearing tempdb database.
2004-03-09 11:57:46.12 spid5 Starting up database 'tempdb'.
2004-03-09 11:57:46.20 spid2 Recovery complete.
2004-03-09 11:57:46.20 spid2 SQL global counter collection task is created.
2004-03-09 11:57:46.22 spid2 Warning: override, autoexec procedures skipped.
2004-03-09 11:57:56.94 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:56.94 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.08 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:57.08 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.34 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

There is a line that says servername, I typed it in and I was able to start service. Log should be under c:\program files\microsoft sql server\mssql${your instance name}\log.

I am very new to windows world since I worked on Unix platform for past six years, so for you gurus out there this migth be something that does not need to be explained. Anyway I hope this helps.sql

Installing the AdventureWorks Database

I've downloaded and installed the Adventure works database

I follow the instructions give here

http://msdn2.microsoft.com/en-us/library/ms310325.aspx

but this command here:

exec sp_attach_db @.dbname=N'AdventureWorks', @.filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @.filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'

results in this error:

"unable to open physical file,................................................. the system can't find the specified file."

AdventureWorks_log.ldf + AdventureWorks_Data.mdf ...................don't exist at this location:

c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\

i'm thinking of reinstalling the whole adventure works DB.

any ideas please

Moving to the SQL Server Setup & Upgrade forum. This may not strictly be a setup problem, but this is probably the best place to start to make sure you have the sample database installed correctly. In any case, this is best suited for one of the SQL Server forums instead of .NET Data Access.

Thanks,
Sarah

Installing SQL Server Express

I have tried in vain to install the SQL Server Express on my PC. I have
follow the instructions for uninstalling old version and read the
instructions. I run the build uninstall wizard and it removes the old stuff
(including 2.0 framework) and I run the install and it requires the 2.0
framework to install. I am in a vicious cycle. In my add/remove programs
there are no 2005 programs listed period. Any help would be appreicated. I
am running 2.0.5.0215 of the framework and this is the first install of 2005
SQL server that I am aware of.
JohnSince SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
--
--Brian
(Please reply to the newsgroups only.)
"john wright" <riley_wright@.hotmail.com> wrote in message
news:eLbs9nhuFHA.908@.tk2msftngp13.phx.gbl...
>I have tried in vain to install the SQL Server Express on my PC. I have
>follow the instructions for uninstalling old version and read the
>instructions. I run the build uninstall wizard and it removes the old
>stuff (including 2.0 framework) and I run the install and it requires the
>2.0 framework to install. I am in a vicious cycle. In my add/remove
>programs there are no 2005 programs listed period. Any help would be
>appreicated. I am running 2.0.5.0215 of the framework and this is the
>first install of 2005 SQL server that I am aware of.
> John
>sql

Installing SQL Server Express

I have tried in vain to install the SQL Server Express on my PC. I have
follow the instructions for uninstalling old version and read the
instructions. I run the build uninstall wizard and it removes the old stuff
(including 2.0 framework) and I run the install and it requires the 2.0
framework to install. I am in a vicious cycle. In my add/remove programs
there are no 2005 programs listed period. Any help would be appreicated. I
am running 2.0.5.0215 of the framework and this is the first install of 2005
SQL server that I am aware of.
John
Since SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/new...r2005&slcid=us
--Brian
(Please reply to the newsgroups only.)
"john wright" <riley_wright@.hotmail.com> wrote in message
news:eLbs9nhuFHA.908@.tk2msftngp13.phx.gbl...
>I have tried in vain to install the SQL Server Express on my PC. I have
>follow the instructions for uninstalling old version and read the
>instructions. I run the build uninstall wizard and it removes the old
>stuff (including 2.0 framework) and I run the install and it requires the
>2.0 framework to install. I am in a vicious cycle. In my add/remove
>programs there are no 2005 programs listed period. Any help would be
>appreicated. I am running 2.0.5.0215 of the framework and this is the
>first install of 2005 SQL server that I am aware of.
> John
>

Installing SQL Server Express

I have tried in vain to install the SQL Server Express on my PC. I have
follow the instructions for uninstalling old version and read the
instructions. I run the build uninstall wizard and it removes the old stuff
(including 2.0 framework) and I run the install and it requires the 2.0
framework to install. I am in a vicious cycle. In my add/remove programs
there are no 2005 programs listed period. Any help would be appreicated. I
am running 2.0.5.0215 of the framework and this is the first install of 2005
SQL server that I am aware of.
JohnSince SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/ne...lcid=us

--Brian
(Please reply to the newsgroups only.)
"john wright" <riley_wright@.hotmail.com> wrote in message
news:eLbs9nhuFHA.908@.tk2msftngp13.phx.gbl...
>I have tried in vain to install the SQL Server Express on my PC. I have
>follow the instructions for uninstalling old version and read the
>instructions. I run the build uninstall wizard and it removes the old
>stuff (including 2.0 framework) and I run the install and it requires the
>2.0 framework to install. I am in a vicious cycle. In my add/remove
>programs there are no 2005 programs listed period. Any help would be
>appreicated. I am running 2.0.5.0215 of the framework and this is the
>first install of 2005 SQL server that I am aware of.
> John
>sql

Installing SQL Server 2005 Express edition

I'm trying to install the latest SQL Server Express downloaded from Microsoft. I've followed all instructions on the download page but get the message concerning Incompatible Components being found on my machine. To my knowledge I have never installed any previous components from any betas or other previous versions. Nor have I had a previous version of .Net Framework 2.0 on my machine. Just in case, I've checked Add/Remove Programs and run the removal tool as recommended on the Microsoft site. The tool reports that it can't find any components! If I knew what to look for I'd go through the Registry to manually uninstall any problem keys. The trouble is that I can't get through to Microsoft to find out what might be causing the trouble. It appears that I'm not alone. Can anyone help please.Search for a file with a name that ends with Core.log. It can be found under C:\Program Files\Microsoft SQL Server, if you installed SQL Server in C: drive.

Please find the latest version of the file. This file will list any incompatible component(s), that was found during installation.

I hope this helps.

-- JB|||Many thanks John. That was very helpful and I am grateful for your suggestion. On looking into the core.log file I've extracted the following piece of information:
"Product "{44568A1C-53F6-49A5-A163-CD9ADC0F76D5}" versioned 2.0.50727 is not compatible with current builds of SQL Server. Expected at least version: 2.0.50727.42 The Product Name is "Microsoft .NET Framework 2.0". Unfortunately, the most recent version that I can find from the Microsoft site is version 2.0.50727!!!!!!!!!!! Can anyone help me find the 2.0.50727.42 version?|||This is one area where things are confusing... I believe there were a few builds of the .NET Framework that were released that were versioned 2.0.50727.xx prior to the final release. The 2.0.50727.42 version is the FINAL RTM version of the 2.0 framework. If the very last number in the version is < 42, you do not have the final released version installed.

You can download the final release of the 2.0 framework from here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en

jeff.|||Thanks Jeff. You're right this is VERY confusing. I believe that the link you've given me is the one that I downloaded and tried to install. Unfortunately without success. Since experimenting a bit I've actually found a download that works. Unfortunately, I've had to pull down the full SDK version. This is a BIG download with lots and lots of stuff. I have now got a working version of SQL Server 2005 Express but with a massive overhead of other peripheral material. Since installing it all (I wasn't given any choice as to what to install) my notebook has become very sluggish! You just can't win can you! It's all or nothing with this lot!!!!
Thanks to everyone for their help.

Installing SQL Server 2005 Express

Downloaded the program and followed the instructions (as vague as they are) the only thing I see to execute is the configuration tools. I am certain I have missed something. Can anyone assist?

Many thanks!!

SQL Server Express, like most independent database systems these days does not run as a visual application the way Internet Explorer or Notepad do, instead it runs automatically behind the scenes as a system service.

Have you tried to connect to the already running instance on your PC with a version of Visual Studio (including Express)? Have you tried to connect to it with one of the included management tools?

Also, be sure to grab a copy of SQL Server Management Studio Express from the SQL Express download page to give you even more management options.

|||thank you