Solved

Problem starting SQL 2005 Business Intelligence Development Studio

Posted on 2011-03-09
9
255 Views
Last Modified: 2012-06-27
Hi,
I have windows 7 Enterprise, SQL 2005 Standard with SP3.  When I click to start BID, a pop up dialog say there is compaitility issue with "visual studio 2005" and wants me to down load sp for vs 2005.  Well, the problem is I have Visual Studio 2005, .net 3.5 on my PC.  I want to use SSIS to create a package.  How can I get pass this so it knows I have vs 2008 and use that instead?  Thanks.
0
Comment
Question by:lapucca
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 35089273
Just open up VS 2008 and choose to create a new project select Business Intelligence Project and the type of project you want to create.
0
 

Author Comment

by:lapucca
ID: 35089336
I selected Other Project Types and there is only a DATABASE project.  I double click to search online for new templates and it returns nothing.  Thanks.
0
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 35096211
Check this link, it has some info for you to get the project types.
http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/eb73f47c-e558-4a0e-9e63-3a3dfb3bc684
0
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 

Author Comment

by:lapucca
ID: 35097960
That link relates to someone with vs2005 installed.  I have vs2008.  thanks.
0
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 35098108
I believe the BIDS project would still be included with the 2008 SQL Express as well.
0
 

Author Comment

by:lapucca
ID: 35098225
Right, I have sql 2005 standard installed but my VS is 2008.  So, the sql 2005 is looking for VS2005 for BID.  Any way around this?  thanks.
0
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 35098451
hmm. ok. got it.

The following link seems to point to the answer. Unfortunately not a very acceptable one.
Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)

http://geekswithblogs.net/juang/archive/2007/12/12/visual-studio-2008-will-not-support-sql-server-2005-reporting.aspx
0
 
LVL 17

Accepted Solution

by:
Daniel Reynolds earned 500 total points
ID: 35098463
Even though it says Reporting Server projects, I believe that includes the realm of business intelligence projects (SSIS, etc)
0
 

Author Closing Comment

by:lapucca
ID: 35099968
Thank you.  At least now I know what are my limitations, even though there is no work around.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

717 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