I recently installed Visual Studio 2008 on my main development computer and have been very happy with it overall. However, before starting the installation, I decided to remove all of the Visual Studio 2005 components from my computer. Overall, this was a good idea (VS 2008 is backwards-compatible), but I found out that it broke my ability to launch the Business Intelligence Development Studio (the primary tool for creating, among other things, SQL Server Reporting Services projects). One solution would be to re-run the SQL Server 2005 setup, but I didn’t want to go through the time and trouble.
Fortunately, it looks like there’s a better way… This MSDN Thread outlines a great response from Dan Jones:
You should make sure that Visual Studio is still installed. If you didn’t previously have VS installed, the BI Dev Studio installation will install a VS shell called Visual Studio Premier Partner Edition. Look in Add or Remove Programs for an entry like this. If you don’t find any entry for Visual Studio go to the location for SQL Server setup and run .\Tools\Setup\vs_setup.exe. This will install the VS Shell. After this is installed repair the BI Studio installation by running the following from the command line from the .\Tools directory: start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS
After running both commands, I’m back up and running properly. Hopefully, this “gotcha” will be better documented at some point (perhaps in an official Knowledge Base article?). For now, though it should get you back up and running within about 10 minutes. Note that you’ll want to run Microsoft Update to install the Visual Studio SP1 updates on your computer.
Update: If you’re looking for information on SQL Server 2008 R2 and Report Builder 3.0, please see my newer post SQL Server 2008 R2 Report Builder 3.0 (RTM).
#1 by Kamarish on December 13, 2007 - 12:56 am
Quote
Hello,
I have a problem regarding the installation of the BI Dev Studio. I mean I have problems running it. I have never used it before and so dont know how to bring it up and running. Please help me to start a project in BI Dev Studio.
Right now in the template area of the File | New | Project it shows only Blank Solution, but I guess it should show “Analysis Services Project”.
Please help to figure out this.
Thanks in advance,
-Kamarish
#2 by Anil Desai on December 13, 2007 - 8:36 am
Quote
Kamarish: This definitely can be confusing. The Business Intelligence Dev Studio (BIDS) is installed automatically if you choose to install Analysis Services, Reporting Services, and Workstation Components when you’re installing SQL Server 2005. It is based on Visual Studio 2005. If you don’t have the full product installed, SQL Server 2005 will automatically install what it needs. When you attempt to create a new project in VS 2005, you should see a section called Business Intelligence Projects. Within that are the templates for building AS and SSRS projects. Based on the problem you mentioned, I think you’ll need to reinstall SQL Server 2005. Be sure to check the Workstation Components section to see if anything is not included. Good luck!
#3 by Simon on January 10, 2008 - 7:45 am
Quote
Hi there,
I have no BI projects in the list when i create a new project in VS2008. I Dan’s instructions but still nothing in VS2008. Can you confirm that the BI dev studio works in vs2008 using SQL 2005.
Many thanks
Simon
#4 by Anil Desai on January 10, 2008 - 9:10 am
Quote
Simon – Actually, VS2008 does not support the creation or modification of Reporting Services projects. That’s why you’ll need to reinstall the VS 2005 components using the SQL Server 2005 setup process. After you do that, you’ll have a program group and shortcut in your Start menu for Visual Studio 2005. That version will have a project type of “Business Intelligence Projects” which includes Reporting Services and Analysis Services project types. A worse problem is that VS2008 will appear to convert your Reporting Services project, but the reports themselves will not be included. A much better approach would have been for the Project Conversion Wizard to state the incompatibility.
This approach is kind of painful, but it looks like it’s necessary to have both versions installed side-by-side. Of course, SQL Server 2008 will be compatible with VS2008 (and will offer more integration features). Until then, you’ll be stuck with this intermediate method of having both versions of the Visual Studio installed on the system. Let me know if you have any further questions.
#5 by Simon on January 10, 2008 - 9:43 am
Quote
Thanks for your informative and rapid response!
I had been running 2003 and 2005 side by side for a while so its no additional hassle really. Our recent migration from sourcesafe to team explorer (a very welcome change) promted us to move to VS2008, just thought it would be nice if i could finally have the reports projects and the application in the same enviroment. I hope the move from SQL2005 to SQL2008 wont be as painstaking as 2000 to 2005!
Thanks again
#6 by Anil Semwal on January 24, 2008 - 3:47 am
Quote
Thankyou very much. This helped me a lot. You need to include Workstation Components from SQL Server 2005 Setup to get BI Studio
#7 by Archan on March 18, 2008 - 7:55 am
Quote
Thanks Anil, this really helped me.But VS 2008 should support SQL 2005 BI as SQL BI is used by people world over.
Archan
#8 by Eric on March 19, 2008 - 12:21 pm
Quote
Wow…. This is by far the most frustrating situation I’ve ever come across. I had a previous SQL2005 personal edition set on my development machine for the management studio to get to my main DBS. Now were developing models under BIDS, and I have a developer edition. But.. for the life of all holy, I cannot get BIDS to install on a full install of the developer. I had to manually install the VS2005, as pointed out above, but installing the workstation components yields no BIDS, or project availability in VS2005.
#9 by Christian Espinoza on March 24, 2008 - 11:02 am
Quote
I was recently wondering if the BI Studio was available in Visual Studio 2008, so many thanks for the clarification, Anil!
#10 by Charis on April 24, 2008 - 6:51 pm
Quote
I first installed VS2008. Then I installed SQL Server 2005 Developer Edition and it installed the essential for BI VS2005 components. Everything works fine.
#11 by william s on May 7, 2008 - 3:16 pm
Quote
I recently installed sql standard 2005 on my vs 2008.
using vista. My problem is this now I have a copy of vs 2005
on my computer(does not work) and business intelligence
development (does not work) How do I fix this?
I am mad because I spent a month trying to understand
everything on sql reporting services, install issue
and now I find business intelligence development studio
doesnt’ work please give some advice Thanks
#12 by Anil Desai on May 7, 2008 - 4:00 pm
Quote
William – I’m not sure exactly wehat you mean by “does not work”, and therefore can’t provide any specific troubleshooting steps. I recommend you post details on the Microsoft Technical Communities site/forums/newsgroup (http://www.microsoft.com/communities/default.mspx). Include information about what you tried and what isn’t working properly. Good luck!
#13 by Jay on May 12, 2008 - 5:47 pm
Quote
Thanks very much to you (and Dan) for your post. It was only third down in the listed (thankfully!!!) when I googled this topic today.
Cheers!
#14 by william s on May 19, 2008 - 2:50 pm
Quote
I do apologize I did install vs 2005 and vs 2008 along with sql 2005 reporting services. I just installed sql_tools.msi twice then installed updates,
it is working now
#15 by codeWhitler on May 24, 2008 - 2:46 pm
Quote
In fact vs_setup on my SQL Server 2005 Devloper edition is called vs_setup.msi. It isn’t found in the same directory either. However it does work and when I checked the short cut the VS 2005 initialized the pre-existing installation of BIDS. Well I am happy with that, but I do agree with those who believe that the shouldn’t have to run 2 x IDE to get Analysis services.
Apropo why isn’t the VSX team involved as VS extensibility would permit creating an Integrated toolset with DIBS to install into VS 2008? In other words grab the PrivateAssemblies for DIBS and make an install for VS 2008 Integrated? Am I off the mark here? I just downloaded the SDK 1.0 so I have yet to check the feasibility of what I am proposing. Certainly there are many who have the VS 2008 pro edition who would like the fix to the 2008 IDE rather than the work-around using VS 2005.
#16 by Ted on June 3, 2008 - 2:42 am
Quote
Thanks a lot, this post also work for me as well.
#17 by Jayaram Krishnaswamy on July 11, 2008 - 3:11 pm
Quote
2005: The BIDS 2005 and VS 2005 appeared to be different with BIDS supporting SSIS,SSAS and SSRS
2008:There appears to be no difference between the two. Is it because SQL Server 2008 is still in RC0?
#18 by Howard on August 1, 2008 - 6:03 am
Quote
This saved my day, thanks a lot!
#19 by Phil on September 13, 2008 - 3:38 am
Quote
Thanks very much, this worked for me too. Very surprising to me that VS2008 doesn’t support SQL 2005 Reporting.
Running the VS_Setup.msi was a bit misleading. It runs without a visual interface until it’s completed, so the first time I tried it I ended up trying to run it multiple times. You can see the msiexec processes in task manager though.
#20 by Sam on October 9, 2008 - 10:25 pm
Quote
Thank you very much, it works perfectly and resolved my problem in 5 mins!
#21 by Venkat Venkataramanan on October 21, 2008 - 3:26 pm
Quote
Dear Anil:
I seek your help in resolving an issue I have with installing BI Dev Studio.
I recently bought a new desktop. I installed the different programs in the following order:
1. Windows 2008 Server – 64-bit version
2. Microsoft Office 2008 Ultimate
3. Visual Studio 2008 Developer
4. SQL Server 2008 – 64-bit Enterprise Edition
All components but BI Dev Studio got installed. I’ve tried to add BI Dev Studio to the existing installation and it keeps failing.
From reading the threads, I see that BI Dev Studio may depend on some components of VS 2005 and since I never installed VS 2005 on this machine, that could be the reason for the failure.
Can you please let me know how I can install BI Dev Studio?
Thanks a lot.
Venki
#22 by Anil Desai on October 21, 2008 - 4:12 pm
Quote
Venki:
It looks like you might be in the same situation I was in when I originally worte the post, but I’m not sure. If you plan to create and publish reports for SQL Server 2008 Reporting Services, you’ll need to download and install the Report Builder. It’s a separate download for creating reports, but it’s not compatible with the SSRS 2005 RDL format.
If, on the other hand, you need to develop or deploy reports for SSRS 2005, you can follow the instructions in my original post. All you need to install is the Business Intelligence Development Studio. This is actually installed by using the SQL Server 2005 setup process. You will then need to run the commands in the quote from the post. I hope this is helpful!
#23 by Venkat Venkataramanan on October 22, 2008 - 5:08 pm
Quote
Anil:
Not quite. I do have 64-bit Windows 2008 Server up and running fine. I also have VS 2008 SP1 working. And, all components of SQL Server 2008 enterprise, except BI Dev Studio, working.
Venki
#24 by Angela on November 27, 2008 - 5:51 am
Quote
I am a recruiter considering going into IT DBA. I started preparing for the MCTS certification exam, am I on the right track?
#25 by Anil Desai on November 27, 2008 - 5:26 pm
Quote
Angela – Without knowing your specific interests and goals, the MCTS does sound like a reasonable starting point. When dealing with databases, there are two major areas (though the line has become far more blurry). On the IT / Administration side, you’d be responsible for maintaining databases and servers and managing reliability, performance, uptime, etc. On the development side, you’d be more focused on support software development. People seem to use the term DBA to refer to either. Personally, I like working on both sides of databases and I used it to move from systems administration to development several years ago. I hope this is helpful. Good luck!
– Anil
#26 by Angela on November 28, 2008 - 12:19 pm
Quote
Anil – Thanks, I appreciate your response. I have one more question – I am currently interested in Database administration. I hope in the future to move into software development. How easy is it to find a job, if I can pass the certification courses, even though I do not have any working experience? Is there a right way for a newbie to approach job-search?
#27 by Anil Desai on December 1, 2008 - 8:27 am
Quote
Angela – The job market for IT pros seems to be rather volatile (think of the dot-com days and following “correction”), but I think the general trend is towards increasing opportunities for qualified technical professionals. The specific market varies significantly by areas of specialization, geography, and (of course) the overall economy. Unfortunately, I don’t have any more specific advice than that. You might want to look at salary surveys and related new stories from many different IT publications.
As far as the “right” way to approach a job search, I can provide one piece of advice: Focus on the value that you would add to a potential employer. Technical skills are a pre-requisite, but many employers will prefer those candidates that can communicate well, have strong analysis skills, and can generally work as part of an overall business team.
– Anil
#28 by Phil Wells on December 1, 2008 - 9:37 am
Quote
Venkat
I’m having exactly the same problem as you, except I’m installing the Express versions of Visual Studio 2008 for VB.NET and SQL Server 2008. Installed VS first, then SQL Server, and everything installed successfully except BIDS. Did you ever figure out what the problem was?
Phil
#29 by David Frazier on January 7, 2009 - 9:07 am
Quote
I agree that getting BIDS to install as expected with SQL Server 2005 is very frustrating. (One might also add “mystifying”, “obfuscated”, “klunky” ….)
I’m pursuing the MCTS/MCITP certification (i.e. series 70-445, 70-446) in the SQL Server 2005 BI competency. Accordingly, I bought the required training kit, which comes with SQL Server 2005 (180-day evaluation).
After many attempts on two separate machines, still no BIDS functionality. >:(
Last night I downloaded the VS2008 trial iso (all 3+ gig — with no BitTorrent).
These postings have given me some possible avenues for getting this all resolved. I’ll let y’all know how things turn out, but I think one or two MS product managers need to have their feet held to the fire to improve this situation.
(BTW, to help put this in context, working with open source tools — Eclipse/Jave, etc.is a joy compared to this morass.)
#30 by Kent Wallace on January 8, 2009 - 10:44 am
Quote
I have installed VS 2008 and SQL 2005 developer developer addition. I have no BI ssis tools in VS 2008 new projects. How do I get them installed?
#31 by Anil Desai on January 8, 2009 - 11:39 am
Quote
Kent: It looks like you’re on the right track, but you’ll still have to launch Visual Studio 2005 to create and work with the BI projects. It’s a hassle to keep both around (and to have to launch different versions of VS 2008), but it should work just fine. I’m doing exactly that, until I can get some of my clients to upgrade to SSRS 2008.
#32 by David Frazier on January 9, 2009 - 11:31 am
Quote
Thanks to this thread it appears that I was able to resolve my issue.
My situation is pretty much “plain vanilla” — new P4/XP SP2 box with no complications.
The key was to run vs_setup.msi from .\Tools\Setup on the installation media. (Remember that the setup doesn’t create any GUI activity.)
This is all helpful information. Thanks.
Pingback: Business Intelligence Projects in VS 2008 | keyongtech
#33 by sunanda on January 21, 2009 - 1:14 pm
Quote
I am creating Reports in Business Intelligence- in that Reports they are asking me date ranges I am doing with Query between @StartDate and @EndDate tie up with Created Date column is there any way not binding to the field can I create date ranges ex calender to select their own dates but not binding to table field?
please have the answer.
great thanks
#34 by sunanda on January 21, 2009 - 1:16 pm
Quote
I am creating Reports in Business Intelligence- in that Reports they are asking me date ranges I am doing with Query between @StartDate and @EndDate tie up with Created Date column is there any way not binding to the field can I create date ranges ex calender to select their own dates but not binding to table field?
please have the answer.
great thanks
#35 by Anil Desai on January 21, 2009 - 2:26 pm
Quote
Sunanda,
I’m not sure I understand what you’re trying to do. Assuming you have two report parameters, @StartDate and @EndDate; and a query that uses these parameters in the WHERE clause of one of your dataset queries, you should be all set. If you’d like the StartDate and EndDate parameters to be data-driven (for example, a drop-down list of valid dates), you can configure the report parameters to use the results of a query. I hope that helps!
– Anil
#36 by skaugen on March 12, 2009 - 4:31 pm
Quote
When I run sqlrun_tools.msi to set up SQL Server 2005 Tools Setup, it give me the error message:
A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component.
I am totally lost here. Can anyone help? I was trying to have the BI development show on my VS 2005 or VS 2008.
#37 by Ken Greenwald on April 1, 2009 - 1:20 pm
Quote
Is it possible to use Reporting Services on a Windows 7 system with VS 2008 express and SQL Server Express 2008?
#38 by kiran kumar on June 17, 2009 - 10:16 am
Quote
hi,
I have installed visual studio 2008 and sql server 2005.I am unable to open Business Intelligence Development Studio.Can u please help out.
#39 by Ansar on June 21, 2009 - 8:18 am
Quote
Hi,
I want to create reports in VS 2008 by using Business intellgence Services but, I am not getting it . I have SQL 2005 and VS 2005 installed in my PC.
Can any one help me to get out of this problem…….
#40 by Sandeep Kumar on July 14, 2009 - 8:59 am
Quote
Visual studio 2005 and sql server 2005 are already installed. I later installed visual studio 2008 but the BIDS is not available in VS2008. I tried the above mentioned solution, but it does not seem to affect VS2008. I still cannot see the BIDS in VS2008.
Any advise would be appreciated.
#41 by Anil Desai on July 14, 2009 - 9:36 am
Quote
Sandeep: My best guess is that you haven’t installed SQL Server 2008 on your computer. As part of the setup process, you should have the ability to update the client tools (which includes BIDS for SQL Server 2008). Also, be sure to install the Service Pack for SQL Server 2008. If you don’t need the ability to create Visual Studio projects for reporting purposes, consider installing SQL Server Report Builder 2.0. It provides the same basic functionality, but lacks the ability to integrate with source control, to deploy numerous reports automatically, etc. I hope this helps!
– Anil
#42 by TobiasP on July 14, 2009 - 11:01 am
Quote
It seems you can’t open SSRS 2005 project in VS 2008?
There is the “non-solution” (Read the answer of Craig Guyer):
Next:
Sad but true. 🙁
#43 by Sandeep Kumar on July 14, 2009 - 11:36 am
Quote
Anil,
Thanks for your response. is there any way for converting report project from VS2008 to VS2005 version..?
#44 by Anil Desai on July 14, 2009 - 11:42 am
Quote
Sameer: You’re welcome. There’s no automated way to “downgrade” your report formats. By default, the upgrade process in VS 2008 will make a backup of your original reports and the project itself. If you need to go back (or maintain both versions), you’ll need to it manually.
#45 by Shelley B on July 22, 2009 - 8:14 pm
Quote
I have not installed anything yet and thought I would ask before I do. If I installed
SQL Server 2005 Express with Advanced Services SP1 and Visual Studio 2008, would I be able to use Business Intelligence? OR … do I also have to install Visual Studio 2005 Express? I have been told by my IS department that BIS must be installed on the Server to work correctly. I don’t know if I agree.
PLEASE HELP!! What do I need to install and in what order to get this to work? I am just an business analyst who has a lot of reports to do In Visual Studio … not a computer guru. THANK YOU!!
#46 by Anil Desai on July 23, 2009 - 9:41 am
Quote
Shelley: Good questions (and good evidence for how confusing all of this can be). First, the BIDS component is installed as part of the SQL Server installation (not part of Visual Studio). If you want to have support for projects, source control, etc., then you should choose the option to install the Workstation Components during the SQL Server installation. If you don’t need those features, just download and install SQL Server Report Builder 2.0. It runs as a stand-alone application and it allows you to edit and publish report files to an SSRS server.
BIDS should not be necessary on the server, and it might be recommendable to not install it for security reasons. If you’re looking to install SSRS, just choose the option to install Reporting Services on the computer. In SQL Server 2008, you don’t even need to have IIS (the Web Server role) installed or enabled. The only reason you should need BIDS on the server is if you plan to do development work directly on that machine (again, not a good idea from a security standpoint).
I hope this is helpful and that it gets you on track to doing your “real” job. 🙂
#47 by Raj on August 4, 2009 - 5:13 am
Quote
Hi All, I have uninstalled SQL server 2005 and installed Sql server 2008 and visual studio 2008. I am not able to open the BI projects which are created with SQL server 2005 ie Visual studio 2005. It supposed to open automatically and covert to visual studio 2008 SSIS. Some how i lost my settings and not able to view the Visual studio 2005 BI projects. Can you please guide me.
Thanks
Raj
#48 by Anil Desai on August 4, 2009 - 9:09 am
Quote
Raj: I’m not sure I understand your situation, but if you’re referring to SSRS (Reporting Services) projects, you should be able to open and convert them using Visual Studio 2008 SP1. You can also manually create a new SSRS reporting project and import the new reports into it. I hope this helps.
#49 by Michael on October 23, 2009 - 1:04 am
Quote
I work for a large corporation where many instances of MSSQL Server 2005 and 2008 are running. I want to develop using BIDS.
Is it necessary to install an instance of MSSQL Server on my local machine to use BIDS? If not, how do I install BIDS without MSSQL Server?
#50 by Anil Desai on October 23, 2009 - 8:07 am
Quote
Michael: BIDS is part of the SQL Server 2005 / 2008 installation process. You don’t need to install the MSSQL Server Service (the database engine) in order to have these tools. Just choose to install the Workstation Components, and you’ll get access to BIDS, SQL Server Management Studio, and related tools. To start the process, just use the SQL Server installation media (for any edition) and choose just the options you want. I hope his helps.
#51 by Bill Hertzing on November 5, 2009 - 2:12 pm
Quote
I have SQL Server 2008 installed, and had VS 2008 installed, on Windows 7. I removed VS 2008 and Installed VS 2010 Beta 2. Looks like I no longer have BIDS (Windows 7 reported that the shortcut to BIDS no longer points to the .exe, the path had a “9.0” in it, and I’m assuming the VS2008 uninstall removed the entire 9.0 directroy tree).
Do you have any suggestions on the best way to reinstall the BIDS functions with VS 2010 Beta 2?
#52 by Anil Desai on November 5, 2009 - 3:31 pm
Quote
Bill: If you’re primarily looking for an environment to support current versions of SSRS (e.g., SQL Server 2008), I recommend downloading SQL Server Report Builder 2.0. Or, you can install VS 2008 SP1. If you have the need to support SSRS 2005 or earlier, you should probably reinstall the relevant version of SQL Server and choose to include only the “Workstation Components” option. This should get you backup up and running with BIDS. I have installed VS 2010 Beta 2 on a test computer, but I didn’t have any other development tools installed before that, so I’m not sure whether it automatically removes anything. I hope this is helpful!
#53 by Richard Shepherd on November 5, 2009 - 4:36 pm
Quote
I am interested in working with BIDS so I installed SQL Server 2008 Express but I’m not sure that was what I needed. Does this include reporting services and analysis services? I don’t see any trace of analysis services but an MS wbe site implies it’s all included in SQL Server 2008.
Bottome line do you know what I should download which would include BIDS, analysis services, reporting services & sql server 2008?
Thanks!
#54 by Anil Desai on November 6, 2009 - 8:24 am
Quote
Richard: If you’re planning to create and edit reports for SSRS 2008, you should download and install Report Builder 2.0: http://www.microsoft.com/downloads/details.aspx?FamilyID=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en. This standalone product will let you create local reports and/or connect to a remote SQL Server 2008 SSRS instance for deployment. If you want to setup your local machine as an SSRS server, you can download SQL Server 2008 Express Runtime with Advanced Services. See http://www.microsoft.com/express/sql/download/ for details. I hope this helps!
#55 by Bill Hertzing on November 6, 2009 - 12:50 pm
Quote
Anil, thank you very much for your interesting blogs and the time you take to respond to comments. I cerainly appreciate folks like yo uwho take the time to help out others! My primary interest in BIDS (this week ) is for the SSIP stuff (Integration Services). I will continue to investigate other ways to get the BIDS services reinstalled and running under VS2010 (probably will uninstall VS2010, uninstall SQL 2008, reinstall SQL2008 (which should get BIDS back), then reinstall VS2010 Beta 2. Hopefully the 2010 reinstall won’t wipe out the BIDS stuff if I do it in that order.
I tried using SSRS about 18 months ago, and had problems getting it to visualize the datasets my StoredProcedures put out. In fact, I still have not found a visualization tool that I like. I’m writing SPs for analysis of massive amounts of click-stream data, and need a powerfull UI to let users select/contrast/compare this data segmented by lots of dimensions. Perhaps I’ll give SSRS another look, once I get my SSIP issues resolved. Thanks again!
#56 by Andrew on November 12, 2009 - 6:12 pm
Quote
Over time, I installed the following (in order) on my XP machine: VS 2003, VS 2005, SQL Server Express, and VS 2008 (All VS versions are Developer versions). Then I wanted to install SQL Server 2005 so I could use Reporting Services. After I installed SQL Server 2005, I found that there were several problems with the install (I believe this was caused by confusion with the Express version that was already installed). I did my best to uninstall Express and SQL Server 2005. Then I installed SQL Server 2005 again and I believe it installed cleanly this time. (Side note: Even though I already had 3 versions of VS installed, I still had a VS Premier Partner Edition entry in my Add/Remove Programs list.) I then wanted to run the BIDS but I could not find it in the Start – Programs menu. I tried installing the SQL Server 2005 Express Edition Toolkit and it indicated that BIDS is already installed. I also tried the 2 commands by Dan Jones but I still cannot find the BIDS. Do you have any idea of what I need to do to get access to the BIDS? Thank you very much for any help you can give me.
#57 by Anil Desai on November 13, 2009 - 9:08 am
Quote
Andrew: It does sound like you might have BIDS installed on the computer. One way to search for this is to open up the relevant version of Visual Studio (in this case, VS 2005, I believe), and choose to create a new project. If you see “Business Intelligence” as a project type, you should be able to create a new Reporting Services project and/or open an existing one. The icon really just launches the Visual Studio shell. Of course, another option is to move your project to SQL Server 2008 / Visual Studio 2008 or to use Report Builder to create and edit reports. I hope this is helpful!
#58 by Gomathi on November 13, 2009 - 9:42 pm
Quote
Hi Anil,
I am also running into the same problem. Could you please help me out.
I have installed VS 2008, this installed SQL Server 2005 express edition. I then installed all the features provided by Advance services of SQL Server 2005 express edition (including client reporting services and client components). I wanted Business Intelligence Development system, so I was trying to install the tookit for express edition. It said thier is nothing that need to be installed.
I opened VS 2008 new project and I dont see the Business Intelligence Project Type.
Could you please suggest a solution??
Thanks
#59 by Anil Desai on November 14, 2009 - 8:11 pm
Quote
Gomathi: From what you’ve described, I think you need to install the Workstation Components for SQL Server 2005 or SQL Server 2008. This is what adds the BIDS options to Visual Studio. Alternatively, you can use the tools that are included with the Express versions of SQL Server (I’m not familiar with these). Or, if you’re on SQL Server 2008, you should be able to install Report Builder 2.0. You won’t have the ability to create or edit Reporting Services projects, but you will be able to create and edit reports. I hope this helps! – Anil
#60 by Sandy on December 28, 2009 - 1:28 pm
Quote
We have SQL Server 2000 and SQL Server 2005. Currently the only thing on the 2005 server is SharePoint 2007. We plan to upgrade the 2000 server to 2005. We don’t have any versions of Visual Studio but I’m taking some courses and hopefully will be using it to develope some applications. I have several questions. We do plan on upgrading to SQL 2008 at some point.
1. Since we don’t have any versions of VS, which version should I purchase?
2. If I understand what has been stated in the comments, then I should make sure the Workstation Components are installed on SQL Server 2005.
3. Is it better to develope applications using BIDS or Visual Studio 2008? Do they both work hand in hand?
I’m sure there will be other questions. This is a little about myself, just to let you know my experience level.
I do mostly report writing using Crystal Reports but since we have no programmers employed, I’m trying to gain enough SharePoint and Visual Studio experience to build some custom applications and deploy them to run in SharePoint. I do know enough about TSQL to build some scripts.
Thanks
Sandy
#61 by Anil Desai on December 28, 2009 - 3:04 pm
Quote
Sandy: These are good questions. Ideally, you’d be able to upgrade your servers to SQL Server 2008, and then you could use BIDS and/or Visual Studio 2008 for all of your development. Assuming you’re unable to upgrade your servers, you should already be licensed to install the Workstation Tools from SQL 2005 on your development computers (please verify with your licensing agreement if you’re unsure). This will install BIDS using the VS 2005 shell, and will allow you to develop reports on SSRS 2005. Just a note on your question #2: You probably want to install the Workstation Components on your development workstations, not on the server (though both options are supported).
Regarding question #3: For developing reports on SQL Server 2008, you’ll need to use Visual Studio 2008 or Report Builder. The latter is primarily designed for use by report designers/developers that don’t need source control, projects, etc. The report editing functionality is almost identical, but VS 2008 adds support for working in teams, etc.
I hope this is helpful. If not, feel free to follow up here. – Anil
#62 by rajani mayekar on February 6, 2010 - 1:45 am
Quote
how to install business intelligent in vb.net
#63 by Chad B on March 2, 2010 - 10:07 am
Quote
I want to thank you for sharing this information. Your instructions were of great help.
Just in case anyone else has my specific situation, I did not have to run the second command. I simply double-clicked the vs_setup.msi file located in the Setup folder of disc 2 of SQL 2005 Developer Edition.
Again, thank you and have a great day!
#64 by TJ on March 5, 2010 - 2:17 am
Quote
Getting BIDS to show up in VS 2008 can really be a pain, thanks to Anil and other posts, this solved my issue.
1- If you open VS studio 2008 / 2005 and don’t see BIDS project, it means you probably don’t have the components installed.
2-Instead of spending hours figuring out how to get the components, DO THIS!!!! DELETE YOUR SQL SERVER INSTANCE (I was runing SQL express 2008) THEN REINSTALL THE THE (DATABASE WITH ADVANCED SERVICES VERSION OF THE SQL EXPRESS 2008) that’s it, no reinstalling Visual stuido or anything, this did it for me after a nice headache, good luck…here is the link to download the SQL server with BIDS:
http://www.microsoft.com/express/Database/default.aspx