none
Error: Specified cast is not valid. (SqlManagerUI)

    Question

  • 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


    creativity..



    Wednesday, March 07, 2012 2:11 PM

Answers

  • i have never experienced this issue but did a quick search and got the below threads might help you

    http://blogs.msdn.com/b/sqlserverfaq/archive/2010/11/02/restore-database-fails-while-trying-to-restore-password-protected-backup-set-from-ssms.aspx

    http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/9f29c16b-d783-406e-94f2-22720b8993b4

    http://technoscatter.blogspot.com/2011/11/ms-sql-troubleshoot-2-specified-cast-is.html

    All of the above talk about different reasons for the error.

    HTH


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Wednesday, March 07, 2012 2:22 PM

All replies

  • i have never experienced this issue but did a quick search and got the below threads might help you

    http://blogs.msdn.com/b/sqlserverfaq/archive/2010/11/02/restore-database-fails-while-trying-to-restore-password-protected-backup-set-from-ssms.aspx

    http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/9f29c16b-d783-406e-94f2-22720b8993b4

    http://technoscatter.blogspot.com/2011/11/ms-sql-troubleshoot-2-specified-cast-is.html

    All of the above talk about different reasons for the error.

    HTH


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Wednesday, March 07, 2012 2:22 PM
  • Thanks Ashwin.

    Solution posted in this link worked.

    http://technoscatter.blogspot.com/2011/11/ms-sql-troubleshoot-2-specified-cast-is.html


    creativity..

    Wednesday, March 07, 2012 5:09 PM