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

installtion of analytics server

i downloaded proclarity desktop profesional from microsoft website and installed ..

but i am unable to connect to analytics server..does it need separate software or is it my databse..what is pas in that and which user id /password i must give..Is it databse serevr address or any other..

i tried by all means but failed..can u give me other versions of downloads..or help in installing desktop profesional...

its urgent...plzz help me out...

Hi,

You don't need anymore software, you should be able to connect to the ProClarity Server with out any problems. That is with the assumption you can access it via a URL. Normally something like http://SERVERNAME/PAS.

You did install the analytic server?

Hope that helps

Matt

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 Desktop Engine & Enterprise Manager

I downloaded and successfully installed SQL Server 2000 Desktop edition via
"MSDE2000A.exe".
Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
attempted to install that.
But, I got an error message: "SQL Server 2000 is not installed on this
machine. Setup will now exit".
So, obviously the error message is wrong, as I did install SQL Server 2000.
So, don't know what to do.
One thing that may be affecting this is that when doing the S.S. 2000
install, I had to do it via a DOS window in order to set a flag for what's
called an "SA" password. And I was thinking that maybe that's affecting the
subsequent attempt to install Enterprise Manager?
I'm running WinXP Professional with SP2 on my PC.
A thought...since I really don't have SQL Server 2000 installed, but instead
the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
Thanks.Hi,
Did you install MSDE SP3?
From the file name "sql2ksp3.exe", I think it's not the appropariate
release. The SP3 name for MSDE is sql2kdesksp3.exe.
You can download it from:
http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en
If you have any other questions or concerns, please feel free to let me
know.
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, a
nd confers no rights.
======================================================|||andyboy wrote on Thu, 3 Aug 2006 13:29:02 -0700:
> I downloaded and successfully installed SQL Server 2000 Desktop edition
> via "MSDE2000A.exe".
> Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
> attempted to install that.
That's Service Pack 3 for SQL Server 2000. Enterprise Manager comes on the
SQL Server CD.
> But, I got an error message: "SQL Server 2000 is not installed on this
> machine. Setup will now exit".
> So, obviously the error message is wrong, as I did install SQL Server
> 2000. So, don't know what to do.
You installed SQL Server 2000 Desktop (MSDE). That is not the same as the
"proper" SQL Server (Standard and Enterprise).
> One thing that may be affecting this is that when doing the S.S. 2000
> install, I had to do it via a DOS window in order to set a flag for what's
> called an "SA" password. And I was thinking that maybe that's affecting
> the subsequent attempt to install Enterprise Manager?
> I'm running WinXP Professional with SP2 on my PC.
> A thought...since I really don't have SQL Server 2000 installed, but
> instead the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
> Thanks.
If you want Enterprise Manager, you'll need to buy SQL Server. The
Desktop/MSDE version doesn't come with a GUI management tool. I'm not sure
if the SQL Server Express 2005 Management Studio GUI will work with Desktop
2000, if it does then you could use that.
Dan|||ok, thanks and 2 things:
1) the link you posted to get 'sql2kdesksp3.exe' isn't valid.
2) can I install Enterprise Manager with the desktop sql server?
"Charles Wang[MSFT]" wrote:
> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ======================================================>|||and I did successfully install sql server version 8.00.760.
so, is that the desktop version of sql server, or is it the 'full' version?
and if it's the full version, I'd prefer to leave it installed, I guess, and
then install Enterprise Manager for it.
so, how do I do that?
thanks.
"Charles Wang[MSFT]" wrote:
> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ======================================================>|||Hi,
Thanks for your post.
I tried the link again and can get access the web. The sql2kdesksp3.exe
package for downloading locates under the page below.
I recommend that you check wheter or not the url is devided into two lines.
If so, you need to combine the two lines into one line url.
You can install SQL Enterprise Mnager with MSDE2000, however, you need to
install it with named instance.
It's only allowed only one default instance installed on one server.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi ,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Installing SQL Server Desktop Engine & Enterprise Manager

I downloaded and successfully installed SQL Server 2000 Desktop edition via
"MSDE2000A.exe".
Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
attempted to install that.
But, I got an error message: "SQL Server 2000 is not installed on this
machine. Setup will now exit".
So, obviously the error message is wrong, as I did install SQL Server 2000.
So, don't know what to do.
One thing that may be affecting this is that when doing the S.S. 2000
install, I had to do it via a DOS window in order to set a flag for what's
called an "SA" password. And I was thinking that maybe that's affecting the
subsequent attempt to install Enterprise Manager?
I'm running WinXP Professional with SP2 on my PC.
A thought...since I really don't have SQL Server 2000 installed, but instead
the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
Thanks.Hi,
Did you install MSDE SP3?
From the file name "sql2ksp3.exe", I think it's not the appropariate
release. The SP3 name for MSDE is sql2kdesksp3.exe.
You can download it from:
http://www.microsoft.com/downloads/...D52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en
If you have any other questions or concerns, please feel free to let me
know.
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, a
nd confers no rights.
========================================
==============|||andyboy wrote on Thu, 3 Aug 2006 13:29:02 -0700:

