You need to install selecting the "Small Farm" option to install the
Enterprise version of the software. The Stand-Alone option installs a
non-enterprise version that doesn't use SQL Server, it uses SQL Express.
I
have not installed the eval edition, so I don't know if it has specific
limitations. I downloaded it and will get around to it one of these days.
Assuming that it doesn't, you need to uninstall Project Server, and
reinstall selecting the Small Farm configuration, where you will choose
to
install everything on one server.
--
Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:
http://www.msprojectexperts.com
For Project Server FAQS:
http://www.projectserverexperts.com
When you say "standalone" do you mean that you selected that during
the
Project Server installation? If so, therein lies your mistake. This
selection installs a very limited version of Project Server and also
installs SQL 2005 express. If you selected this installation option,
then
you can't use Analysis services. We have to be careful with words.
Otherwise, it looks like you have the correct components on the
system,
but
thecubebuilding process is not finding them. Therefore my
recommendation
to rerun the SQL installation.
--
Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:
http://www.msprojectexperts.com
For Project Server FAQS:
http://www.projectserverexperts.com
On Sep 12, 6:28 pm, "Gary L. Chefetz [MVP]" <
[email protected]>
wrote:
From what you've told me, you need to install only the client
components.
This should only take a few minutes.
--
Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:
http://www.msprojectexperts.com
For Project Server FAQS:
http://www.projectserverexperts.com
On Sep 12, 5:11 pm, "Gary L. Chefetz [MVP]" <
[email protected]>
wrote:
So what happened when you tried to reinstall? Did you select the
client
objects and install them?
--
Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:
http://www.msprojectexperts.com
For Project Server FAQS:
http://www.projectserverexperts.com
On Sep 12, 3:24 pm, "Gary L. Chefetz [MVP]" <
[email protected]>
wrote:
Well then, my next guess would be that you installed SQL
Server,
but
didn't
install Anlysis Services, or it is partially installed. Can
you
verify
that
Analysis Services is installed? When you open SQL Management
Studio,
can
you
connect to Analysis services? The particular error you're
getting
indicates
that the process is failing before the request is getting to
Analysis
services. The system connects to Analysis services using the
DSO
objects,
so
the fact that it isn't finding them generally means they
aren't
there.
I
think you should run the Analysis Services install again and
make
sure
that
you have selected all of the components including the client
components.
--
Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:
http://www.msprojectexperts.com
For Project Server FAQS:
http://www.projectserverexperts.com
On Sep 11, 7:57 pm, "Gary L. Chefetz [MVP]"
<
[email protected]>
wrote:
The error would indicate that you are running SQL on a
different
machine
than your web front end. This is good, however you needto
install
the
following on your front-end server:
XML 6.0
OLEDB 9.0
SQL client objects
You can find the instructions in the TechNet library.
--
Gary L. Chefetz, MVP
MSProjectExperts
For Project Server
Consulting:
http://www.msprojectexperts.com
For Project Server
FAQS:
http://www.projectserverexperts.com
Hi all,
I am running microsoft project office server
(MSPS)2007TRIAL
VERSION on a VIRTUALMACHINE.Its working fine. I am
able
to
make
it
communicate with Microsoft Project Professional(MSP) .. I
am
able
to
create projects as well. I am trying to
createcubeinMSPS2007using
PWA & have installed sql server 2005 with analysis
services. I have followed the link
http://www.pptspaces.com/msprojectreporterblog/Lists/Posts/Post.aspx?...
to create acube, but i am getting the following error
even
though
all the packages are installed as told in the above
link.
"Failed to build the OLAP cubes. ERROR: Analysis
Serrvices
session
failed with the following error : The
Application Server needs to have Analysis Services DSO
component
installed"
I am really stuck with this... So, i request u to help
to
get
out
of
this error & build thecubesucessfuly.. please....
Thanks in advance.
Hi Gary,
Thanks for your reply...
I have installed all, i mean theMSPS 2007& SQL Server
2005
(trial version) on the same virtual machine using Windows
Server2003
has the operating system
Thanks.. Well, if i open SQL Management Studio & select Server
type
:
Analysis Services , Server name : Project Server, & click
connect
i
am
able to connect to Analysis Services & also create databases
here.
U mean i have to reinstall SQL server 2005 setup again, because
Analysis Services is a part of this installation right?
Or do we get a separate Analysis services package? Any link for
this?
plea
Hi Gary,
Thanks a lot for your responses...
I have done standalone installation ofmsps2007, u are talking
about client components &
sql client objects, do they mean same? These are a list of some of
the components installed on my vmware,
1. Microsoft Office Project Server2007trial.
2. Microsoft SQL Server 2005
3. Microsoft SQL Server Management Objects Collection.
4. Microsoft SQL Server Native Client - i assume this has the sql
client objects or client components which you are talking about.
5. Microsoft SQL Server 2005 Backword Compatibility.
6. Microsoft SQL Server 2005 Analysis Services 9.0 OLEDB Provider.
7. MSXML 6.0 Parser (KB925673)
Is there any components missing, or a particular order followed for
their installation.
If i run , [Start -> Run -> regedit.exe] in the registry editor
under