locked
Object reference not set to an instance of object in VS2010 Server Explorer RRS feed

  • Question

  • I am using VS2010 Professional with SQL server 2005 as a database back-end for my long term project. While connecting to the database via server explorer , suddenly i am getting the error "Object reference not set to an instance of object "..please help me on this asap.

    Thanks in advance!

    Tuesday, October 9, 2012 7:45 AM

Answers

  • Hi,

    To narrow down this issue, please verify the following things:

    1. Can you successfully connect to the SQL Server instance from SQL Server management studio?

    2. Can you connect to the SQL instance via Visual Studio Server explorer on another machine or using a different account logged onto your machine?

    Per my experience, it may caused because unexpected profile or setting damage. So try the following command in Visual Studio Command Prompt(run as administrator on vista or later OS)

    devenv /ResetSkipPkgs

    devenv /ResetSettings

    And start visual studo in safemode by running command devenv /safemode

    Please let me know the result.

    Regards,


    Alan Yao [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, October 11, 2012 2:18 AM