Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Project Server 2003 on SBS 2003 R2 running SQL 2005

Posted on 2006-11-29
6
Medium Priority
?
250 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 1400 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
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.

 
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

721 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