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

PingBack from http://tannersspace.com/2009/02/sql-server-2008-supports-replay-installationshooray/

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

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.

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

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.

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

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

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

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/