Solved

Project Server 2003 on SBS 2003 R2 running SQL 2005

Posted on 2006-11-29
6
242 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now