install questions/problems

B

billd

Hi,

I've been trying to get Project server installed for two days running now.
Wondering if the following configuration will work.

One server running SQL Server 2000, this is a domain controller as well...it
has loads of memory and CPU and not that many users, so it copes fine with
the load.

Another server that will run project server and SPS.

I've been following installation instructions. In these, it says that I
need to add the user I have created for Project to the OLAP Administrator
group and I'll find this when I go to My Computer -> manage and in the
console, under groups there will be this group. Well this is a domain
controller and it doesn't have groups in the managment console. Can I put
this group in Active Directory or something? Or can I not install this on a
Domain controller at all? Can I put the Analysis service on the member
computer which will have project server and SPS and still have the SQL server
on my DC. I really don't want to have to setup another SQL server and
maintain and backup it up when that's already done on my main SQL server that
is the DC if possible,

Thanks
 
M

Marc Soester

Hi Billd,

In short, yes your configuration can work fine. I would have Analysis Server
running on your "crunshy" SQL Server Database Server, meaning that you now
have an "Application Server" and a "Database Server". So far so good.

The reason why you need a user with OLAP Administrator groups rights is that
Project Server can "build" the OLAP Cubes for Project Server's Portfolio
Analyser.

Since you have 2 servers your user should be a Doimain user. You give him
"OLAP" Administrator rights when you go to your SQL Server machine open the
console and under groups double click the OLAP Administrator group. Under
"Add" you can now add your user to this group and this user will be able to
create the OLAP Cubes.
There is great documentation in regards to installation under
http://office.microsoft.com/en-us/FX011442351033.aspx

I hope this helps
 
B

billd

Thanks, but my problem is, on my SQL server, which is a domain controller,
you don't have groups under the managment console. Only member servers have
local groups and users :-( So I don't know what to do now. It doesn't
mention anywhere that you can't use a DC for doing this, and normally, I
would expect this info to be in Active Directory rather than a local group.
Am I missing something? Thanks again, I am really struggling with this
install and as I know almost nil about Project in the first place or the
Analysis Services, I seem to have head in hands for most of the day.
 
M

Marc Soester

Hi Billb,

Sorry I am not an Administrator and dont know to much about Domain
controller, but you may want to look into the "Active Directory snap in" that
you can add on you domain controler server, This should give you the abiliity
to add your user to the Active directory OLAP Admin Group.
As I said I am certainly not an Administrator, but maybe is helps
 
B

billd

Thanks again Marc... that was what I was planning on doing... I'm hoping it
works anyway... I've done so many things over several days now, that I don't
remember if I created that group, or it was created for me :-( but I guess
if there's a group of that name, Analysis Services should be able to find it,
will have another go at installing it this afternoon and see what happens and
post back.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top