Can't Start SS Business Intelligence installed from SS 2005 Express Edition Toolkit

I downloaded and installed Microsoft SQL Server 2005 Express Edition with Advanced Services and Microsoft SQL Server 2005 Express Edition Toolkit. Installs completed successfully, and I can launch the SS Management Studio, but when I launch SS Business Intelligence Development Studio, I get message saying "Windows is searching for devenv.exe". When I search for this file I don't find it on my hard drive.

I thought I'd reinstall the SS Express Edition Toolkit, but I can't find this application in the Control Panel Installed Programs list, so I can't uninstall it.

Any ideas as to how I can get SS Business Intelligence Studio working?

Hey Probie,

Individual SQL components are all listed in Add/Remove Programs under Microsoft SQL Server 2005. You have to launch the main app maintenance mode and then select the component you want to remove, in this case the Workstation Tools, an go from there.

It does look like something went wrong with the installation of the VS shell that BIDS uses, so uninstall is a likely first step.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

Probie,

Do you have visual studio 2003 installed?

I had the same problem and it seemed related to VS2003:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368549&SiteID=1

|||

Thanks for this information Lacan. Probie, let us know if this works for you.

- Mike

|||

Hello,

I am having the same problem as probie. Although BIDS shows in my programs menu, it does not appear as a component in Add/Remove programs neither will it run when accessed via the start menu.

Does anyone know if there is a way to resolve this issue?

Cheers,

sfx

|||

sfx1,

Did you already try what I had suggested via the link above?

(unzip the files from the SQLEXPR_TOOLKIT.EXE and launch the vs_setup.msi directly under the exposed \setup folder)?

When you say that it won't run, do you mean that the devenv.exe is not found? If so, please try what I suggested and see if it installs the devenv for you. If it doesn't work, try running that package vs_setup.msi with logging and see what the log says.

Regards,

Lacan

|||

Hi Lacan,

Thank you for your reply. Did you happen to install the SQLEXPR_TOOLKIT.EXE prior to running the vs_setup.msi or did you just install the vs_setup.msi by itself?

Thanks again,

sfx1

|||

I believe the last time, I had tried to install everything gtom sqlexpr_toolkit.exe FIRST, and when the shortcut to BIDS did not work, I started exploring and found the vs_setup.msi and ran that.

It installed BIDS correctly, then I was able to start designing reports. Good question, and I should have been more explicit about the order. Thanks

Regards,

-Lacan

|||

Hi Lacan,

Thanks for getting back to me, I appreciate it. I will give your suggestions a go. :)

Cheers,

sfx1

|||

Lacan,

I found the vs_Setup.msi in the setup folder of SQLxpress Tools.exe. Ran the setup

(there is no indication that the vs_setup is running, but when I checked Processes in task manager, msiexec.exe was using CPU) ,

after setup ended, voila! devene.exe was in the IDE folder, and BIDS opened successfully.

Thanks for your help.

probie

|||

I didn't get any indication that setup was running either. The package just seemed to sound like it was responsible for the devenv part of it so I ran it as an experiment and the same occurred for me.

I'm glad it worked out.

Regards,

-Lacan

sql

Can't save or compile package (insufficient memory)

When I compile or save a SSiS package in the SQL Server Business Intelligence Development Studio I get the error

Failure saving package. (Microsoft Visual Studio)

Insufficient memory to continue the execution of the program.

Sometimes, if I wait longer time, the package can suddenly be saved.

I have 2 GB of RAM und over 15 GB of free space on my disk. Thus, there should be anough space to save the package.

What should I do to resolve this problem? It seems to be a bug.

To splitt the package would not be a solution.

How large is the package, and what version of Visual Studio are you running?

Can't run SSRS Projects SSBIDS

I'm trying to open an Reporting Services project in Sql Server Business Intelligence Development Studio (which looks a lot like Visual Studio 2005). This project was copied from another computer where it runs normally. I get the following error when trying to open it...

Package Load Failure

Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid = etc..). Please contact package vendor for assistance. Application restart is recommended, due to possible enfvironment corruption. Would you like to disable loadinug for this package in the future? you may use 'devenv /resetskippkgs' to re-enable package loading.

