Not seeing Business Intelligence Projects after SQL 2005 Developer install

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Not seeing Business Intelligence Projects...

Not seeing Business Intelligence Projects after SQL 2005 Developer install

Rate Topic

Display Mode

Topic Options

Author

Message

braxton

Posted Saturday, December 15, 2007 11:13 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 07, 2008 9:10 AM
Points: 3, Visits: 20

Hello everyone.. first post..

I start with a Vista Ultimate laptop running in x64 mode.

Add to that VS2005 in x64, and the load SQL 2005 (x64).

I did select SSIS, SSRS, and all of the goodies.

Nothing showed an error during installation.

SQL Server Configuration manager shows SSIS and the other services running.

The problem is, is that I don't see Business Intelligence Projects in either the SQL 2005 menu or as a VS 2005 project type. But yet they are "running"

I love these tool and want to learn more about them. Please help me get to where I can see them.

Post #433720

Gift Peddie

Posted Tuesday, December 18, 2007 12:02 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

VS2005 both the one that comes with SQL Server developer edition and I am assuming professional you installed are both 32bit applications. Yes you can use the pro to do some 64bits development I don't think Business intelligence is included. You can find the 32bits and 64bits components of SQL Server in the BOL. Hope this helps.

Kind regards,
Gift Peddie

Post #434486

braxton

Posted Tuesday, December 18, 2007 12:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 07, 2008 9:10 AM
Points: 3, Visits: 20

No, I loaded everything as X64 mode. Vista, VS2005, SQL2005

Post #434495

Gift Peddie

Posted Tuesday, December 18, 2007 12:26 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

I am trying to tell you loading VS2005 in 64bits mode will not give you a lot of development tools including Business Intelligence because those tools are in 32bits so also is Asp.net it can use 64bits dll but IIS must run in 32bits mode. What you can do is develop in 32bits and compile with AnyCPU option which means you can deploy the code in 64bits.

Kind regards,
Gift Peddie

Post #434502

braxton

Posted Tuesday, December 18, 2007 12:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 07, 2008 9:10 AM
Points: 3, Visits: 20

I was affraid of this.. Junk a copy of Vista Unlimate and go back to good ole reliable XP Pro..

Do you or anyone know if VS2008/SQL2008 intend to make these tools 64 bit?

Post #434506

Gift Peddie

Posted Wednesday, December 19, 2007 10:59 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

I don't think so because Microsoft says the reason VS2008 is 32bits is their customers plugins about 1000 plus are all in 32bits. The good news is most database development tools let you develop in 32bits and deploy in 64bits. There are known issues but if you have the full VS2005 version check you build configuration you should have AnyCPU and X64, use AnyCPU and your code will run without issue. Hope this helps.

Kind regards,
Gift Peddie

Post #434877

« Prev Topic | Next Topic »

Permissions