{"id":137,"date":"2010-09-22T00:33:45","date_gmt":"2010-09-22T07:33:45","guid":{"rendered":"http:\/\/zalbee.intricus.net\/immerge\/blog\/?p=137"},"modified":"2025-05-23T22:49:05","modified_gmt":"2025-05-24T02:49:05","slug":"installing-sql-server-2008-on-xp-sp2","status":"publish","type":"post","link":"https:\/\/zalbee.intricus.net\/immerge\/blog\/137","title":{"rendered":"Installing SQL Server 2008 on XP SP2"},"content":{"rendered":"

My girlfriend is taking an accounting course that requires installing Microsoft SQL Server database software on her personal computer. In short, there were a lot of problems.\u00a0It was such an ordeal that I am chronicling it here. This is installing SQL Server 2008 Express on Windows XP SP2 Chinese (PRC).<\/p>\n

Here are the problems and the fixes applied in order (the ones that worked):<\/p>\n

<\/p>\n

    \n
  1. Can’t get to install screen. Error result: -2068774911, Result facility code: 1201\n

    \"Error<\/p>\n

    In the summary.txt file:<\/p>\n

    \n
    Overall summary:\nFinal result:                  Failed: see details below\nExit code (Decimal):           -2068774911\nExit facility code:            1201\nExit error code:               1\nExit message:                  There was an error generating the XML\n                               document.\nStart time:                    2010-09-13 04:43:22\nEnd time:                      2010-09-13 04:43:56\nRequested action:              RunRules<\/pre>\n<\/blockquote>\n
    Fix needed: <\/strong>You can not install this under the default Administrator account. Create a new admin-level user account, login to it, and install from there.<\/p>\n
    Source: Vitaly Dilmukhametov<\/a> (Trivia: 0x84B10001 as a 32-bit signed integer is -2068774911.)<\/li>\n
  2. After doing this, you will lose access to the Administrator account. Actually it is not gone, just hidden (you can see it in Safe Mode).
    \n<\/strong><\/p>\n
    Fix optional:<\/strong> To restore it so it always shows up, follow the instructions<\/a> here. Then you will be able to choose Administrator from the list of accounts on the Welcome Screen when you boot up Windows.<\/li>\n
  3. Install asks to browse for installation media when installing from the DVD.\n
    Fix:<\/strong> Copy the folder “sql2008exp32” (for Windows 32 bit version) from the DVD to the Desktop, and running the file “setupsql2008exp” directly from the downloaded copy on the Desktop.<\/p>\n
    Source: user post.<\/li>\n
  4. Validation errors at Server Configuration. Empty Account Name and Password. I don’t know why the install left it blank. But I just copied the account name from my own working installation of SQL Server 2008 R2.\n
    Correct settings:<\/strong><\/p>\n
    \"Server<\/p>\n
    SQL Server Database Engine<\/p>\n