I also tried to create a new Reporting services project and I got the following error....

Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0...blah blah.

Some of my research so far says the first message could be related to having ran a beta version of vs2005 on this system which I did. However the ordinary vs2005 asp.net project appear to run normally.

How can I fix this problem?

Thanks,

Gary

First thing would be for me trying to reinstall the Reporting Services package. If that doen not help, reinstall VS and the reporting package with prior removing all related stuff from the server. if you had beta products from VS / SQL Server installed use the cleanup utility from Microsoft. That often helps more than getting the old installation to work properly.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

"cleanup utility from Microsoft" ? What is that? How would I get it?

Thanks,

Gary

|||http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

-Jens.|||

Found it. Ran it. found install of beta vs2005 version and ran it on that. Didn't make any difference. Still have same error.

|||

I had the same error messages (wouldn't let me open an existing BI project or create a new one). I spent at least 4 hours struggling with this and various other posts on this issue. I found it strange that microsoft's forums are full will this question but there is no official solution from them on this issue. I wish they published a knowledgebase article on this that took care of the issue for once and for all.

Anyway! What worked for me is that I installed Microsoft SqlServer Express client tools. I already had SqlServer 2005 (client tools) , Sqlserver 2005 express (database only), and Visual Studio 2005 professional installed. The order I had initially installed was that I had first installed VS.Net 2003, then installed SqlServer 2005 (client tools), then Visual Studio 2005, and inally SqlServer 2005 Express (database only). Somewhere in between I had installed the reporting services, however I don't remember exactly the sequence for this. To make the matter wors, I had installed some of these on D drive (to save on C space), as many of the posters have reported that this can also cause the issue.

Its unlikely that you may have the same problem as I, but just in case!

Can't run SSRS Projects SSBIDS

I'm trying to open an Reporting Services project in Sql Server Business Intelligence Development Studio (which looks a lot like Visual Studio 2005). This project was copied from another computer where it runs normally. I get the following error when trying to open it...

Package Load Failure

Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid = etc..). Please contact package vendor for assistance. Application restart is recommended, due to possible enfvironment corruption. Would you like to disable loadinug for this package in the future? you may use 'devenv /resetskippkgs' to re-enable package loading.

I also tried to create a new Reporting services project and I got the following error....

Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0...blah blah.

Some of my research so far says the first message could be related to having ran a beta version of vs2005 on this system which I did. However the ordinary vs2005 asp.net project appear to run normally.

How can I fix this problem?

Thanks,

Gary

First thing would be for me trying to reinstall the Reporting Services package. If that doen not help, reinstall VS and the reporting package with prior removing all related stuff from the server. if you had beta products from VS / SQL Server installed use the cleanup utility from Microsoft. That often helps more than getting the old installation to work properly.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

"cleanup utility from Microsoft" ? What is that? How would I get it?

Thanks,

Gary

|||http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

-Jens.|||

Found it. Ran it. found install of beta vs2005 version and ran it on that. Didn't make any difference. Still have same error.

|||

I had the same error messages (wouldn't let me open an existing BI project or create a new one). I spent at least 4 hours struggling with this and various other posts on this issue. I found it strange that microsoft's forums are full will this question but there is no official solution from them on this issue. I wish they published a knowledgebase article on this that took care of the issue for once and for all.

Anyway! What worked for me is that I installed Microsoft SqlServer Express client tools. I already had SqlServer 2005 (client tools) , Sqlserver 2005 express (database only), and Visual Studio 2005 professional installed. The order I had initially installed was that I had first installed VS.Net 2003, then installed SqlServer 2005 (client tools), then Visual Studio 2005, and inally SqlServer 2005 Express (database only). Somewhere in between I had installed the reporting services, however I don't remember exactly the sequence for this. To make the matter wors, I had installed some of these on D drive (to save on C space), as many of the posters have reported that this can also cause the issue.

Its unlikely that you may have the same problem as I, but just in case!

Can't run SSRS projects on SSBIDS

I'm trying to open an Reporting Services project in Sql Server Business
Intelligence Development Studio (which looks a lot like Visual Studio 2005).
This project was copied from another computer where it runs normally. I get
the following error when trying to open it...
Package Load Failure
Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid
= etc..). Please contact package vendor for assistance. Application
restart is recommended, due to possible enfvironment corruption. Would you
like to disable loadinug for this package in the future? you may use
'devenv /resetskippkgs' to re-enable package loading.
I also tried to create a new Reporting services project and I got the
following error...
Could not load file or assembly 'Microsoft.ReportingServices.Designer,
Version=9.0.242.0...blah blah.
Some of my research so far says the first message could be related to having
ran a beta version of vs2005 on this system which I did. However the
ordinary vs2005 asp.net project appear to run normally.
How can I fix this problem?
I have heard there is some cleanup utility. does anyone know how to get
that?
Thanks,
GaryI get this to everytime I open any project in BIDS.
Don't know how to fix...
"GaryDean" <GaryDean@.nospam.net> wrote in message
news:OjgnAc4oGHA.1440@.TK2MSFTNGP03.phx.gbl...
> I'm trying to open an Reporting Services project in Sql Server Business
> Intelligence Development Studio (which looks a lot like Visual Studio
> 2005). This project was copied from another computer where it runs
> normally. I get the following error when trying to open it...
> Package Load Failure
> Package 'DataWarehouse VSIntegration layer' has failed t load peoperly
> (guid = etc..). Please contact package vendor for assistance.
> Application restart is recommended, due to possible enfvironment
> corruption. Would you like to disable loadinug for this package in the
> future? you may use 'devenv /resetskippkgs' to re-enable package loading.
> I also tried to create a new Reporting services project and I got the
> following error...
> Could not load file or assembly 'Microsoft.ReportingServices.Designer,
> Version=9.0.242.0...blah blah.
> Some of my research so far says the first message could be related to
> having ran a beta version of vs2005 on this system which I did. However
> the ordinary vs2005 asp.net project appear to run normally.
> How can I fix this problem?
> I have heard there is some cleanup utility. does anyone know how to get
> that?
> Thanks,
> Gary
>

Can't open Business Intelligence studio to get at reporting servic

I downloaded sql server express 2005 tool kit which contains Business
Intelligence Studio which is what houses Reporting services. I installed it
but now I can't find where to run it. I re-installed thinking something went
wrong with the install but it says already installed. How can I run this
software'I had the exact same problem . Solution is here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362604&SiteID=1
"loulou" <loulou@.discussions.microsoft.com> wrote in message news:FB2D5F2B-712B-466F-B66C-DE9079163B06@.microsoft.com...
>I downloaded sql server express 2005 tool kit which contains Business
> Intelligence Studio which is what houses Reporting services. I installed it
> but now I can't find where to run it. I re-installed thinking something went
> wrong with the install but it says already installed. How can I run this
> software'

can't load SSIS dtsx package

hi there,

when i start SQL Server business intelligence developer and create new Integration Service project, i will see following error:

Error loading 'Package.dtsx' : Object reference not set to an instance of an object.. C:\Sairi\My Documents\Visual Studio 2005\Projects\Integration Services Project12\Integration Services Project12\Package.dtsx

this error occures just on my PC and i reinstalled VS2005 and SQL2005 again and unfotunately the problem existes.

please someone helps me (just don't tell me to format my PC!!!)

tnx

It looks like BIDS is trying to open a project/package that does not exists anymore. The weird thing is that when that happens BIDS prompts you to remove the invalid references and the error goes away. Don't you see that message?

Can you do File->Close solution/project ?

BTW, that error should not prevent you from using BIDS.

as a good practice always use close solution/project before closing BIDS. This is because BIDS always tries to re-open all projects and packages that were opend at the time of exiting.

|||Dear Rafael,

Many thanks for your response.
but my i want to Create/Edit DTS packages in BIDS and i cant.
my VS Net 2005 works properly.
my problem is creating or editing SSIS packages in BIDS.
even in new SSIS project when i add new SSIS packages or existing packages (dtsx) my BIDS doesn't show its designer and shows same error.

i think it cant find SSIS DTS base class or its references for showing SSIS designer.|||It looks like an installation issue to me. Try re-installing the client tools to see if BIDS gets fixed.|||

I second that, it's likely a setup issue. Pls try to confirm for example whether "dts.dll" is under your \Program Files\Microsoft SQL Server\90\DTS\Binn to see whether you did encounter a setup issue and if yes, reinstall Integration Service from SQL Server Work Station Components to see whether that helps.

Thanks

|||

Pejman - do you any have third party Visual Studio add-ins installed?

Also, try installing SQL Server 2005 SP2.

|||dear , thanks for your responses.
i agree with you.its an installation problem but after re-installing the problem was exist.
i think my its because of Windows Registry!!|||Dear Friend,
"dts.dll" file exist in the SQL path as you said.
also i reinstaling SSIS and some workstation components.
but the same problem !!!
also it can't open SSIS samples.|||Dear Michael,
yes, i had some VS add-ins and i remove them.
and again reinstalling SQL server developer and the problem exist.
soon i will download SQL2005 SP2 and inform you.

TNX|||Hello Dear All,

finally i solved the problem.

i installed MSSQL 2000 Personal Edition on my computer then my SSIS problem is now solved.

thanks all of you.

Can't Install Integration Services on SQL 2005 (Windows Server 2003)

Hello - We have been unable to successfully install Integration Services with an instance of SQL 2005 running on a Windows Small Business Server 2003. Installation proceeds with no errors, but when you attempt to connect to the Integrations Services and browse to where it apparently exists, the SQL Server Managment Studio returns the following error:

TITLE: Connect to Server

Cannot connect to ABDI04.

ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "ABDI04" failed:
The specified service does not exist as an installed service.
.

Connect to SSIS Service on machine "ABDI04" failed:
The specified service does not exist as an installed service.
.

BUTTONS:

OK

We have tried uninstalling the Integration Services, then reinstalling it and again applying SP2 with the same results.

Thank you.

did you check in the sql server configuration manager? were you able to view the SSIS service there?if yes, is the service started ? ? ?if not just start the services and try to logon

also did you check in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt file if the installation was successful ? ? ?

|||

Hello Deepak -

I am not able to view SSIS in configuration manager and the service is not present with the other system services. Using your suggestion, I also verified the Summary txt file:

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 2 (Build 3790)
Time : Sat Jul 14 15:57:47 2007
ABDI04 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
Machine : ABDI04
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_SQLSupport_1.log
--
Machine : ABDI04
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_SQLNCLI_1.log
--
Machine : ABDI04
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_OWC11_1.log
--
Machine : ABDI04
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.2004
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_BackwardsCompat_1.log
--
Machine : ABDI04
Product : MSXML 6.0 Parser
Product Version : 6.10.1129.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_MSXML6_1.log
--
Machine : ABDI04
Product : Microsoft SQL Server 2005 Integration Services
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_DTS.log
--
Setup succeeded with the installation, inspect the log file completely for status on all the components.

Time : Sat Jul 14 16:03:43 2007

and it seems to confirm that the installation proceeded to a successful conclusion.

Do you have any other suggestions? Thank you very much - Bryan

|||Hi,

look if the "SQL Server Integration Services" is installed. If not, which version of SQL Server are you running on the machine (Therefore examine the "SQL Server (InstanceNamehere)" services mentioned in the SCM.

Jens K. Suessmeyer.

-
http:://www.sqlserver2005.de
-|||Hello,

we have exactly the same problem. We installed completely new installation of SQL 2005 Server to a new installation of Small Business 2003. We ensured that the "Integration Services" option in the installation was set to "install entirely" mark. After no error reported installation we found out that the "SSIS Service" is not present among the system services, not even in the SQL configuration manager services.

However, the installation log file reports:

Product : Microsoft SQL Server 2005 Integration Services
Product Version : 9.00.1399.06
Install : Successful

Of course, we are not able to connect or using the Integration services. So, the question is, how can we install the Integration Service into the system?

Can anyone help?
|||Is the service started ? Can be found in the Service control manager (SCM) in Windows.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||Well, as I said, the service did NOT install into the system. (We checked both the Windows System Services and SQL Service control manager). So the answer is NO, the service is not started (because is not installed).

Jonas
|||One more thing: could anyone provide us the information, what executable file is related to SSIS servise to launch (with the the proper command line switches, if any)?

We would like to locate this executable on the drive and try to launch it manually.

thanks