Answered by:
SQL Server 2008 R2 installation on Windows server 2012 R2 standard

Question
-
I am getting error while installing SQL Server 2008 R2 on windows server 2012 R2 standard
TITLE: SQL Server Setup failure. ------------------------------
SQL Server Setup has encountered the following error:
There was an error generating the XML document.
Error code 0x84B10001.
Please help me to resolve this error .
I have checked that SQL server 2008 R2 enterprise is compatible with windows server.
Tuesday, October 4, 2016 1:44 AM
Answers
-
Hello,
You must have admin rights on the server.
cheers
nuno
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Marked as answer by Arpit_CF Thursday, October 6, 2016 12:28 AM
Tuesday, October 4, 2016 11:27 PM -
Hello Dinesh ,
I have checked it with SQL Server 2008 R2 SP1 but failed again with same error.
Can it be issue with my login , because I don't have admin access .
some of them says-it might be accesses issue.
"creating a new user, configuring them as a local administrator, and then running the installation logged in as this use"
ref-https://www.mssqltips.com/sqlservertip/4276/sql-server-setup-error--there-was-an-error-generating-the-xml-document-error-code-0x84b10001/Also share the
Detail.txt
Summary Text in any shared location to take a look
ref-https://msdn.microsoft.com/en-us/library/ms143702(v=sql.105).aspxRegards, S_NO "_"
- Marked as answer by Arpit_CF Thursday, October 6, 2016 12:28 AM
Wednesday, October 5, 2016 12:51 AM -
Hi Arpit,
you have check with admin acces.Also install NET Framework 3.5 SP11.
Then try to install MSSQL setup with proper bit (32/64) depend on operating system.
Please click Mark As Answer if my post helped.
- Marked as answer by Arpit_CF Thursday, October 6, 2016 12:28 AM
Wednesday, October 5, 2016 2:20 AM
All replies
-
Hi Arpit,
you can on Windows standard edition.
SQL Server 2008 R2 Enterprise (64-bit) x64
The following table shows system requirements for SQL Server 2008 R2 Enterprise (64-bit) x64:
Component
Requirement
Processor
Processor type:
-
Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
Processor speed:
-
Minimum: 1.4 GHz
-
Recommended: 2.0 GHz or faster
Operating system
Windows Server 2003 SP2 64-bit x64 Datacenter
Windows Server 2003 SP2 64-bit x64 Enterprise
Windows Server 2003 SP2 64-bit x64 Standard
apply latest service pack.
https://support.microsoft.com/en-gb/kb/2379466
http://www.thewindowsclub.com/configuration-system-failed-to-initialize-0x84b10001
Please click Mark As Answer if my post helped.
- Edited by AV111 Tuesday, October 4, 2016 2:59 AM
Tuesday, October 4, 2016 2:44 AM -
-
You can install on shared windows server as per below link:
https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396
Is it possible to get more details on error?
Any more detail on, after which step is failed. If you can share log for that with us.
Hopefully this is first time you were installing and you got error.
Some link to check for just reference.
http://stackoverflow.com/questions/11294714/getting-xml-error-when-installing-sql-server-2012
Santosh Singh
Tuesday, October 4, 2016 6:55 PM -
Hello Dinesh ,
I have checked it with SQL Server 2008 R2 SP1 but failed again with same error.
Can it be issue with my login , because I don't have admin access .
Tuesday, October 4, 2016 11:11 PM -
Hello,
You must have admin rights on the server.
cheers
nuno
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Marked as answer by Arpit_CF Thursday, October 6, 2016 12:28 AM
Tuesday, October 4, 2016 11:27 PM -
Hello Dinesh ,
I have checked it with SQL Server 2008 R2 SP1 but failed again with same error.
Can it be issue with my login , because I don't have admin access .
some of them says-it might be accesses issue.
"creating a new user, configuring them as a local administrator, and then running the installation logged in as this use"
ref-https://www.mssqltips.com/sqlservertip/4276/sql-server-setup-error--there-was-an-error-generating-the-xml-document-error-code-0x84b10001/Also share the
Detail.txt
Summary Text in any shared location to take a look
ref-https://msdn.microsoft.com/en-us/library/ms143702(v=sql.105).aspxRegards, S_NO "_"
- Marked as answer by Arpit_CF Thursday, October 6, 2016 12:28 AM
Wednesday, October 5, 2016 12:51 AM -
Hi Arpit,
you have check with admin acces.Also install NET Framework 3.5 SP11.
Then try to install MSSQL setup with proper bit (32/64) depend on operating system.
Please click Mark As Answer if my post helped.
- Marked as answer by Arpit_CF Thursday, October 6, 2016 12:28 AM
Wednesday, October 5, 2016 2:20 AM -
Hello,
Service pack 2 is required to make SQL Server 2008 R2 compatible with Windows Server 2008 R2, and because of this requirement I suggest you to perform a slipstream installation of SQL Server 2008 R2 + SP2:
https://blogs.msdn.microsoft.com/petersad/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1/
https://support.microsoft.com/en-us/kb/2527041
Please try to run setup with the Run As Administrator option.
http://www.sevenforums.com/tutorials/11841-run-administrator.html (Second option)Also consider the workarounds posted in the following threads:
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/10d4ab5c-55be-4dd1-8ca7-13a1703bd9f0 (Jim Chen - Microsoft)
Hope this helps.
Regards,Alberto Morillo
SQLCoffee.com- Proposed as answer by Shanky_621MVP Wednesday, October 5, 2016 5:38 AM
Wednesday, October 5, 2016 3:59 AM -
I always believe that for SQL Server setup failed scenario it is always better to ask for summary.txt file and details.txt file, this has always been the correct approach. The actual reason of failure lies in that files.
If you can share that I will see if something new can be added apart from answers given
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
My TechNet Wiki Articles
MVP
- Edited by Shanky_621MVP Wednesday, October 5, 2016 5:41 AM
Wednesday, October 5, 2016 5:40 AM -
Hi Shashank ,
It was a DNS issue , server was not able to resolve Ad group created for admin users.
And My login was part of that group .
Thursday, October 6, 2016 12:27 AM