Error: Specified cast is not valid. (SqlManagerUI) I am trying to restore database created on server to my localbox however i am getting 'Error: Specified cast is not valid. (SqlManagerUI)' error message. 

Server Info: 
Windows Server 2008 Standard 64 bit
Microsoft SQL Server 2008: (Info obtained from SSMS About page)

    Microsoft SQL Server Management Studio      10.0.4064.0 
Microsoft Analysis Services Client Tools        10.0.4064.0
Microsoft Data Access Components (MDAC)         6.0.6002.18005
Microsoft MSXML                                 3.0 6.0 
Microsoft Internet Explorer                     8.0.6001.19190
Microsoft .NET Framework                        2.0.50727.4216
Operating System                                6.0.6002


My Localbox:
Windows 7 64bit
Microsoft SQL Server 2008:

Microsoft SQL Server Management Studio          10.0.4064.0
Microsoft Analysis Services Client Tools        10.0.4064.0
Microsoft Data Access Components (MDAC)         6.1.7601.17514
Microsoft MSXML                                 3.0 4.0 5.0 6.0 
Microsoft Internet Explorer                     9.0.8112.16421
Microsoft .NET Framework                        2.0.50727.5448
Operating System                                6.1.7601


Does anyone know how to fix this issue?  

Sanjeev
Generate the restore script from the GUI, instead of using the GUI to do the restore.

Then add the PASSWORD option...

--generated from the GUI dialog box
RESTORE DATABASE foo FROM  DISK = N'somepath' WITH ...

-- and add this
PASSWORD = '**password_is_this**'
GO