THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

SQL 2008 ConfigurationFile.ini file - not just for unattended installs

Scripting installations of SQL Server 2008 is much easier than it is with SQL Server 2005 because of the ConfigurationFile.ini. Even if you don't script your installations, you should review the contents of this file to verify that the installation transpired as intended. Although it is possible to script a SQL Server 2005 installation, you can't capture an interactive installation and replay it. When SQL Server 2008 is installed, a ConfigurationFile.ini file is created in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\yyyymmdd_hhmmss. To use ConfigurationFile.ini with the installation wizard, select Advanced and Install based on configuration file. If you need to make changes to the file before performing another installation, it is a best practice to make a copy and work with the copy. From an auditing and compliance perspective, each installation's ConfigurationFile.ini file should be preserved in its original state as verification of the initial state of the SQL Server installation.

Published Friday, August 15, 2008 9:30 AM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

duncanph said:

Is there a way to use an Active Directory group policy to push SQL 2008 excpress?

July 23, 2009 11:17 AM
 

Tejas said:

Hi, I'm having issues with this. I'm trying to do an unattended install of SQL 2008 enterprise version...

If I install everything but the SQL engine, SSRS, SSIS,SSAS, installation works. Below works

FEATURES=BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS

Below doesn't work:

FEATURES=SQLENGINE,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS

I can send you the details.txt file which gets created when I run this but I'm pastinng the excerpt here if it helps. I don't know how to get rid of the error. Below is the excerpt.

===============================================================

===============================================================

2010-01-13 15:02:55 Slp: Running Action: FinalCalculateSettings

2010-01-13 15:02:55 Slp: The configuration object document /Datastore/ProductSettings/SqlInstanceId/Private was found in the datastore.

2010-01-13 15:02:55 Slp: Using instance id 'MSSQL10.MSSQLSERVER' for product SQL Server Database Services

2010-01-13 15:02:55 Slp: Hosting object: Microsoft.SqlServer.Configuration.SetupExtension.AsInstanceIdPrivateConfigObject skipped since related features not chosen

2010-01-13 15:02:55 Slp: Hosting object: Microsoft.SqlServer.Configuration.SetupExtension.RsInstanceIdPrivateConfigObject skipped since related features not chosen

2010-01-13 15:02:55 Slp: The configuration object document /Datastore/ProductSettings/Sku/Public was found in the datastore.

2010-01-13 15:02:55 Slp: -- SkuPublicConfigObject : Calling SkuPublicConfigObject.Calculate.

2010-01-13 15:02:55 Slp: -- SkuPublicConfigObject : No instance found for instance name 'MSSQLSERVER'.

2010-01-13 15:02:55 Slp: The configuration object document /Datastore/InputSettings/FeatureSpecific/SlpInputSettings was found in the datastore.

2010-01-13 15:02:55 Slp: Restoring InstallSharedDir for {0CAFB09C-8D02-4AE7-8611-8C63DAC305F7} to 'D:\Program Files\Microsoft SQL Server\'

2010-01-13 15:02:55 Slp: The configuration object document /Datastore/ProductSettings/ClusterNodesStatus/Public was found in the datastore.

2010-01-13 15:02:56 Slp: The configuration object document /Datastore/ProductSettings/ClusterDisk/Public was found in the datastore.

2010-01-13 15:02:56 Slp: The configuration object document /Datastore/ProductSettings/ClusterGroup/Public was found in the datastore.

2010-01-13 15:02:56 Slp: The configuration object document /Datastore/ProductSettings/ClusterIPAddresses/Private was found in the datastore.

2010-01-13 15:02:56 Slp: The configuration object document /Datastore/ProductSettings/ClusterNode/Public was found in the datastore.

2010-01-13 15:02:57 Slp: The configuration object document /Datastore/ProductSettings/FailoverClusterName/Public was found in the datastore.

2010-01-13 15:02:57 Slp: The configuration object document /Datastore/ProductSettings/Agent/Public was found in the datastore.

2010-01-13 15:02:57 ACE: check for instance name, got: 'MSSQLSERVER'

2010-01-13 15:02:57 Slp: Hosting object: Microsoft.SqlServer.Configuration.SSIS.SSISConfigurationPublic skipped since related features not chosen

2010-01-13 15:02:57 Slp: Hosting object: Microsoft.SqlServer.Configuration.AnalysisServices.ASConfigurationPublic skipped since related features not chosen

2010-01-13 15:02:57 Slp: The configuration object document /Datastore/ProductSettings/SqlEngine/Public was found in the datastore.

2010-01-13 15:02:57 Slp: Error: Action "FinalCalculateSettings" threw an exception during execution.

2010-01-13 15:02:57 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Illegal characters in path. ---> System.ArgumentException: Illegal characters in path.

2010-01-13 15:02:57 Slp:    at System.IO.Path.CheckInvalidPathChars(String path)

2010-01-13 15:02:57 Slp:    at System.IO.Path.Combine(String path1, String path2)

2010-01-13 15:02:57 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPublic.RecomputeDirectoryPaths()

2010-01-13 15:02:57 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPublic.Calculate()

2010-01-13 15:02:57 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.FinalCalculateSettingsAction.ExecuteAction(String actionId)

