question

junsqlscreen avatar image
junsqlscreen asked

SQL server 2008 R2 Setup failure

I am trying to install sql server 2008 on my Windows XP and got the error message: TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: Could not load file or assembly '0 bytes loaded from System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. An attempt was made to load a program with an incorrect format. Error code 0x84B10001. ------------------------------ BUTTONS: OK ------------------------------ Please help!! Thanks, June
sql-server-2008-r2
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@junsqlscreen Is it possible that your .NET Framework 2.0 installation on that Windows XP box is corrupted? The version of the System.dll and key token appear to be correct, but you can check the file size as well from cmd prompt:
C:\
cd WINDOWS\\assembly\\NativeImages_v2.0.50727_32\\System\\80978a322d7dd39f0a71be1251ae395a
dir
This should show you the size of System.ni.dll (7,868,416 bytes) If not, maybe reinstalling .NET 2.0 Framework will solve the problem.
0 Likes 0 ·
C:\WINDOWS\assembly\NativeImages_v2.0.50727_32\System\37217abe2c5164e59aba251860f4c79e>dir Volume in drive C has no label. Volume Serial Number is CC72-9055 Directory of C:\WINDOWS\assembly\NativeImages_v2.0.50727_32\System\37217abe2c51 64e59aba251860f4c79e 7,949,824 System.ni.dll seems it's a little bigger. Thanks, June
0 Likes 0 ·
DaniSQL avatar image
DaniSQL answered
Have you looked for a more detailed error message in the Setup log? [How to: View and Read SQL Server Setup Log Files][1] [1]: http://msdn.microsoft.com/en-us/library/ms143702.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

junsqlscreen avatar image
junsqlscreen answered
The error came up just after I clicked the setup.exe and the log file has not been generated yet. Thanks June
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image
sp_lock answered
Are you trying to install the x32 or x64 version of SQL Server?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

x32 version.
0 Likes 0 ·
Can you confirm the versions of .NET installed... C:\Windows\ Microsoft.NET\
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Is this installation using Microsoft's Web Platform Installer (WPI), or using files directly downloaded from Microsoft? I had problems when using WPI and I ended up installing the components it recommended individually and in the following order: 1. CLR Types 2. Native Client 3. Shared Management Objects 4. SQL Server 5. Management Studio
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I was using the files directly downloaded from Microsoft. Thanks
0 Likes 0 ·
What files did you get from MS?
0 Likes 0 ·
That's a bunch of files and folders I downloaded with the embedded product code.
0 Likes 0 ·
SQLMaster avatar image
SQLMaster answered
The pre=requisite of .NET framework 3.5 Sp1 & Windows Installer 4.5 is a must before you attempt to pass through the SQL Server setup installation, so ensure you have installed these versions before attempting another trial. I have seen this on my 64 bit environment,due to media corruption and replaced the files with fresh installation worked like charm.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I got another machine and installed all the windows updates. Then it worked. Thanks everyone.
0 Likes 0 ·
Willjoe2442 avatar image
Willjoe2442 answered

Download the SQL Server image again from the original location, and then rerun the Setup program. If you installed SQL Server over a computer network, install it again from a local drive, and then rerun the Setup program. Rename the Setup.


Regards,

Will

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.