Strange errors with SQL Server 2008 setup   Leave a comment


This is a quick post to let you know about two strange errors I recently encountered during SQL Server 2008 setup and the steps on how to resolve them.

 

1.    Installation of SQL Server client tools (SSMS) fails with this error message:

 

 

SSMS error

 

Error text (for search purpose)

 

Microsoft SQL Server Management studio
---------------------------------------
Cannot find one or more components. Please reinstall the application.
---------------------------------------

 

Above error used to pop up once during the installation, you hit OK, SSMS install will complete. Setup summary shows all green. No errors. Now, you try to launch SSMS and you get the same error as above. SSMS fails to launch.

 

After a few hours of troubleshooting, it turned out that the machine was affected with some virus/malware which caused this stupid problem.

Although the machine had an antivirus programs installed, it could not catch the virus. I used the below software to remove those virus/malware and SSMS worked just fine.

 

i.               SuperAntiSpyware:  http://www.superantispyware.com

ii.              Emsisoft Anti-Malware:   http://www.emsisoft.com

P.S: I don’t endorse these antivirus products. I have just mentioned what I used in my case. You may use the one of your own choice.

2.   Installation of SQL Server database engine fails/disappears with the following error :

Setup bad media error

Error text (for search purpose)

 

SQL Server Setup failure.
-------------------------
SQL Server Setup has encountered the following error:
 
", hexadecimal value 0x11, is an invalid character. Line 31, position 52..
-------------------------

                                This was a strange error. Looking at the setup logs, following errrors were logged:

Summary_SQLMachine_20131203_091947_ComponentUpdate.txt

Overall summary:
Final result:                  Failed: see details below
Exit code (Decimal):           -2146232000
Exit facility code:            19
Exit error code:               6464
Exit message:                  '', hexadecimal value 0x11, is an invalid character. Line 31, position 52.
Start time:                    2013-12-03 09:14:01
End time:                      2013-12-03 09:19:28
Requested action:              ComponentUpdate
Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0x066FCAFD%400x5539C151&EvtType=0x066FCAFD%400x5539C151

 

Detail_ComponentUpdate.txt

(01) 2013-12-03 09:18:47 Slp: Running Action: ProcessUpdateParametersAction
(01) 2013-12-03 09:18:47 Slp:
(01) 2013-12-03 09:18:47 Slp: Product Update Status:
(01) 2013-12-03 09:18:47 Slp:   None discovered.
(01) 2013-12-03 09:18:47 Slp:   Error message:
(01) 2013-12-03 09:18:47 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(01) 2013-12-03 09:18:47 Slp: Inner exceptions are being indented
(01) 2013-12-03 09:18:47 Slp:
(01) 2013-12-03 09:18:47 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.CancelException
(01) 2013-12-03 09:18:47 Slp:     Message:
(01) 2013-12-03 09:18:47 Slp:         Setup is not able to find a server to download product updates because the operation is cancelled.
(01) 2013-12-03 09:18:47 Slp:     HResult : 0x84b70642
(01) 2013-12-03 09:18:47 Slp:         FacilityCode : 1207 (4b7)
(01) 2013-12-03 09:18:47 Slp:         ErrorCode : 1602 (0642)

 

                This was really tricky to figure out. It turned out to be an issue with a bad media. The setup media (iso file) was been downloaded from msdn site, yet a corruption may occur in the downloaded file. I used the steps outlined in this excellent blog to verify the checksum of the downloaded media.

        SQL Server Setup: How to validate downloaded image/media before installation

http://thesqldude.com/2012/01/27/sql-server-setup-how-to-validate-downloaded-imagemedia-before-installation/

 

I could clearly see the SHA1 key output by fciv was different than the one listed on msdn site. I downloaded the setup media again, verified that the checksum matches. Now SQL Server setup was all smooth.

 

I hope someone will find it helpful to deal with these two strange errors while installing SQL Server.

 

Stay tuned and do leave a comment!

 

Leave a Comment

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

%d bloggers like this: