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

Question

Post reply

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

pmscorca

SSCrazy

Points: 2349
More actions
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!!!
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]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

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);

pmscorca SSCrazy Points: 2349 More actions · Answer 2

Hi,

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

Thanks

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

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);

pmscorca SSCrazy Points: 2349 More actions · Answer 4

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.

mister.magoo SSC-Forever Points: 47174 More actions · Answer 5

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);

pmscorca SSCrazy Points: 2349 More actions · Answer 6

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

mister.magoo SSC-Forever Points: 47174 More actions · Answer 7

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);

pmscorca SSCrazy Points: 2349 More actions · Answer 8

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.

David Burrows SSC Guru Points: 65142 More actions · Answer 9

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.