Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Setup Error - There was an error generating the XML document. Error code 0x84B10001.


By:   |   Read Comments (2)   |   Related Tips: More > Install and Uninstall

Attend our free MSSQLTips Webcast - How to Simplify Routine SQL Server Administration Tasks


Problem

We have a requirement to install a SQL Server 2014 stand-alone instance on Windows Server 2012 R2. We were following the steps starting from launching SQL Server setup to the ready to install page of SQL Server installation center. The moment we clicked on the "Install" button of the last setup window we were received the below error:

SQL Server Setup has encountered the following error:



There was an error generating the XML document.



Error code 0x84B10001. 

Follow this tip to fix the issue.

Solution

Step 1

Let's start from the point of error generation. Right-click on setup.exe to start the installation. Make sure to apply all the pre-requisites before starting the installation otherwise the installation rule check step will not allow you to proceed. Once the SQL Server installation center window loads, follow all steps for the SQL Server installation. Once all the required details in SQL Server installation are completed, the below window will appear to verify all the features which you want to install and the settings you want to implement for the SQL Server instance.

Ready to Install for SQL Server 2014 Setup

Step 2

Now we will click on the "Install" button from the above screen to start the installation. But here is the issue, the moment we click on the "Install" button, the below error is thrown and terminates the SQL Server installation center.

SQL Server Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001.

SQL Server Setup has encountered the following error:



There was an error generating the XML document.



Error code 0x84B10001. 

We have analyzed the Windows Event Logs and did not find anything useful to fix the issue.

Step 3

The account we were using to install SQL Server was part of the local "Administrators" group. This server resides in a different domain i.e. DOMAIN2 and the account we were using is from a different domain i.e. DOMAIN1\xyz.  Per the Windows Server Team, both domains have a trust and that is why we were able to access this machine. We asked the Windows Server Team to re-check the trust connect between both domains.

In the meantime, we found some articles on web that suggest to create a local Windows account, assign local Administrator access to this account and then try to install again. This idea seemed reasonable because there is a trust required between the domain and account to install SQL Server on this machine and this might be the issue.

To try this idea, we created a local Windows account on the server and added that account to the local administrators group. Press "WIN+X" and click "Computer Management" to create a local user.

Launch Computer Management

Right click on "Users" under Local Users and Groups tree and choose "New User..." as shown below.

Windows User Creation

A new user creation window will appear, complete the required details and click on the "Create" button. I created a user named "MSSQL".

Create a New Windows User in Computer Management

Click on the Close button to close the new user creation window.

The next step is to assign this user to the local Administrators group. Click on the "Groups" folder under Local Users and Groups tree from the left pane. All groups will be displayed in the right pane. Double click the "Administrators" group. Click on the "Add..." button to add the newly created user MSSQL to this group. You can see the MSSQL user is now part of local administrators group as shown below..

Add the MSSQL local Windows account to the Local Administrators Group

Step 4

Now, we will disconnect from the server because we were logged in using the DOMAIN1\xyz account. We will log in using the newly created local4 account MACHINENAME\ACCOUNTNAME which is Test-DC\MSSQL on the server. Sometimes you need to enter IPADDRESS\MSSQL to login to server.

Step 5

The next step is to start the SQL Server installation again using this account. We started the SQL Server installation after completing all of the required steps and this time setup started the installation and installation was successful.

Notes

You will not be able to add any domain logins to the SQL Server post installation. Here you will need to involve your windows server team to establish a trust between both domains for this server, but you can use this SQL Server instance for your project using both SQL Server logins and local Windows account logins.

Next Step


Last Update:


signup button

next tip button



About the author
MSSQLTips author Manvendra Singh Manvendra Singh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Friday, November 18, 2016 - 2:31:21 AM - Hemanth Back To Top

 Thank you

 

 


Tuesday, May 31, 2016 - 4:29:46 PM - Sowmya Back To Top

 

Wow !! Thank you so much Manu. This helped to solve my issue ! Thanks again, I love your posts... Please keep doing... All the best ! :)


Learn more about SQL Server tools