locked
MS SQL Server 2005 error.......... RRS feed

  • Question

  •  

    Hi Friends,

     

    I am worrking on SQL Server 2005.

     

    When ever i opned SQL Server Management Studio. I am getting  bellow error.

     

    System.FormatException: Input string was not in a correct format.
       at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
       at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
       at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
       at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
       at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs e)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs e)
       at System.Windows.Forms.Control.WmShowWindow(Message& m)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.ContainerControl.WndProc(Message& m)
       at System.Windows.Forms.Form.WmShowWindow(Message& m)
       at System.Windows.Forms.Form.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

     

     

     

    Please could any bady help me.

     

     

    thanks

    Babu

    Monday, June 2, 2008 2:28 PM

Answers

All replies

  • Hi Babu,

     

    You can try re-installing SQL Client components alone. If possible install .Net too.

    Monday, June 2, 2008 2:52 PM
  • Hi Vidhya sagar,

     

     

    thanks for your reply.

     

    I have installed .Net & SQL server 2005   4times in my mechine.

    But still i am getting same error.

     

    Just now i downloaed 3rd party tool based on .Net framework. still that one also giving same error.

     

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.InvalidCastException: Conversion from string "0" to type 'Integer' is not valid. ---> System.FormatException: Input string was not in a correct format.
       at Microsoft.VisualBasic.CompilerServices.DoubleType.Parse(String Value, NumberFormatInfo NumberFormat)
       at Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value)
       --- End of inner exception stack trace ---
       at Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value)
       at Options.frmOptions.GetDflValue()
       at Options.frmOptions.frmOptions_Load(Object sender, EventArgs e)
       at System.Windows.Forms.Form.OnLoad(EventArgs e)
       at System.Windows.Forms.Form.OnCreateControl()
       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
       at System.Windows.Forms.Control.CreateControl()
       at System.Windows.Forms.Control.WmShowWindow(Message& m)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.ContainerControl.WndProc(Message& m)
       at System.Windows.Forms.Form.WmShowWindow(Message& m)
       at System.Windows.Forms.Form.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    Monday, June 2, 2008 6:46 PM
  • Babu,

     

    Can you try applying Sql Server 2005 SP2 for client tools and see if the problem persist ?

     

    - Deepak

    Monday, June 2, 2008 11:59 PM