Solved

Project Server 2003 on SBS 2003 R2 running SQL 2005

Posted on 2006-11-29
6
249 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
[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
  • 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
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

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place.  There are several solutions to this, including adding additional drive space or using third party uti…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

617 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