December 6, 2012 at 8:21 am
I finally was able to attach the Adventure Works database. Thank you for your help! 🙂
My next question is that if I downloaded Visual Studio 2008 Express Edition, will I be able to create reports from queries I created in SQL Server 2008 Express Edition? If so, which option should I select?
Still trying to learn this. Thank your for your help and patience.
December 6, 2012 at 11:28 am
Hi, for report development you need BIDS (Business Intelligence Development Studio) which is based on Visual Studio Shell.
It can be installed as part of the SQL Server installation if you have SQL Express with Advanced Services.
Cheers
Gaz
December 6, 2012 at 12:06 pm
I'm pretty sure I installed everything possible in SQL Express. So does that mean I need to install Visual Studio Express to get BIDS?
Thank you
December 6, 2012 at 12:10 pm
No, it's a standalone product. If it's installed it will be in the SQL Server 2008 (or 2008 R2 if you're using that) folder on your start menu as "SQL Server Business Intelligence Development Studio"
December 6, 2012 at 2:38 pm
It's not installed, because I don't see it anywhere. Where can I get it?
December 7, 2012 at 2:54 am
If you've got SQL Express with Advanced Services it's included.
To check you have this version - your install file should be called SQLEXPRADV_x64_ENU.exe or SQLEXPRADV_x86_ENU.exe
In the SQL installer, it's listed as Business Intelligence Development Studio in the Shared Features section of the Feature Selection page.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply