Solved

Project Server 2003 on SBS 2003 R2 running SQL 2005

Posted on 2006-11-29
6
247 Views
Last Modified: 2012-05-05
Here's our situation - I'm trying to install Microsoft Office Project 2003 on SBS 2003 R2 that's running SQL 2005.  

Our network is small (5 computers max) and we're running a dual, dual-core Xeon server with dual gigabit NIC's so I'm not too worried about boggin down the system with Project...

Can anyone tell me how to setup the users for the install?  I'm following the "Installing Project 2003" directions that are on the disc.  I get as far as "Create an OLAP Administrator" and cannot find the OLAP Administrator group.  When I installed SQL 2005, as far as I know, I did install Analysis Services.  The link to the Analysis Services Deployment Wizard is present...

Can anyone help?!  Thanks in advance.
Chris
0
Comment
Question by:CompTechNS
  • 3
  • 3
6 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 350 total points
ID: 18055691
Not a good idea. It's not a supported configuration, and I've never seen that it would work right.  

If you still want to give it a try, then don't follow the instructions on the disk, insted you need to go with the steps outlined in this document:  http://www.sbslinks.com/pdf/ProjectServer.pdf

It was written for SBS 2003 with SQL 2000, but most of the steps should be similar.

With a business that small though, I'd wonder if Project Server is overkill.  You might want to take a look at Outlook's Business Contact Manager which has a fairly decent integrated project management functionality.  http://www.microsoft.com/office/outlook/contactmanager/prodinfo/default.mspx

BCM is a free add-on if you have Office 2003 Small Business or Professional.

Jeff
TechSoEasy



0
 
LVL 1

Author Comment

by:CompTechNS
ID: 18055751
Jeff,

The directions you linked to include a section on installing SQL 2000...  Does this mean that we have to install SQL 2000 and if so, are we replacing 2005 or will the 2 run side-by-side?

As for your suggestion, I was trying to get away from BCM since we have Microsoft CRM 3.0 running as well.  I imagine that we could probably use the CRM software in place of Project as well.

I'll be honest, we recently received the MS Action Pack and were installing everything for purposes of testing/learning for sales purposes, while using what we could to better our business management as well.  I agree that I probably don't need Project.

Thank you for the help!
Chris
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 18056079
If you did install Project Server, then you wouldn't use SQL 2000... I had mentioned above that it said that, but I guess I wasn't clear enough that you would use SQL 2005.

At any rate... if that's why you are installing it, then I'd say don't.

If you already have CRM 3.0 installed, which you didn't mention above... I would wonder if your server is indeed powerful enough.  And, if it is, you'd be better off using Virtual Server 2005 to add an additional instance of Windows Server 2003 to run Project Server...

But, before you do that...

I know that the Action Pack really generates a lot of excitement about seeing this stuff work.  My suggestion is that you only put those things on your server that YOU will use in your own business.  Then, create a test lab on a separate machine using Virtual Server 2005.  I have that set up and it's great because of the differencing disk capabilities, and the ability to load pre-configured virtual machines, you can play all you want and never worry about screwing up your own stuff.

Also, you can now see most of these things in Virtual Labs in the Partner Training section of Microsoft's Partner Website. (although I don't think they have one for Project Server).

If you are just starting out as a consultant, the only other thing I can recommend is that you don't spread yourself too thin.  There is much too much to get your arms around just from Microsoft alone, so you really have to pick and choose.  Personally, I am an exclusive SBS Consultant (including any of it's related technologies).  If it gets too much beyond that, I either have to bring in another consultant that specializes in that area or pass on the client because it's incredibly inefficient to have to only have one or two clients that use a specific technology.  I am much better off spending that time and energy with my current clients and with those new prospects that fit my specialty.

Jeff
TechSoEasy
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:CompTechNS
ID: 18056228
Jeff,

Sounds good to me.  I appreciate the insight / advice.  It is easy to get caught up in all of the almost-free software that you get with the action pack.

Thank you!
0
 
LVL 1

Author Comment

by:CompTechNS
ID: 18056243
Jeff,

Post a comment on my thread in Project and I'll give you the 50 points from that as well.

http://www.experts-exchange.com/Applications/MS_Office/Microsoft_Project/Q_22079398.html

Thanks again!
Chris
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 18056289
Don't worry about that... you can just delete the question if there are no comments.  

Jeff
TechSoEasy
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

713 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