> I downloaded and successfully installed SQL Server 2000 Desktop edition
> via "MSDE2000A.exe".
> Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
> attempted to install that.
That's Service Pack 3 for SQL Server 2000. Enterprise Manager comes on the
SQL Server CD.

> But, I got an error message: "SQL Server 2000 is not installed on this
> machine. Setup will now exit".
> So, obviously the error message is wrong, as I did install SQL Server
> 2000. So, don't know what to do.
You installed SQL Server 2000 Desktop (MSDE). That is not the same as the
"proper" SQL Server (Standard and Enterprise).

> One thing that may be affecting this is that when doing the S.S. 2000
> install, I had to do it via a DOS window in order to set a flag for what's
> called an "SA" password. And I was thinking that maybe that's affecting
> the subsequent attempt to install Enterprise Manager?
> I'm running WinXP Professional with SP2 on my PC.
> A thought...since I really don't have SQL Server 2000 installed, but
> instead the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
> Thanks.
If you want Enterprise Manager, you'll need to buy SQL Server. The
Desktop/MSDE version doesn't come with a GUI management tool. I'm not sure
if the SQL Server Express 2005 Management Studio GUI will work with Desktop
2000, if it does then you could use that.
Dan|||ok, thanks and 2 things:
1) the link you posted to get 'sql2kdesksp3.exe' isn't valid.
2) can I install Enterprise Manager with the desktop sql server?
"Charles Wang[MSFT]" wrote:

> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> [url]http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-[/ur
l]
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ========================================
==============
>|||and I did successfully install sql server version 8.00.760.
so, is that the desktop version of sql server, or is it the 'full' version?
and if it's the full version, I'd prefer to leave it installed, I guess, and
then install Enterprise Manager for it.
so, how do I do that?
thanks.
"Charles Wang[MSFT]" wrote:

> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> [url]http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-[/ur
l]
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ========================================
==============
>|||Hi,
Thanks for your post.
I tried the link again and can get access the web. The sql2kdesksp3.exe
package for downloading locates under the page below.
I recommend that you check wheter or not the url is devided into two lines.
If so, you need to combine the two lines into one line url.
You can install SQL Enterprise Mnager with MSDE2000, however, you need to
install it with named instance.
It's only allowed only one default instance installed on one server.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi ,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Installing SQL Server 2005 on Windows XP Pro x64

On MSDN, I have downloaded "SQL Server 2005 CTP - September 2005 - Enterprise Edition - 64-bit Extended - Servers (English)" that I am trying to install on WinXP Pro x64 (EMT64 machine).
Unfortunately, I am not able to install SQLSRV2005, indeed during the setup the option such as "SQL Server Database Services" are grayed (i.e. not clickable, idem for Analysis Services). The only thing that I can select is "Workstation components".
Is it possible to use SQL Server 2005 on a WinXP x64 OS ?
Thanks in advance,
Joannes
Enterprise Edition isn't supported on WinXP. Please see the following link for system requirements:

http://www.microsoft.com/sql/evaluation/sysreqs/2005/default.mspx

Installing SQL Server 2005 Express edition

I have Visual Web Developer 2005 Express edition and I wanted to install SQL Server 2005 Express edition.

From this page, I have downloaded and installed 'Microsoft SQL Server 2005 Express Edition'and'Microsoft SQL Server 2005 Express Edition with Advanced Services

http://msdn.microsoft.com/vstudio/express/sql/download/

After the installation, how should I access the SQL Server 2005 Express edition?

Because the only thing listed in 'Start > All Programs > SQL Server 2005' is 'Configuration Tools'

I was hoping that when I install SQL Server 2005 express edition, I would get all the menu that I get by installing SQL Server 2000.

So after installing SQL Server 2005 Express edition, what should I be expection? Thanks

SQL Server 2005 Express will work inside VS2005, you can go to database and create a new database now, give it a try!|||

albertpascual:

SQL Server 2005 Express will work inside VS2005, you can go to database and create a new database now, give it a try!

