Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Project Server 2003 on SBS 2003 R2 running SQL 2005

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
CompTechNS
Asked:
CompTechNS
  • 3
  • 3
1 Solution
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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
 
CompTechNSAuthor Commented:
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
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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
Independent Software Vendors: 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!

 
CompTechNSAuthor Commented:
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
 
CompTechNSAuthor Commented:
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
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Don't worry about that... you can just delete the question if there are no comments.  

Jeff
TechSoEasy
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now