I believe
SQLExpre32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS
will do the trick.
I am having a problem installing SQL Server Express 2005 from the command line in that it gets part way through and then stops - no message - just terminates. After much rooting around in log files and running a normal install I'm pretty sure that it is stopping because of a warning regarding "Minimum Hardware Requirements".
The laptop I'm trying to install it on is a Samsung X05, Centrino 1.4, 1gb RAM and 60gb free disk space. I've tried it on another laptop (Sony with a higher spec.) and get exactly the same problem.
As far as I can see the hardware spec is well above the recommended minumum so I'm at a loss as to what to try next to overcome the problem. If anyone has any suggestions then I'd be very grateful.
Moving to Setup forum.
Mike
|||The warning messages are just that, warnings, and shouldn't lead to any failures. So my guess is that it might be something with the way your command line is structured. For starters, can you post your command line install (remove passwords if they are used of course)? Can you also search your install logs for the text string "value 3"? This typically follows a more informative error message if one exists.
Thanks,
Sam Lester (MSFT)
Thanks for responding Sam.
If I run sqlexpr.exe without any command line arguments I get a warning but can continue. However if I use a command line it fails to install.
The command line i am using is as follows:
sqlexpr.exe /qb INSTANCENAME=myinstance DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SAPWD=mypassword
Unfortunately none of the log files contain "value 3". However:
1. Summary.txt contains the following message:
"The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Setup succeeded with the installation, inspect the log file completely for status on all the components. "
2. Core(Local).Log contains:
"Machine = MYMACHINE, Article = Processor, Result = 0 (0x0)
Machine = MYMACHINE, Article = PhysicalMemory, Result = 70010 (0x1117a)
Machine = MYMACHINE, Article = DiskFreeSpace, Result = 0 (0x0)"
and
"Article: Minimum Hardware Requirement, Result: Warning
Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements."
I'm assuming that it means that it doesn't think that the machine has sufficient memory but given the spec of it (see my previous message) then surely it should.
If you (or anyone else) has any further thoughts then I'd be really grateful because I'm stumped on this one. My only alternative is to let users loose on the full SQL install interface and there are too many for me to want to do that!!
Thanks
Brian
|||Hi,
refer manually installtion steps
http://msdn.microsoft.com/vstudio/express/support/install/
Hemantgiri S. Goswami
|||Hi Hemantgiri
Thanks for the link but I really don't want a few hundred "Administrative Assistants" in schools installing SQL Express manually. Using the command line to automate it will be fine except if they get the same warning i am getting because it then fails to install correctly rather than giving an option to continue.
Brian
|||
Hey Brian, I think the issue with the command line is that you haven't supplied anything for the ADDLOCAL parameter. By adding "ADDLOCAL=ALL" to the end of your command line, you should get what you're looking for. If you only want to install a subset of the product, you can take a look at the template.ini file for some examples or reply back with specific questions.
Thanks,
Sam Lester (MSFT)
Spot-on Sam.
I notice that template.ini says: "If ADDLOCAL is not specified, setup will fail." I feel such a fool!!
Thanks very much for your help.
Brian
I am having a problem installing SQL Server Express 2005 from the command line in that it gets part way through and then stops - no message - just terminates. After much rooting around in log files and running a normal install I'm pretty sure that it is stopping because of a warning regarding "Minimum Hardware Requirements".
The laptop I'm trying to install it on is a Samsung X05, Centrino 1.4, 1gb RAM and 60gb free disk space. I've tried it on another laptop (Sony with a higher spec.) and get exactly the same problem.
As far as I can see the hardware spec is well above the recommended minumum so I'm at a loss as to what to try next to overcome the problem. If anyone has any suggestions then I'd be very grateful.
Moving to Setup forum.
Mike
|||The warning messages are just that, warnings, and shouldn't lead to any failures. So my guess is that it might be something with the way your command line is structured. For starters, can you post your command line install (remove passwords if they are used of course)? Can you also search your install logs for the text string "value 3"? This typically follows a more informative error message if one exists.
Thanks,
Sam Lester (MSFT)
Thanks for responding Sam.
If I run sqlexpr.exe without any command line arguments I get a warning but can continue. However if I use a command line it fails to install.
The command line i am using is as follows:
sqlexpr.exe /qb INSTANCENAME=myinstance DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SAPWD=mypassword
Unfortunately none of the log files contain "value 3". However:
1. Summary.txt contains the following message:
"The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Setup succeeded with the installation, inspect the log file completely for status on all the components. "
2. Core(Local).Log contains:
"Machine = MYMACHINE, Article = Processor, Result = 0 (0x0)
Machine = MYMACHINE, Article = PhysicalMemory, Result = 70010 (0x1117a)
Machine = MYMACHINE, Article = DiskFreeSpace, Result = 0 (0x0)"
and
"Article: Minimum Hardware Requirement, Result: Warning
Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements."
I'm assuming that it means that it doesn't think that the machine has sufficient memory but given the spec of it (see my previous message) then surely it should.
If you (or anyone else) has any further thoughts then I'd be really grateful because I'm stumped on this one. My only alternative is to let users loose on the full SQL install interface and there are too many for me to want to do that!!
Thanks
Brian
|||Hi,
refer manually installtion steps
http://msdn.microsoft.com/vstudio/express/support/install/
Hemantgiri S. Goswami
|||Hi Hemantgiri
Thanks for the link but I really don't want a few hundred "Administrative Assistants" in schools installing SQL Express manually. Using the command line to automate it will be fine except if they get the same warning i am getting because it then fails to install correctly rather than giving an option to continue.
Brian
|||
Hey Brian, I think the issue with the command line is that you haven't supplied anything for the ADDLOCAL parameter. By adding "ADDLOCAL=ALL" to the end of your command line, you should get what you're looking for. If you only want to install a subset of the product, you can take a look at the template.ini file for some examples or reply back with specific questions.
Thanks,
Sam Lester (MSFT)
Spot-on Sam.
I notice that template.ini says: "If ADDLOCAL is not specified, setup will fail." I feel such a fool!!
Thanks very much for your help.
Brian
I'm installing SQL express from command line, and using something like that:
/qb INSTANCENAME="SQLEXPRESS" ADDLOCAL="All" SECURITYMODE="SQL" AGTACCOUNT="konrad" AGTPASSWORD="*******" SQLBROWSERACCOUNT="konrad" SQLBROWSERPASSWORD="*******" SQLACCOUNT="konrad" SQLPASSWORD="*******" SAPWD="********"
but after installation process security mode is still set to windows authorization
I realy don't know what is wrong
Could it be that the SQL Server password is not complex enough and you enabled a security complexity policy ? I thought that the install procedure should cancel then, but it seems that the SECURITYMODE is ignored for some reason. Did you try to put the settings in a template file and see if it will be taken from that ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||hmmm it's weird... when I type simple password installation goes to end without errors, but when passwords are more complicated I get an error:
SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account.
atm it works only with one pair of passwords which I specify in first installation on this system after reboot but sql auth. still doesn't work :/
could someone give me working command to execute this installer with SQL Authentication that may be very helpfull
regards,
Konrad B.
|||
Any special characters in there ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
Hi,
I need to install a customed SQL server express instance on the client's computer by using the Command prompt installation. I've already defined the security settings and everything i need but i was wondering if is possible to attach a mdf database during the installation. Perhaps there is a paramenter i can include in the in the ini file.
Thank you
No, you can not attach a database as part of the installation command prompt. You will need to do that from some other process, possibly in the wrapper that you're using to run the command prompt in the first place. If you're not using a language that supports connecting to SQL, you could just create a script and call that script using the SQLCmd utility, which runs from the command prompt as well.
Search BOL for information about using SQLCmd.
Mike
|||Hi,if you embedded your installation as part of a bootstrapper you could call (as Mike said) the SQLCmd.exe utiltiy as a custom install step and use the sp_attachdb or CREATE DATABSE for attaching within the command like the following example: SQLCMD.exe -E -Q"sp_attach @.dbname ='SomeDbname', @.FileName1 ='C:\SomeFOlder\SomeFile.mdf', @.FileName2 ='C:\SomeFOlder\SomeFile.mdf'
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
Thank you for your answers.
Just one last thing: I creating two separate procedures to install and attach the database into one wrapper. Because launching a SqlCmd starts a separate sql installation. Is there a way to know when the installation is completed and how it went so the attachment process can be launched automatically?
|||When I do the script you mention it works for some computers and for others it won't.
I found that changing the SQL Server Configuration manager(SCM) to local for those that it doesn't work is enough to make the script run. When it was setup as NTAuthority instead of local it gave a Error 5 (acces denied).
Is any command to change the Logon Mode for the SCM that I can add as part of my script?
What am I doing wrong? How to default it to be a local logon instead of NTAuthority?
Hi,
I need to install a customed SQL server express instance on the client's computer by using the Command prompt installation. I've already defined the security settings and everything i need but i was wondering if is possible to attach a mdf database during the installation. Perhaps there is a paramenter i can include in the in the ini file.
Thank you
No, you can not attach a database as part of the installation command prompt. You will need to do that from some other process, possibly in the wrapper that you're using to run the command prompt in the first place. If you're not using a language that supports connecting to SQL, you could just create a script and call that script using the SQLCmd utility, which runs from the command prompt as well.
Search BOL for information about using SQLCmd.
Mike
|||Hi,if you embedded your installation as part of a bootstrapper you could call (as Mike said) the SQLCmd.exe utiltiy as a custom install step and use the sp_attachdb or CREATE DATABSE for attaching within the command like the following example: SQLCMD.exe -E -Q"sp_attach @.dbname ='SomeDbname', @.FileName1 ='C:\SomeFOlder\SomeFile.mdf', @.FileName2 ='C:\SomeFOlder\SomeFile.mdf'
Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Thank you for your answers.
Just one last thing: I creating two separate procedures to install and attach the database into one wrapper. Because launching a SqlCmd starts a separate sql installation. Is there a way to know when the installation is completed and how it went so the attachment process can be launched automatically?
|||When I do the script you mention it works for some computers and for others it won't.
I found that changing the SQL Server Configuration manager(SCM) to local for those that it doesn't work is enough to make the script run. When it was setup as NTAuthority instead of local it gave a Error 5 (acces denied).
Is any command to change the Logon Mode for the SCM that I can add as part of my script?
What am I doing wrong? How to default it to be a local logon instead of NTAuthority?