I only have Visual Web Developer express edition. DOes SQL Server 2005 express edition work with Visual Web Developer express edition?

|||I do not know, sorry!|||I do not know, sorry! If you have the database menu and you can connect to a database, will work.

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

Installing Sql Server

Hi,

I downloaded the Sql server 2005 express advanced and installed it in my computer. Everything went well except for a warning message that said "minimum hardware requirements not met". I have dual core pentium 4 computer with 250 G hard disk and 1gb ram.

Anyways, after installing I cannot find the real application anywhere. When I goto start, programs, sql server it only shows sql server configuration tools. I have never used sql server before and how do I start the app?

Any help will be much appreciated. Please note I already installed net framework 2 and also visual studio 2005 professional.

You need to go and download Express Advanced Services which includes SQL Server Management Studio Express, thats the main GUI for SSE.|||

Hi Euan,

Thx for yr reply. Actually I downloaded & installed the sql server with advanced options but I did not see any gui. So after posting my question on this forum I downloaded the SQL Server Management Studio Express from microsoft and installed it and now I have got what I was looking for.

What I don't understand is how come if advanced options had the gui builtin it did not work in my computer?

Fareez...

|||

Hi Fareez,

Management Studio Express is included in Express Advanced, but you have to choose to install it from the Feature Tree in the Setup UI. It sounds like you just did a default install without changing the feature set being installed.

For other who experience this, you can go back into the Express Advanced setup from Add/Remove Programs and choose to install Management Studio Express, you don't have to download it separately. Just open Add/Remove Programs, select SQL Server 2005 and click Change. Follow the prompts to modify your installation.

Regards,

Mike Wachal
SQL Express team

Installing SQL Express from command prompt

I'm attempted to run an installation of SQL Express 2005 from the
command prompt. I've downloaded the redistributable SQLEXPR32.EXE and
now want to get my hands on setup.exe, template.ini, etc.. that I will
run from the command prompt. I can see them being created in a
temporary folder when I launch SQLEXPR32.EXE, but they cannot be
accessed or copied because they are in use, and when I quit the GUI
installer all the files disappear.
Anyone out there had any success a doing this with Express?See the following article on how to install SQL Server 2005 from the command
prompt:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Towards the end of the article you will see all parameters that can be
configured to create an installation ini script.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||On 28 Feb, 16:31, "Plamen Ratchev" <Pla...@.SQLStudio.com> wrote:
> See the following article on how to install SQL Server 2005 from the comma
nd
> prompt:http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> Towards the end of the article you will see all parameters that can be
> configured to create an installation ini script.
> Regards,
> Plamen Ratchevhttp://www.SQLStudio.com
read it already. Have you installed Express from the command prompt
successfully? Like I said in original post I can't get hold of all
the files that are generated by running the redistributable. I could
get hold of the setup.exe and build my own ini script but won't I be
missing files?|||Yes, I have installed successfully SQL Server Express from the command
prompt. You do not need to access directly the extracted files. The
compressed installer file (SQLEXPR32.EXE) supports the same command line
parameters as setup.exe. Actually it will just pass the parameters to
setup.exe once it is extracted onto the hard drive.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||Si,
It is necessary to include the full path name of the ini file in quotes:
SQLEXPR32.exe /qn /settings "C:\MyDir\command.ini"
Also if the install had failed earlier it is necessary to go to Add/Remove
programs and clean outany Microsoft SQL progams before re-running this.
One culprit is "Microsoft SQL Server Native Client" that remains after a
failed install.
Scott
"Si" wrote:

> I'm attempted to run an installation of SQL Express 2005 from the
> command prompt. I've downloaded the redistributable SQLEXPR32.EXE and
> now want to get my hands on setup.exe, template.ini, etc.. that I will
> run from the command prompt. I can see them being created in a
> temporary folder when I launch SQLEXPR32.EXE, but they cannot be
> accessed or copied because they are in use, and when I quit the GUI
> installer all the files disappear.
> Anyone out there had any success a doing this with Express?
>

Installing SQL Express from command prompt