2010-01-13 15:02:57 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2010-01-13 15:02:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2010-01-13 15:02:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2010-01-13 15:02:57 Slp:    --- End of inner exception stack trace ---

2010-01-13 15:02:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2010-01-13 15:02:57 Slp: Received request to add the following file to Watson reporting: C:\Users\tejas.parikh.NA\AppData\Local\Temp\tmp26BB.tmp

2010-01-13 15:02:57 Slp: The following is an exception stack listing the exceptions in outermost to innermost order

2010-01-13 15:02:57 Slp: Inner exceptions are being indented

2010-01-13 15:02:57 Slp:

2010-01-13 15:02:57 Slp: Exception type: System.ArgumentException

2010-01-13 15:02:57 Slp:     Message:

2010-01-13 15:02:57 Slp:         Illegal characters in path.

2010-01-13 15:02:57 Slp:     Stack:

2010-01-13 15:02:57 Slp:         at System.IO.Path.CheckInvalidPathChars(String path)

2010-01-13 15:02:57 Slp:         at System.IO.Path.Combine(String path1, String path2)

2010-01-13 15:02:57 Slp:         at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPublic.RecomputeDirectoryPaths()

2010-01-13 15:02:57 Slp:         at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPublic.Calculate()

2010-01-13 15:02:57 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.FinalCalculateSettingsAction.ExecuteAction(String actionId)

2010-01-13 15:02:57 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2010-01-13 15:02:57 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2010-01-13 15:02:57 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2010-01-13 15:02:58 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100113_150005\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_

2010-01-13 15:02:58 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100113_150005\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_

2010-01-13 15:02:59 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100113_150005\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_

2010-01-13 15:03:02 Slp: The following exception occurred during Watson failure processing: The process cannot access the file 'C:\Users\tejas.parikh.NA\AppData\Local\Temp\tmp26BB.tmp' because it is being used by another process.

2010-01-13 15:03:03 Slp:

2010-01-13 15:03:03 Slp: ----------------------------------------------------------------------

2010-01-13 15:03:03 Slp:

2010-01-13 15:03:03 Slp: Error result: -213508975

2010-01-13 15:03:03 Slp: Result facility code: 838

2010-01-13 15:03:03 Slp: Result error code: 7313

===============================================================

===============================================================

Anytime I try to install the engine, installation fails. It says, files is being used.

Can you please give me a pointer to go to with this?

I can also send you my config file if you can tell me where to.

Thank you,

Tejas.

January 13, 2010 3:16 PM
 

John Paul Cook said:

Send email to john paul cook AT hotmail DOT com making appropriate substitutions for the uppercase letters. Remove all spaces.

You'll probably get better results posting to the SQL Server Setup forum found here: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads

January 13, 2010 10:55 PM
 

Alex said:

This configuration file provides the ability to deploy SQL throughout the enterprise with the same configurations. Here is the MSDN http://msdn.microsoft.com/en-us/library/dd239405.aspx  which covers installing SQL using configuration files.

March 2, 2010 2:45 PM
 

Mark Allen said:

Hi John,

Had a question about your blog post.  Do you know how to generate something like a ConfigurationFile.ini AFTER an install?

My case is this...I'm wanting to mirror a long existing SQL 2005 installation.  Is there a way to generate this file or something like it post installation?  I've already searched the existing system files, the .ini file doesn't exist.

Thanks for you help.

-Mark Allen

June 24, 2010 12:16 PM
 

Derek said:

Check out my SQL 2008 R2 unattended script on my blog:

http://derek858.blogspot.com/2010/07/unattended-sql-2008-r2-scripts.html

July 4, 2010 1:17 AM
 

Nick Olsen said:

With the release of SQL Server 2008 R2, by default the ConfigurationFile.ini is not created when installing the Express version.  Check out this blog entry for a solution on how to get the installer to generate the ConfigurationFile.ini:

http://nickstips.wordpress.com/2010/08/16/sql-sql-server-2008-express-missing-configurationfile-ini/

August 16, 2010 7:19 PM
 

Mohammed said:

In the SQL server configuration manager, there is an item called SQL server network configuration, under protocols, I selected the properties of the TCP/IP protocol. There is a tab "IP Addresses" there, and at the bottom of the list is an entry called IPAll. In my case the TCP port was empty. I entered the SQL standard port 1433 in there and I was able to connect.

May 12, 2011 5:55 AM
 

Mike Cawby said:

To generate the configuration.ini file you start to do an install and when you get to the end right before it starts to lay down the files, you will see the location listed at the bottom of the screen. It will be in the c:\program files\...  After you copy the INI file you then cancel the install.  

August 1, 2012 3:07 PM
 

Simon said:

I had a problem with the configuration file, and found out, that the uimode parameter in the configuration file cannot be used with the quiet or quietsimpel argument. I deleted the uimode parameter and everythink worked good. Be aware of that!

September 13, 2013 6:41 AM

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is a Technology Solutions Professional for Microsoft's data platform and works out of Microsoft's Houston office. Prior to joining Microsoft, he was a Microsoft SQL Server MVP. He is experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse who graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. He volunteers as a nurse at safety net clinics. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Opinions expressed in John's blog are strictly his own and do not represent Microsoft in any way.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement