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 Dan Taylor on March 8, 2010 - 5:28 am
Quote
Really good thread!
I have SQL 2005 & BIDS working great with loads of SSRS reports being accessed.
I would like to modify the Report Viewer home page and all the navigation around the pages – like add logos and links etc…I suppose use ASP.net to house the reports
For this it seems i need to install Visual Studio 2005. Is it a simple matter of installing or will it have any impact on my existing SSRS reports & setup?
Is it a separate install to BIDS?
Any help most welcomed.
Thanks
#2 by Anil Desai on March 8, 2010 - 7:51 am
Quote
Dan: I’m glad you found this thread to be useful (it’s easily the most popular post on my blog). If you want to customize your Report Viewer page, one fairly simple way to do this is to create your own ASP.NET application and then use a Report Viewer control to make the reports available. You should be able to use any version of Visual Studio to create that project, as the Report Viewer control should be available by default. For more information, see http://msdn.microsoft.com/en-us/library/ms251671%28VS.80%29.aspx. I hope this helps!
– Anil
#3 by Dan Taylor on March 8, 2010 - 10:24 am
Quote
Thanks Anil – I picked up your help earlier and have since been looking at what you recommend.
I have installed Visual Studio Professional Edition & the BIDS components all still work OK which is useful.
+ Created a basic ASP.net web page a used the Report Viewer to show reports. It looks basic but opens up a new world!!!!
…It does do funny things when rendering tables & adds Scroll bars when not required….should prove fun trying to workaround 😉
Thanks Again
#4 by Sachin on March 9, 2010 - 12:00 am
Quote
Hi Anil,
I have experienced similar problem. But I couldn’t find the path which you have mentioned \Tools\Setup\vs_setup.exe. I m in urgent need of it. Please let me know to solve the issue.
#5 by Anil Desai on March 9, 2010 - 8:11 am
Quote
Sachin: I’m not sure why you’re unable to find that setup program, as it should be present on your SQL Server installation media. If the above process doesn’t work and you need access to BIDS, I recommend just re-running SQL Server setup and making sure that the “Workstation Components” are included in the installation. This should install the shell and the necessary components for creating report projects.
– Anil
#6 by sudhir on March 10, 2010 - 1:51 am
Quote
Hi
how to start with business intelligence and i intalled visualstudio 2008 professional edition in my local system. but iam not able to see the businessintelligence template .so please help me reagrding this issue .
#7 by Anil Desai on March 10, 2010 - 7:51 am
Quote
Sudhir: I think the above post and comments should answer your question. If you have a specific issue, feel free to post it here, in the comments.
#8 by Santos on March 17, 2010 - 12:33 pm
Quote
I couldn’t find the path which you have mentioned \Tools\Setup\vs_setup.exe. my dvd doesn’t have it. it has \Tools\Setup\vs_setup.msi is that it?
#9 by Anil Desai on March 18, 2010 - 7:53 am
Quote
Santos: It’s possible that there are different distribution media options for SQL Server and yours doesn’t have that path. I believe you need to run the executable (.exe) file but I’m not really sure if there’s another location for that file. My experience is with the MSDN versions of Visual Studio and SQL Server. Note that you can always just re-run SQL Server setup and choose the “Workstation Components” to get BIDS installed. I hope this is helpful! – Anil
#10 by Dan Taylor on March 31, 2010 - 8:08 am
Quote
Hi Anil.
Thanks Anil for you help – im now using the ‘Report Viewer’ component on a webpage & scroll bars have been sorted 😉
One change I have seen when using the ‘Report Viewer’ is that the server is around user access
Previously when a user accessed the report server pages (without the report viewer) – I could see an entry of their Windows User Ac in the Report Server DB (in the ExecutionLog table) – allowing me to view\monitor access.
When using ‘Report Viewer’ I can see an entry – but it is always the NT AUTHORITY\NETWORK SERVICE account.
(I cannot see who the user is)
Could you advise how I could see the users?
Thanks
#11 by Anil Desai on March 31, 2010 - 8:24 am
Quote
Dan: I’m glad to hear that you have this working (more or less). 🙂 The problem you’re seeing is based on the fact that your web server is logging into SSRS on behalf of the user. The authentication credentials used are those of the ASP.NET service (the default is “NETWORK SERVICE”), so this is all that SSRS can see. If you want to log details, you’ll need to either build your own method (for example, write to a log table whenever a user clicks a report link).
You should also be able to require the user to provide Windows Authentication credentials to the Report Server in order to access the reports. I believe you can pass credentials to the Report Viewer control using the object’s properties. Another option might be to disable SSRS access to the Network Service account. This might force SSRS to prompt the user for Windows Credentials. I hope this helps!
#12 by Dan Taylor on March 31, 2010 - 9:27 am
Quote
Thanks Anil,
I will investigate – I’m guessing the users would prefer not to request the window credentials each time 😉
Where will i get the user information to build the Log table? The ExecutionLog table in ReportServer DB … used to work great ;-(
Surely there is a control in the Report Viewer where i ask the credentials to be used?
Here’s hoping 😉
#13 by Anil Desai on March 31, 2010 - 11:51 am
Quote
Dan: Assuming all of your servers are running in the same domain, your ASP.NET web application would have access to the user’s credentials. I’m rusty on the exact syntax, but it would be easy enough to find. And your users shouldn’t be required to retype their passwords; if they’re in a domain, pass-through authentication should work (SSRS will automatically ask for the user’s credentials, and they’ll be sent by the browser). If this doesn’t help, it might be a good idea to post your questions to the appropriate Microsoft Technical Communities (http://www.microsoft.com/communities/default.mspx) group. My guess is that someone there would be able to give you some specific examples. – Anil
#14 by Dan Taylor on April 1, 2010 - 9:12 am
Quote
Thanks Anil,
I will take you advice & let you know how i get on.
Thanks, Dan.
#15 by Himani on April 5, 2010 - 4:25 am
Quote
Anil, I installed the VS 2005 premier partner edition. However, afterwards the BIDS shortcut started pointing to PE_verify.exe. I changed it to devenv.exe. The issue I am getting is some package load failure (designerpackage) while launching devenv.exe (vs 2005). I can see BIDS projects however get above error. There’s one more thing to point out: I can see vs_setup.exe in my sql server CD2 as well as VS 2005 CD. Could it be this that is causing load failures?
#16 by Omkar on January 30, 2012 - 6:37 am
Quote
I only hae Sql Server 2008 Management Studio installed on machine ,I dont have BIDS install on my machine.
Can you please fwd me the link for BIDS 2008.
#17 by Anil Desai on January 30, 2012 - 9:55 am
Quote
Omkar: I believe you’ll need to re-run SQL Server 2008 setup and choose to install the Workstation Components. Be sure to include the option for BIDS. I hope this helps. – Anil
#18 by Anil Desai on April 5, 2010 - 6:44 am
Quote
Himani: I’m not familiar with the PE_verify.exe issue, but a quick web search found this information: http://www.mztools.com/Articles/2007/MZ2007032.aspx. I’m not sure if it’s relevant, but it does sound likely that the problem is due to a Visual Studio add-in.
Other than the error message, it does sound like everything is configured properly. The vs_setup.exe on your VS 2005 media is for the full version of Visual Studio (which, of course, includes the Visual Studio shell). It’s part of the installation that also includes language and CLR support (VB.NET, C#, etc.) The version on the SQL Server media installs the VS shell and only the project types supported by BIDS. I hope this is helpful! – Anil
#19 by Dave on April 7, 2010 - 12:57 pm
Quote
Anil – Is it possible to download the vs_setup.exe from anywhere online? I seem to not have it on my SQl installation disks either…and it appears that this is why my BIDS is not showing even though a reinstallation of SQL shows it as already installed.
#20 by Anil Desai on April 8, 2010 - 8:39 am
Quote
Dave: I’m not aware of any other place to get the setup program other than the installation media. If you have an MSDN or Microsoft TechNet Plus subscription, you should be able to download the appropriate media from there. Or, you could try to snag a trial version of SQL Server / Visual Studio. The problem there is that the evaluation license would likely expire at some point. The best solution, of course, is to upgrade to SQL Server 2008 (if you can). – Anil
#21 by Jaikishen Jayadev on May 4, 2010 - 3:17 am
Quote
Hi Anil,
I am using MS SQL Server Management Studio 2008 and MS Visual Studio Team System 2008 for my projects.
I am learning SSIS and wanted to use BIDS. But I was not able to find it. Could you please advise as to how I can open BIDS? I dont have VS 2005 or SQL Server 2005 on my system.
Thanks,
Jay
#22 by Anil Desai on May 4, 2010 - 8:50 am
Quote
Jaikishen: If you have Visual Studio 2005 running on your system but you don’t see BIDS or the Business Intelligence project type options, the way to fix this is to re-run SQL Server 2005 Setup and choose to install the Workstation Components and Reporting Services. That should provide you with the correct project types. Alternatively, you can download the stand-alone Report Builder application from Microsoft. This should allow you to create, save, and modify reports without using the Visual Studio shell. I hope this helps!
– Anil
#23 by Jaikishen Jayadev on May 4, 2010 - 3:22 pm
Quote
Thanks Anil. But the thing is I am neither using SQL Server 2005 nor VS 2005. I am using VS 08 and MS SQL Server 08. Is it necessary to have even VS 05 installed if I dont want to go by the alternative method of downloading the report builder?
#24 by Jaikishen Jayadev on May 4, 2010 - 3:24 pm
Quote
And if I have to install SQL Server 2005 will the express edition work?
#25 by Anil Desai on May 4, 2010 - 3:27 pm
Quote
Jaikishen: That was my mistake – I mean to reference SQL 2008 and VS 2008 in my comment. I’m not sure what report development support is included in the Express editions. I’d recommend using Report Builder if you can. I hope this helps. If not, you might want to post your question in the appropriate Microsoft Technical Communities group. Perhaps someone else has the same configuration and can help. Good luck!
– Anil
Pingback: SQL Server 2008 R2 Report Builder 3.0 (RTM) | AnilDesai.net
#26 by Kalyan Adhikari on June 3, 2010 - 4:23 am
Quote
I had SQL Server 2000 and SQL Server 2005 along with VS 2003 and VS 2005 , I work with BIDS. To upgrade I had to uninstall VS 2003 and both SQL Server versions and Installed SQL Server 2005 first as I needed the Reporting Services and Integration Services and then VS 2008 . Now I do not get Business Intelligence Studio Project options in both versions of VS 2005 and VS 2008 also it does not appear in the menu of SQL Server 2005 in “All Programs”.
Can you help please. Its urgent
#27 by Anil Desai on June 3, 2010 - 7:19 am
Quote
Kalyan: It sounds like the Workstation Components (which includes BIDS) were not installed (or reinstalled) as part of your SQL Server 2005 installation. I suggest you re-run the SQL Server 2005 setup process and verify that Workstation Components are selected. If they are, you might want to try removing them and then reinstalling them. I hope this helps! – Anil
#28 by Enow Mbi on June 7, 2010 - 4:32 am
Quote
I have installed vs 2008 pro and sql server 2008 ent. i found sql_bids.msi on the installation cd under X86\SETUP\ .I launched it but got no response. What do i need to do ?
#29 by Anil Desai on June 7, 2010 - 7:01 am
Quote
Enow: It sounds like you’re experiencing a problem with the MSI installer, though I’m not sure what the exact problem is. Assuming you have the command-line switches correct, you might want to just re-run the SQL Server 2008 setup program and then choose to install the Workstation Components. I hope this is helpful! – Anil
#30 by nimmy on August 14, 2010 - 4:19 am
Quote
i have installed sql server 2005 on windows 7 machine. when i try to open the bids it says it requires 2005 sp1 for vista. shall i install the sp1. will it work?
#31 by Anil Desai on August 14, 2010 - 7:49 am
Quote
Nimmy: Yes, I would recommend installing the latest Service Pack (SP2) for Windows Vista. The error message is due to security issues in Windows Vista that prevent SQL Server 2005’s management tools from working properly. Once you install the update, it should work properly. I hope this is helpful! – Anil
#32 by Govind on August 19, 2010 - 12:07 am
Quote
Hi,
I Installed Visual studio 2008 in my machine,i enjoyed it alot then i installed Sql Server 2005 Express Edition and Sql server 2005 Toolkit .Management studio is working properly but BID was not working when i going to click on BID its showing a error message like devenv.exe is missing.How to fix this issue please help me.
#33 by Ian on October 20, 2010 - 11:32 am
Quote
Is there any way to install MS BIDS 2008 without using the full SQL 2008 or VS Studio 2k8 installs? I have multiple people that need the install, I just don’t want to have to either copy 4+gb to each workstation or carry around a DVD to do the installs.
#34 by Anil Desai on October 20, 2010 - 12:46 pm
Quote
Ian: Sure – you can use the SQL Server 2008 automated installation feature. There are options during the GUI portion of the setup process (I don’t remember the exact commands or details, though). Here’s a link for more information: http://msdn.microsoft.com/en-us/library/dd239405.aspx (the basics are the same for SQL 2008 R2 and SQL 2008). Also, you might consider providing some users with Report Builder 2.0 or 3.0 if they just need the ability to create reports and don’t need to use Visual Studio projects or TFS / VSS source code control. I hope this helps.
#35 by Robert on October 25, 2010 - 3:12 pm
Quote
Microsoft .NET MVP guy with a .PHP website… Bwaaaa!!!
#36 by Anil Desai on October 25, 2010 - 5:17 pm
Quote
Robert: Thanks for your insightful expose on this scandal. 🙂 This blog uses WordPress – one of the best blogging and basic CMS platforms I’ve run across. I have no apologies for that. In fact, Microsoft recently announced that it was moving all of its Windows Live Spaces users to WordPress (see http://www.digitaltrends.com/buying-guides/microsoft-closing-live-spaces-moving-users-to-wordpress/). While I wouldn’t consider myself a fan of PHP as a development language, there’s certainly room in the world for non-Microsoft development technology. And, I’m a Windows Server MVP, though I do a lot of .NET / SQL Server development. – Anil
#37 by Jai on March 1, 2011 - 5:15 pm
Quote
Anil,
you saved my day. This is the exact thing i was looking for.
Now I’m to load BIDS without any errors & now I can play around with it.
Thanks
Jai
#38 by chitra on May 4, 2011 - 2:56 am
Quote
Hi Anil,
I am trying to open a SSRS project in VS2008 on a virtual machine which have SQL Server 2005 installed. It is prompting error .rptproj cannot be opened because its project type is not supported by this version of Visual Studio. In my VS2008, I am not able to see Business Intelligence Project type as well when trying to create new project. Does that means I need to install SQL Server 2008 to have this project type installed? I also have VS 2005 in my machine having Business Intelligence Project installed but this project is in VS2008. Do I need to get SQL Server 2008 installed for this purpose? I am connecting to report server which is not my localhost.
#39 by Anil Desai on May 4, 2011 - 8:59 am
Quote
Chitra: If I understand the problem correctly, I think you need to run the SQL Server 2008 setup process and choose to install at least the “Workstation Components”. That will add the Business Intelligence project types to your Visual Studio installation. In you case, it will also install the Visual Studio 2008 shell (because you don’t already have it installed). You shouldn’t need to install SQL Server 2008 (the database service) or SSRS 2008 (Reporting Services) on the local machine if you don’t plan to do any local deployments. As an alternative, you might consider downloading and using Report Builder 2.0 or 3.0. It’s a much faster installation and should simplify the process of editing SSRS 2008 reports. Report Builder lacks source control integration and project support, but if you’re just editing a few reports, it might work for you. I hope this helps! – Anil
#40 by bi on June 6, 2011 - 6:24 am
Quote
I have uninstalled the VS2008 because of upgrade to 2010 and then I lost BIDS functionality. Your post save me 😉 thx!
#41 by Durga on September 12, 2011 - 4:29 am
Quote
I cant to find the vs_setup.exe file in my system. Can you tell the full path to find vs_setup.exe file.
#42 by Anil Desai on September 12, 2011 - 8:05 am
Quote
Durga: I just searched on the ISO of my MSDN copy of SQL Server 2008 R2, and I don’t have the \Tools path or the executable referenced, either. I believe the steps and article I quoted above referred to an earlier (or different) distribution of SQL Server. You should still be able to re-run the setup process from the DVD/ISO and choose the option to install the components you need. I hope this helps! – Anil
#43 by Fuzzing on October 5, 2011 - 10:19 am
Quote
Anil,
You da’man! Google-ing for 4 days! did NOT provide the information I got from this thread. Your efforts maintaining these conversations is indispensable. Now I know I do NOT have to make a BIG purchase of vs2008 to create/maintain SSRS reports with BIDS. I can download the FREE Report Builder or install the vs2008 shell that comes with SQL Server 2008. However, do I need the SQL Server 2008 Standard or Developer edition (or they both have the “Shell”)?
#44 by Anil Desai on October 5, 2011 - 11:33 am
Quote
You’re welcome – I’m glad you found this information to be useful. Yes, the free Report Builder is all you need to create and edit reports. However, you’ll need an SSRS installation in order to deploy the reports so others can access them. If you want the additional features of working within Visual Studio (source code control and project creation), you can install the development tools using any edition of SQL Server. When you select the workstation or development options, the VS 2008 Shell will be installed automatically. I hope this helps! – Anil
#45 by Ashima on October 12, 2011 - 5:52 pm
Quote
Hi Anil,
I am new to BIDS, here’s the thing if you could help me.
a) I have VS 2008 Professional edition installed.
b) I am trying to get SQL server Management Studio 2008.
c) My company would not let me install sql server 2008 developer edition installed.
So, with VS 2008 and SSMS 2008, will I be able to see BIDS environment and create SSIS packages.
I do not see BIDS right now, so is there seperate installation which comes with VS2008 installation.
Please advise – Ashima
#46 by Anil Desai on October 13, 2011 - 9:11 am
Quote
Ashima: Both BIDS and SSMS are part of the Workstation Tools that are installed with SQL Server 2008. However, they’re independent components. If your company will allow you to install the development tools (without the SQL Server database engine), you should be able to use both environments for SSIS work. Another option might be to use the SQL Server Express management tools (see http://www.microsoft.com/sqlserver/en/us/editions/express.aspx), however, I don’t think it has support for SSIS. The key seems to be the restriction on installing SQL Server 2008. If hope this helps. – Anil
#47 by siva narayana on November 25, 2011 - 5:27 am
Quote
Please explaine the processes of SSRS in SQL server 2000
#48 by Anil Desai on November 25, 2011 - 7:07 am
Quote
Siva: SQL Server Reporting Services was released in early 2004 for the SQL Server 2000 platform. It’s an optional add-on component, and you can find more information on Microsoft TechNet at http://technet.microsoft.com/en-us/library/cc966443.aspx. I hope this helps!
Trackback: business messages
#49 by Cyril on February 9, 2012 - 2:19 pm
Quote
Hi,
I am just starting my development career in CRM Dynamics. Thus want to know how to install and configure SQL 2008 R2 BIDS to create a fetch-based custom report. I am using VS 2010.
Thanks.
#50 by Anil Desai on February 9, 2012 - 4:48 pm
Quote
Cyril: You should be able to find many online tutorials that show you how to create reports using BIDS. You can also use the stand-alone Report Builder product, if you just want to get up and running quickly. – Anil
#51 by Dpkas on February 10, 2012 - 6:47 am
Quote
Hi Anil,
I found this post while searching for similar solution.
But my problem is kinda reverse one..I mean i had VS 2005 earlier and it worked fine when i used for developing c# apps.Then I installed VS 2008 (shell) and installed BI components for SSRS.
Now I again want to develop c# apps using this but when i create new project, i coudn’t find any c# templates for Project tough all reporting and c++ templates are present.
I know this post is old and I wonder if i will get any response.Still any help is greatly appriciated.
thanks
#52 by Anil Desai on February 10, 2012 - 9:14 am
Quote
Dpkas: I’m not sure about the reason for the problem you’re describing, but I think it would be easy enough to resolve my re-running the Visual Studio 2005 setup process. You can try to use a “Repair” installation. If that doesn’t work, you should be able to select the C# language and project types as part of a custom installation. I’m not aware of any incompatibilities that are caused by running the VS 2008 shell and VS 2005, but you might want to consider upgrading to Visual Studio 2008 or Visual Studio 2010 to be more current with the development environment. I hope this helps! – Anil
#53 by joseph on February 13, 2012 - 12:58 am
Quote
iam not getting you actually i installeg both ssms2008 and vs2008 separately now i want to incorporate ssis
is there any installations required or any donload links are there? please tell asap because im now in very need of running packages.
#54 by Anil Desai on February 13, 2012 - 9:29 am
Quote
Joseph: If I understand correctly, you’re trying to create/modify SSIS packages using BIDS, but the project type is not available. I’m not sure this would work, but you can try to re-run SQL Server 2008 Setup and choose to add/remove items. Under Workstation Components, make sure that SSIS support is enabled. You can also use SQL Server Management Studio to connect to the SSIS services of your SQL Server installation. That should allow you to import and run packages. If that doesn’t help, I suggest posting your question to the Microsoft SSIS forum. Be sure to include complete details of what you’re trying to do. – Anil
#55 by Cyril on February 24, 2012 - 2:27 am
Quote
Thanks Anil! Right now I am struggling on how to sum up the difference of this expression in BIDS 2008.
=(DateDiff(“h”,Fields!ReadyForSignOff_actualstart.Value,Fields!Troubleshooting_actualstartValue.Value)\60)& “:”& (DateDiff(“n”,Fields!ReadyForSignOff_actualstart.Value,Fields!Troubleshooting_actualstartValue.Value)\ 60)& “:” & (DateDiff(“s”,Fields!ReadyForSignOff_actualstart.Value,Fields!Troubleshooting_actualstartValue.Value)\60)
So what I need to do is to sum up the difference of this function and divide it to an integer value.
#56 by Anil Desai on February 24, 2012 - 9:05 am
Quote
Cyril: I’m not sure exactly what you’re trying to do, but you might be able to get some better input on the Microsoft SSRS forums. Just be sure to post exactly what you want to return and what the source data looks like. If you’re trying to find the different between dates, you could just subtract them, and then use a string conversion function to format the output. I hope this helps a little! – Anil
#57 by Cyril on February 29, 2012 - 3:29 am
Quote
Hi Anil,
Thanks for replying. To cut it simple I want to convert the date and time field (created on) to an integer in my report so that i can divide it to another integer. How do I do that in expressions? again I’m using BIDS 2008 for creating my custom report. Thanks Anil.
#58 by Anil Desai on February 29, 2012 - 5:27 pm
Quote
Cyril: I’m not sure I have an answer for you, but it looks like your code is off to a good start. Again, I’d recommend posting in the Microsoft SSRS Forum (http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads). I did a quick search for “convert date to integer”, and it looks like there are a lot of potentially relevant discussion there. Good luck! – Anil
#59 by santhosh on May 30, 2012 - 4:36 am
Quote
Hi Anil,
I am newly joined in a company and they assigned to work on SSRS and MSBI. Can you please send me a basic documents of SSRS and basics queries for generating reports in ssrs. thank you
regards,
santhosh.kumar1212@gmail.com
#60 by Anil Desai on May 30, 2012 - 6:18 am
Quote
Santhosh: There are many online resources for learning about and working with SSRS. Here rare some places to get started:
http://msdn.microsoft.com/en-us/library/ms159106.aspx
http://msdn.microsoft.com/en-us/library/bb522859.aspx
Note that you can download sample reports and sample databases from CodePlex. If you like to learn by example, that’s a good place to start. I hope this helps! – Anil
#61 by Musa on March 19, 2013 - 6:02 am
Quote
Long live this post. I hope I can still post my situation and Questions. Our Company use Microsoft SQL Server 2008 R2 in Virtual Machine. The BI components and the Visual Studio 2008 (shell) with BI Project types are there. There is no Installation CD and it shown that they didnt define any Workstations during the installation. Now We (2 Developer) need to use BI to make Reports and Evaluation Diagrams. Is there any way to work with Visual Studio from our laptop without need to connect to the Virual machine? Is it possible to install visual studio professional on our work pcs and connect with the server to make BI projects? We in the company don’t have experience with BI, so they ask me to search what they have to buy or to do.
many thanks for the wonderful post and the help.
#62 by Anil Desai on March 19, 2013 - 7:45 am
Quote
Musa: I’m glad you found this post to be useful! Yes, you can definitely install software on your local computer to connect to and develop reports. If your SSRS servers are running SQL Server 2008 R2, you can use the stand-alone Report Builder 2.0 application to create and modify reports. That’s most useful if you’re working with a small number of reports. The other option is to run the SQL Server installation media on your local computer (you’ll need to get this from your company, or download the Developer Edition online). During installation, all that’s required is the Workstation Components option. That will install the Visual Studio shell and support for Report Server and related projected types. Note that installing Visual Studio by itself will not include those project types. If you want to use Visual Studio 2012, you can download the SQL Server Data Tools to allow the creation and development of reports. I hope this helps! – Anil
#63 by Musa on April 3, 2013 - 6:35 am
Quote
Thanks Anil for your response. So my company dont have more the installation media (CD) of the SQL Server 2008 R2. What u mean is to buy SQL Server 2008 R2 Installation CD and install it on my local computer. Do I need to install the whole server or only client tools? Can the inslalling to recognize automaticly our existing SQL Server? Which Installing CD (version, edition)we need to buy? What we have is SQL SERVER 2008 R2 (RTM).
Many thanks
#64 by Anil Desai on April 3, 2013 - 6:46 am
Quote
You’re welcome! It sounds like you’re on the right track. As I mentioned before, you have several other options (SQL Server Express and Report Builder), but if you need BIDS, I believe you will need the SQL Server installation media. You can probably find a download for the Developer Edition on the Microsoft site. I’m not familiar with licensing requirements, so you’ll need to look into that yourself. You will only need to install the client tools, not the entire server. The client tools should be able to connect to any SQL Server after you have configured them. I suggest you review the different editions of SQL Server at http://www.microsoft.com/en-us/sqlserver/editions.aspx. I hope this helps! – Anil
#65 by Anusha on July 29, 2013 - 6:47 am
Quote
hi Anil,
I would like to know how to install BIDS in VS2008?
I am not from DB background and very much new to this field, and I am curious to know about it
Thank you
#66 by Anil Desai on July 29, 2013 - 6:51 am
Quote
Anusha: You can install BIDS by running the SQL Server setup program. One of the options is to install the Workstation Tools. If you do not yet have Visual Studio installed, the basic shell will be installed. If VS 2008 is already installed on your computer, after the installation, you’ll see new options to create “Business Intelligence” projects from the New Project dialog box. I hope this helps! – Anil