I'm attempted to run an installation of SQL Express 2005 from the
command prompt. I've downloaded the redistributable SQLEXPR32.EXE and
now want to get my hands on setup.exe, template.ini, etc.. that I will
run from the command prompt. I can see them being created in a
temporary folder when I launch SQLEXPR32.EXE, but they cannot be
accessed or copied because they are in use, and when I quit the GUI
installer all the files disappear.
Anyone out there had any success a doing this with Express?
See the following article on how to install SQL Server 2005 from the command
prompt:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Towards the end of the article you will see all parameters that can be
configured to create an installation ini script.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
|||On 28 Feb, 16:31, "Plamen Ratchev" <Pla...@.SQLStudio.com> wrote:
> See the following article on how to install SQL Server 2005 from the command
> prompt:http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> Towards the end of the article you will see all parameters that can be
> configured to create an installation ini script.
> Regards,
> Plamen Ratchevhttp://www.SQLStudio.com
read it already. Have you installed Express from the command prompt
successfully? Like I said in original post I can't get hold of all
the files that are generated by running the redistributable. I could
get hold of the setup.exe and build my own ini script but won't I be
missing files?
|||Yes, I have installed successfully SQL Server Express from the command
prompt. You do not need to access directly the extracted files. The
compressed installer file (SQLEXPR32.EXE) supports the same command line
parameters as setup.exe. Actually it will just pass the parameters to
setup.exe once it is extracted onto the hard drive.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
|||Si,
It is necessary to include the full path name of the ini file in quotes:
SQLEXPR32.exe /qn /settings "C:\MyDir\command.ini"
Also if the install had failed earlier it is necessary to go to Add/Remove
programs and clean outany Microsoft SQL progams before re-running this.
One culprit is "Microsoft SQL Server Native Client" that remains after a
failed install.
Scott
"Si" wrote:

> I'm attempted to run an installation of SQL Express 2005 from the
> command prompt. I've downloaded the redistributable SQLEXPR32.EXE and
> now want to get my hands on setup.exe, template.ini, etc.. that I will
> run from the command prompt. I can see them being created in a
> temporary folder when I launch SQLEXPR32.EXE, but they cannot be
> accessed or copied because they are in use, and when I quit the GUI
> installer all the files disappear.
> Anyone out there had any success a doing this with Express?
>

Installing SQL Express from command prompt

I'm attempted to run an installation of SQL Express 2005 from the
command prompt. I've downloaded the redistributable SQLEXPR32.EXE and
now want to get my hands on setup.exe, template.ini, etc.. that I will
run from the command prompt. I can see them being created in a
temporary folder when I launch SQLEXPR32.EXE, but they cannot be
accessed or copied because they are in use, and when I quit the GUI
installer all the files disappear.
Anyone out there had any success a doing this with Express?See the following article on how to install SQL Server 2005 from the command
prompt:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Towards the end of the article you will see all parameters that can be
configured to create an installation ini script.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||On 28 Feb, 16:31, "Plamen Ratchev" <Pla...@.SQLStudio.com> wrote:
> See the following article on how to install SQL Server 2005 from the command
> prompt:http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> Towards the end of the article you will see all parameters that can be
> configured to create an installation ini script.
> Regards,
> Plamen Ratchevhttp://www.SQLStudio.com
read it already. Have you installed Express from the command prompt
successfully? Like I said in original post I can't get hold of all
the files that are generated by running the redistributable. I could
get hold of the setup.exe and build my own ini script but won't I be
missing files?|||Yes, I have installed successfully SQL Server Express from the command
prompt. You do not need to access directly the extracted files. The
compressed installer file (SQLEXPR32.EXE) supports the same command line
parameters as setup.exe. Actually it will just pass the parameters to
setup.exe once it is extracted onto the hard drive.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||Si,
It is necessary to include the full path name of the ini file in quotes:
SQLEXPR32.exe /qn /settings "C:\MyDir\command.ini"
Also if the install had failed earlier it is necessary to go to Add/Remove
programs and clean outany Microsoft SQL progams before re-running this.
One culprit is "Microsoft SQL Server Native Client" that remains after a
failed install.
Scott
"Si" wrote:
> I'm attempted to run an installation of SQL Express 2005 from the
> command prompt. I've downloaded the redistributable SQLEXPR32.EXE and
> now want to get my hands on setup.exe, template.ini, etc.. that I will
> run from the command prompt. I can see them being created in a
> temporary folder when I launch SQLEXPR32.EXE, but they cannot be
> accessed or copied because they are in use, and when I quit the GUI
> installer all the files disappear.
> Anyone out there had any success a doing this with Express?
>

installing sql 2005 management studio express on 2nd hard drive

Hi,

I've downloaded the sql server 2005 management studio express executable to my second hard drive, as there is no room on my main drive

However, when I try to install, the program shows me both drives, and shows that there is not enough room on my main drive, but it does not allow me to change the installation to my second drive.

I have previously installed the main sql express product to my second drive with visual studio. There's loads of room.

Can anyone give me a clue as to why this might be happening.

Thanks

John

I'm going to move this to the Setup forum.

- Mike