SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Installing SQL Server 2005 Express edition from Command line


Installing SQL Server 2005 Express edition from Command line

Author
Message
priest Ivan Delic
priest Ivan Delic
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 130
God bless you all!

I wrote to this forum few months ago and since then everything worked fine. Now I have certain installation issue.

I downloaded both SP2 and SP3 for SQL Server 2005 Express edition. Both of them installed correctly with Cyrillic collation, since I am Serbian Orthodox Priest. Recently I installed some application to better administer my church parish. That app was written in VS 2005, and for reporting all needs of it, it needs Slovenian collation of SQL Server. I then used about 4-5 ways to install SQL Server to another instance name. All of them was unsuccessful. Reason is in message (to make short):

In order to install new instance of SQL Server, you need to start installation from Command line.

I never did that. Any helps and suggestion, please.

Sincerely yours

Rev. Fr. Ivan Delic
Gianfranco Giannotti
Gianfranco Giannotti
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 73
SQLEXPR32.EXE /qb addlocal=all InstanceName=NEWSQLEXPRESS DisableNetworkProtocols=0 SECURITYMODE=SQL SAPWD=YOURPASSWORD SQLAUTOSTART=1 SQLBROWSERAUTOSTART=1 ENABLERANU=0


With this command line you install the following:

1. Basic User Interface for the Installation Process (/qb)
2. A new instance of SQL Server Express with the name MachineName\NEWSQLEXPRESS (InstanceName=NEWSQLEXPRESS)
3. Mixed Authentication (SECURITYMODE=SQL SAPWD=YOURPASSWORD)
4. Enabled Network Protocols - Connectivity via TCP (DisableNetworkProtocols=0)
5. Automatic start for SQL Server Service and SQL Browser (SQLAUTOSTART=1 SQLBROWSERAUTOSTART=1)
6. Disabled UserInstances (ENABLERANU=0)

For more info check this link:
http://msdn.microsoft.com/en-us/library/ms144259%28SQL.90%29.aspx#installationscripts

I hope this helps
priest Ivan Delic
priest Ivan Delic
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 130
Thanks for your quick answer

I did what you asked with little change of line (I called mine SQL Server setup file SQL_Server_SP3.

Result is not good at all, and here it is


Microsoft SQL Server 2005 9.00.4035.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Mon Oct 11 14:29:28 2010

IVCE : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
IVCE : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
Machine : IVCE
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\SQLSetup0010_IVCE_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : IVCE
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\SQLSetup0010_IVCE_SQLSupport_2.log
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.


Time : Mon Oct 11 14:41:16 2010


List of log files:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_Core(Patched).log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_SQLSupport_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_SQLNCLI_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_SqlWriter_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_MSXML6_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_SQLSupport_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_Datastore.xml
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_Support.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_Core.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_IVCE_SCC.log


This line
The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.

is not such a problem, earlier it allows me to install SQL Server.


Sincerely yours
Rev. Fr. Ivan Delic
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search