none
Silent Install Issue - User Profile not found

    Question

  • I am trying to perform a silent installation of SQL Server remotely. It fails with the below error. On investigation I found that the user account I am using to install SQL with do not have a profile configured on the server. When I login with the user once it completes successfully. Is there a way to automate user profile creation on the server? Or any workaround that do not require me to manually login to the server with the user account is appreciated.

    Exception summary:

    The following is an exception stack listing the exceptions in outermost to innermost order

    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException

        Message:

            There was an error generating the XML document.

        HResult : 0x84b10001

            FacilityCode : 1201 (4b1)

            ErrorCode : 1 (0001)

        Data:

          DisableWatson = true

        Stack:

            at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache)

            at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.FlushCache(Boolean removeAllCachedObj)

            at Microsoft.SqlServer.Configuration.SetupExtension.DatastoreCacheFeatureConfigEventHandler.InConfigurationActionExecutionEventHandler(Object sender, FeatureConfigScenarioEventArgs eventArgs)

            at Microsoft.SqlServer.Chainer.Infrastructure.NotificationHandler.Invoke(Object notification, Object[] objectArray)

            at Microsoft.SqlServer.Chainer.Infrastructure.NotificationService.OnNotify(Object eventKey, Object notification, Object[] objectArray)

            at Microsoft.SqlServer.Configuration.ConfigExtension.ConfigFeatureActionListener.InConfigurationActionExecutionEventHandler(ActionKey key, TextWriter loggingStream)

            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionMetadata.NotifyInExecution(ActionKey actionRunning, TextWriter loggingStream)

            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

            at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()

            at Microsoft.SqlServer.Chainer.TimingConfigAction.Execute(String actionId, TextWriter errorStream)

            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)

        Inner exception type: System.InvalidOperationException

            Message:

                    There was an error generating the XML document.

            HResult : 0x80131509

            Stack:

                    at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)

                    at System.Xml.Serialization.XmlSerializer.Serialize(TextWriter textWriter, Object o, XmlSerializerNamespaces namespaces)

                    at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache)

            Inner exception type: System.Security.Cryptography.CryptographicException

                Message:

                            The data protection operation was unsuccessful. This may have been caused by not having the user profile loaded for the current thread's user context, which may be the case when the thread is impersonating.

                HResult : 0x80131430

                Stack:

                            at System.Security.Cryptography.ProtectedData.Protect(Byte[] userData, Byte[] optionalEntropy, DataProtectionScope scope)

                            at Microsoft.SqlServer.Common.SqlSecureString.WriteXml(XmlWriter writer)

                            at System.Xml.Serialization.XmlSerializationWriter.WriteSerializable(IXmlSerializable serializable, String name, String ns, Boolean isNullable, Boolean wrapped)

                            at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterSqlEngineSetupPublic.Write7_SqlEngineSetupPublic(String n, String ns, SqlEngineSetupPublic o, Boolean isNullable, Boolean needType)

                            at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterSqlEngineSetupPublic.Write8_SqlEngineSetupPublic(Object o)

    Sunday, December 4, 2016 5:04 PM

All replies

  • Hi ,

    1.create new windows user.

    2.add him Admin group 

    3. run this setup using this user


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Monday, December 5, 2016 3:46 AM
  • Hi,

    I am using a domain user account. The user is already added to the local admin group.  

    Thanks,




    • Edited by mmumshad2 Tuesday, December 6, 2016 4:26 PM
    Monday, December 5, 2016 7:30 PM
  • Hi mmumshad2,

    >>Is there a way to automate user profile creation on the server?

    From what i can tell, this could be done via PowerShell. For more information, please refer to this SO thread.

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, December 23, 2016 6:24 AM
    Moderator