October 10, 2010 at 12:00 pm
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
October 11, 2010 at 2:27 am
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
October 12, 2010 at 4:32 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply