Solved

SQL Server Reporting

Posted on 2014-01-20
6
368 Views
Last Modified: 2014-01-21
I have installed SQL Server 2008 R2  on my home computer and do not see the Business Intelligence Development Studio in the list when I open the folder.  what do I need to do to get the Business Intelligence Development Studio to display in the list.  I want to do development using SQL Server Reporting Services.   Do I need Visual Studio 2012 installed?
0
Comment
Question by:donnie91910
  • 3
  • 2
6 Comments
 
LVL 12

Assisted Solution

by:Koen Van Wielink
Koen Van Wielink earned 375 total points
ID: 39796279
If you installed the right options, the installation should have added VS 2008 to your system as well. This is the environment where you can develop the reports.
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 125 total points
ID: 39796357
BIDS doesn't ship with all editions, which one did you install?  Ow, and did you see it in the item list during one of the first steps in the installation?

Ref Features Supported by the Editions of SQL Server 2008 R2
0
 

Author Comment

by:donnie91910
ID: 39798315
I installed the SQL Server 2008 R2 Express version.  Is there any way to get the other versions with the Business Intelligence Development Studio for free?  Please send me the link.  Thanks.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 12

Assisted Solution

by:Koen Van Wielink
Koen Van Wielink earned 375 total points
ID: 39798924
If you compare the different editions of 2008R2 you can check if the one you're using includes the tools you need:

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).ASPX

If you check under development tools you'll see that if you have Express with Advanced services the BIDS is included:

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).ASPX#Dev_tools

The standard "Express" and "Express with tools" versions do not include BIDS.
0
 
LVL 12

Accepted Solution

by:
Koen Van Wielink earned 375 total points
ID: 39798928
Download link for Express SP1, including advanced services:

http://www.microsoft.com/en-us/download/details.aspx?id=26729
0
 

Author Closing Comment

by:donnie91910
ID: 39799141
Thanks it worked perfect
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

I have a Synology DS212+ NAS.  These are not only great for backup and normal NAS stuff, but also for delivering media throughout your home or LAN via DLNA.  I copied my whole audio collection from iTunes over to the box, but couldn't figure out how…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video will demonstrate how to customize windows, tools, and control bars, and save them as screen sets. Open and resize windows: Customize the toolbar: Customize the control bar: Customize your tool selections: Your screen set is alread…
Viewers will learn the basics of making and using Impulse Kits in Ableton Live. Load new Impulse into an empty MIDI track: Fill the 8 empty sample slots with drum samples: Adjust parameters to tailor each sound as desired: Proceed to create be…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now