SQL SERVER – 2012 RC0: Fix Setup Error: File format is not valid

I recently had long email conversation with one of the blog reader who was struggling with installing SQL Server 2012 RC0 installation. I just thought I will publish what we have done and how we solved problem so if you are facing the same issue, you can avoid the same.

Though our conversation was very long – I have kept only relevant conversation here.

User: While installing the SQL Server 2012 RC0 the error which is displayed is: File format is not valid.
Pinal: Download the iso format idea again.
User: Downloaded the iso media and extracted it again into C Drive and attempted the installation – still the same error.
Pinal: What is the tool you are using to extract the file?
User: (Some tool)
Pinal: Use alternate iso extractor tool or  winrar to extract file.
User: It worked!

The original media was all fine. However, when user was using a software which extract the files from ISO to folder, it was corrupting few files. Well, if you face this issue remember to attempt new software to extract your file. If that does not work, try one more time to download the file.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

6 thoughts on “SQL SERVER – 2012 RC0: Fix Setup Error: File format is not valid

  1. I normally use the freeware – SlySoft Virtual Clone Drive – http://www.slysoft.com/en/download.html to “mount” the ISO image and use it as a virtual CD/DVD drive.

    Quite frankly, while Microsoft ships quite a large amount of it’s products via ISOs, it does not natively provide the ability to mount the ISO file. I found a Connect post that is marked as “Won’t Fix” – http://connect.microsoft.com/WindowsServerFeedback/feedback/details/351231/mount-iso-files

    For XP users, the solution in the form of a Virtual CD Control Panel – http://download.microsoft.com/download/7/b/6/7b6abd84-7841-4978-96f5-bd58df02efa2/winxpvirtualcdcontrolpanel_21.exe
    However, please note that Vista and Windows 7 users will need the compatibility mode ON to use the Virtual CD control panel – where 3rd party products win without a doubt.


  2. “ Msg 7630 syntax error near ‘photos’ in the full text search condition ’Celebrity Photos’

    • But in case of the following codes I was not get the exact results. If I comment the second (2nd) line I get the exact results. But in case of function if I not using the second(2nd) line this will shows an error “ Msg 7630 syntax error near ‘photos’ in the full text search condition ’Celebrity Photos’
    Declare @txtKeyword varchar (500) =’Celebrity Photos’
    Set @txtKeyword = replace (@txtKeyword, ‘ ‘,’ near ‘)
    Select (len (ColumnName) – len (replace (ColumnName, @txtKeyword,’’)))/len (@txtKeyword)
    As Body_Count from TableName

    So please help me what can I do to get rid of that situation. It really needs your help.


  3. Hi Pinal…need some assistance regarding moving file groups…the requirement is as follows
    – Move all non-clustered indexes to INDEX01 file group
    – Move all user (U) type tables and clustered indexes to DATA01 file group
    I need to perform teh above in 3 databases,and in each database we have 4 schemas,and in each database we have more than 100+ tables,can you please provied me some scripts if you have to move the tables all at a time or do we have any alternative to do this…

    Thanks in advance


  4. I don’t think the problem is with the extractor tool, I download the .ISO, burn it to DVD using native tool in windows 7.
    After the burn finish, I can install the SQL server 2012 in windows 7 without problem, but when I tried to install it in windows 2008 R2 server, it gave me the ”File Format is not valid” message.
    I think if the tool corrupt some files, the error message will also appear in windows 7, but it is not.


  5. It worked for me also! I was presenting the ISO directly by Hyper-V as E: \ in my VM and had the error. I used the PowerISO and extractted the ISO files. After this, I installed and ran without any problems.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s