This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Sql Server
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 23, 2008
06:43 PM
Sql Server
Hi All,
I have an installer which needs MSSQL server as prerequiste. I selected it in Redistributables section and it installs fine. But the the sql server instance doesnt restart on rebooting the machine.
Commandline parameters are specified as below for normal and silent mode under Appliaction to Run tab of Edit Prerequsites.
/qn INSTANCENAME=APEOS SAPWD=pawd SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI ADDLOCAL=All SECURITYMODE=SQL SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0
/qn INSTANCENAME=APEOS SAPWD=pawd SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI ADDLOCAL=All SECURITYMODE=SQL SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0
Please suggest if I need to modify the commandline paarameters.
Regards,
Sandeep
I have an installer which needs MSSQL server as prerequiste. I selected it in Redistributables section and it installs fine. But the the sql server instance doesnt restart on rebooting the machine.
Commandline parameters are specified as below for normal and silent mode under Appliaction to Run tab of Edit Prerequsites.
/qn INSTANCENAME=APEOS SAPWD=pawd SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI ADDLOCAL=All SECURITYMODE=SQL SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0
/qn INSTANCENAME=APEOS SAPWD=pawd SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI ADDLOCAL=All SECURITYMODE=SQL SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0
Please suggest if I need to modify the commandline paarameters.
Regards,
Sandeep
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 24, 2008
02:03 AM
First, check if the service is set to automatic in administrative tools/services.
Have you tried without the AUTOSTART parameter? According to this page it should be default 1 anyway so there should be no need to specify that parameter. I also install SQL Server Express as a prereq and I don't specify the SQLAUTOSTART. I have never had any problems with it not autostarting.
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx#autostart
You might also want to check the SQL Server install logs, see http://msdn.microsoft.com/en-us/library/ms143702(SQL.90).aspx
and maybe the event viewer to see whether there's a hint there why the service is not started.
Have you tried without the AUTOSTART parameter? According to this page it should be default 1 anyway so there should be no need to specify that parameter. I also install SQL Server Express as a prereq and I don't specify the SQLAUTOSTART. I have never had any problems with it not autostarting.
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx#autostart
You might also want to check the SQL Server install logs, see http://msdn.microsoft.com/en-us/library/ms143702(SQL.90).aspx
and maybe the event viewer to see whether there's a hint there why the service is not started.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 02, 2009
03:55 PM
Sandeep, if you are installing SQL Server 2005 the password you listed in your command line is not considered a "strong" password and if this is the actual password that you used, it is probably the reason SQL Server is not starting. The password for the built-in sa account must meet Microsofts' requirements for a "strong" password - otherwise SQL Server 2005 will not install correctly.
Tim
Tim
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 07, 2009
01:04 AM
Tim,
I think that if the strong password would be the issue, SQL Server would not install at all. Now it appears that it does install but the services does not start.
I think that if the strong password would be the issue, SQL Server would not install at all. Now it appears that it does install but the services does not start.