Unable to connect to SQL , “Error executing extended stored procedure: Invalid Parameter (Microsoft SQL Server, Error: 22001”

Issue   When we try to connect to a SQL instance from SQL server Management studio we get the following error : Error executing extended stored procedure: Invalid Parameter Error executing extended stored procedure: Invalid Parameter (Microsoft SQL Server, Error: 22001)     Environment Windows : Windows Server 2000 Service Pack :SP4 SQL Version: SQL…

0

RESTORE DATABASE fails while trying to restore password protected backup set from SSMS

ISSUE: I’m trying to restore a database backup from SSSMS-UI, however it fails in an initial stage with below error TITLE: Microsoft SQL Server Management Studio——————————Specified cast is not valid. (SqlManagerUI)—————————— Here’s the detailed error:Program Location: at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.PopulateGridWithBackupSetsFromDevices()at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.GetBackupSetsFromDevices()at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.textDeviceSelected_TextChanged(Object sender, EventArgs e)at System.Windows.Forms.Control.OnTextChanged(EventArgs e)at System.Windows.Forms.TextBoxBase.OnTextChanged(EventArgs e)at System.Windows.Forms.Control.set_Text(String value)at System.Windows.Forms.TextBoxBase.set_Text(String value)at System.Windows.Forms.TextBox.set_Text(String value)at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.buttonSelectDevice_Click(Object sender, EventArgs…