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

duncanph — Thu, 23 Jul 2009 15:17:56 GMT

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

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

Tejas — Wed, 13 Jan 2010 20:16:07 GMT

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: