Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Installing SQL Server 2005 Express edition from Command line Expand / Collapse
Author
Message
Posted Sunday, October 10, 2010 12:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 19, 2014 1:04 PM
Points: 45, Visits: 129
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
Post #1001829
Posted Monday, October 11, 2010 2:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 28, 2014 12:59 AM
Points: 1, Visits: 71
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
Post #1001979
Posted Tuesday, October 12, 2010 4:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 19, 2014 1:04 PM
Points: 45, Visits: 129
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
Post #1002662
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse