By: Manvendra Singh | Comments (10) | Related: > Install and Uninstall
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.
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.
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.
Right click on "Users" under Local Users and Groups tree and choose "New User..." as shown below.
A new user creation window will appear, complete the required details and click on the "Create" button. I created a user named "MSSQL".
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..
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
- Make sure to check for proper rights\trusts between both domains if you are trying to install a SQL Server from a different domain before starting the SQL Server installation.
- Explore more knowledge on
About the author
Manvendra Singh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
