Post reply

Error when opening BIDS 2008 R2 - SQL Server 2008 R2 - Urgent

  • April 25, 2014 at 11:33 am

    #306786

    Hi,

    from two days when I launch BIDS 2008 R2 I've an error that says it isn't possible to find one or more components and it is need to reinstall the application.

    SQL Server 2008 R2 is installed on my machine with Windows 7 64-bit. Until two day ago I haven't any problems with BIDS and SQL Server.

    I've already tried to remove all SQL Server client tools and reinstall them; moreover I've tried to use the repair setup feature but with no results.

    I've also tried to install a new SQL Server 2008 R2 instance but unsuccessfully.

    Any suggests to me, please, in order to solve this issue?

    Does it exist a tool to verify the SQL Server installation and/or repair it?

    Can I control any setup logs to understand which are the missing components for BIDS?

    The event viewer cannot help me in this case.

    Many thanks!!!

  • April 25, 2014 at 11:59 am

    #1708882

    try starting bids with the switch /log

    This will write an activity log to (assuming standard installation of windows 7+) c:\users\your_login\AppData\Roaming\Microsoft\9.0

    You can double click the ActivityLog.xml file (as long as there is an ActivityLog.xsl as well) to see the report in your Browser.

    Look for Red errors and warnings (start at the end and work up)...

    It might give you a clue what is wrong.

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • April 25, 2014 at 2:06 pm

    #1708903

    Hi,

    when you say to try starting bids with the switch /log, which command do I run?

    Thanks

  • April 26, 2014 at 10:21 am

    #1708973

    Right click on the BIDS icon (the one you usually left click to open BIDS) and choose properties.

    In the "Target" text box, add a space and /log

    So you get something like (yours may differ)

    "C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe" /log

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • April 26, 2014 at 3:11 pm

    #1709000

    Done.

    Now, where can I read the log information?

    Thanks

    P.S.: no ActivityLog xml file is visible in the folder c:\users\my_login\AppData\Roaming\Microsoft\VisualStudio\9.0. I can see only an old ActivityLog xsl file.

  • April 26, 2014 at 4:42 pm

    #1709003

    Have you actually run BIDS after changing that shortcut?

    If so, try searching under your AppData folder for ActivityLog.xml , it may be in a different folder.

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • April 26, 2014 at 11:06 pm

    #1709015

    Certainly that I've launched BIDS after the adding of the /log string.

    Then I've searched the ActivityLog.xml in the entire AppData folder of my user folder but no results:

    I've found only xsl files.

    Thanks

  • April 27, 2014 at 2:59 am

    #1709021

    You could also try the /resetsettings switch or /setup

    See here http://msdn.microsoft.com/en-us/library/xee0c8y7(v=vs.90).aspx

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • April 27, 2014 at 3:09 pm

    #1709048

    Also with the /resetsettings and the /setup options I've obtained no results.

    The error remains the same.

    Thanks

    Likely the lack of one or more components doesn't allow to run the minimal IDE for BIDS and so fe it isn't possible to produce a log file.

  • April 28, 2014 at 6:27 am

    #1709136

    Use a dependency walker (http://support.microsoft.com/kb/256872) to check devenv.exe file for missing libraries.

    I know some software installations can change C++ runtime libraries and break Visual Studio.

    Far away is close at hand in the images of elsewhere.
    Anon.

    • Viewing 10 posts - 1 through 9 (of 9 total)

    You must be logged in to reply to this topic. Login to reply