OLAP Connection

  • Thread starter Vishal Dalsania
  • Start date
V

Vishal Dalsania

Hi All,

I ahve installed Project Server 2003 in a machine and SQL Server 2000 as
well as analysis server 2000 in another machine.

Now when i try to create OLAP Cube i get error that iot can not connect to
OLAP Server specified.

But i can connect it via Analysis Manager with same username.

The error i found in event log is as below

Error #1 :-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Cannot connect to the repository.
Analysis server: RIGSERVE-2
Error:
Could not use ''; file already in use.' Error Number :
'-2147221453]]></Description>


Error #2:-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>


Can anyone help me.

Thank You
Vishal Dalsania
 
G

Gary L. Chefetz [MVP]

Vishal:

Did you migrate your repository? If not, follow the post installation steps
in the Installation Guide for guidance.
 
V

Vishal Dalsania

Hi

Thanks for the reply.

My Scenario is as below

2 Win2k3 R2 Machines, one has SQL 2000 + Analysis Service
2nd one with MS Project Server + IIS + Sharepoint Service

Both are in same domain and OLAP user is a domain user and added in OLAP
Administrator in both machines.

No i have not migrated the repository. It is a fresh installation. Now i am
reinstalling Analysis Service and service pack 3 on my Win 2k3 R2 machine
and then i will again run COM+ Settings tool.

Lets see if it helps. I will reply whatever the result is.

Regards
Vishal Dalsania

Gary L. Chefetz said:
Vishal:

Did you migrate your repository? If not, follow the post installation
steps in the Installation Guide for guidance.




Vishal Dalsania said:
Hi All,

I ahve installed Project Server 2003 in a machine and SQL Server 2000 as
well as analysis server 2000 in another machine.

Now when i try to create OLAP Cube i get error that iot can not connect
to OLAP Server specified.

But i can connect it via Analysis Manager with same username.

The error i found in event log is as below

Error #1 :-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Cannot connect to the repository.
Analysis server: RIGSERVE-2
Error:
Could not use ''; file already in use.' Error Number :
'-2147221453]]></Description>


Error #2:-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>


Can anyone help me.

Thank You
Vishal Dalsania
Click to expand...
Click to expand...
 
V

Vishal Dalsania

Hi,

It still gives me same error for connection and same entry in Event Log.

Am i missing anything?

Thank You
Vishal Dalsania

Vishal Dalsania said:
Hi

Thanks for the reply.

My Scenario is as below

2 Win2k3 R2 Machines, one has SQL 2000 + Analysis Service
2nd one with MS Project Server + IIS + Sharepoint Service

Both are in same domain and OLAP user is a domain user and added in OLAP
Administrator in both machines.

No i have not migrated the repository. It is a fresh installation. Now i
am reinstalling Analysis Service and service pack 3 on my Win 2k3 R2
machine and then i will again run COM+ Settings tool.

Lets see if it helps. I will reply whatever the result is.

Regards
Vishal Dalsania

Gary L. Chefetz said:
Vishal:

Did you migrate your repository? If not, follow the post installation
steps in the Installation Guide for guidance.




Vishal Dalsania said:
Hi All,

I ahve installed Project Server 2003 in a machine and SQL Server 2000 as
well as analysis server 2000 in another machine.

Now when i try to create OLAP Cube i get error that iot can not connect
to OLAP Server specified.

But i can connect it via Analysis Manager with same username.

The error i found in event log is as below

Error #1 :-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Cannot connect to the repository.
Analysis server: RIGSERVE-2
Error:
Could not use ''; file already in use.' Error Number :
'-2147221453]]></Description>


Error #2:-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>


Can anyone help me.

Thank You
Vishal Dalsania
Click to expand...
Click to expand...
Click to expand...
 
G

Gary L. Chefetz [MVP]

Vishal:

I think you may have misread my last post. You need to migrate the
repository. You need to complete the installation steps in the installation
guide under post installation steps. It's not that you've done something
wrong, it's simply that you haven't finished the job.




Vishal Dalsania said:
Hi,

It still gives me same error for connection and same entry in Event Log.

Am i missing anything?

Thank You
Vishal Dalsania

Vishal Dalsania said:
Hi

Thanks for the reply.

My Scenario is as below

2 Win2k3 R2 Machines, one has SQL 2000 + Analysis Service
2nd one with MS Project Server + IIS + Sharepoint Service

Both are in same domain and OLAP user is a domain user and added in OLAP
Administrator in both machines.

No i have not migrated the repository. It is a fresh installation. Now i
am reinstalling Analysis Service and service pack 3 on my Win 2k3 R2
machine and then i will again run COM+ Settings tool.

Lets see if it helps. I will reply whatever the result is.

Regards
Vishal Dalsania

Gary L. Chefetz said:
Vishal:

Did you migrate your repository? If not, follow the post installation
steps in the Installation Guide for guidance.




Hi All,

I ahve installed Project Server 2003 in a machine and SQL Server 2000
as well as analysis server 2000 in another machine.

Now when i try to create OLAP Cube i get error that iot can not connect
to OLAP Server specified.

But i can connect it via Analysis Manager with same username.

The error i found in event log is as below

Error #1 :-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect failed with error
message 'Cannot connect to the repository.
Analysis server: RIGSERVE-2
Error:
Could not use ''; file already in use.' Error Number :
'-2147221453]]></Description>


Error #2:-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>


Can anyone help me.

Thank You
Vishal Dalsania
Click to expand...
Click to expand...
Click to expand...
 
V

Vishal Dalsania

Hello

Thank you Gary it did work,
I skipped it because it was the last part of the guide and i was lazy to
read instruction. I will take care next time.
Thanks for the help

Regards,
Vishal Dalsania

Gary L. Chefetz said:
Vishal:

I think you may have misread my last post. You need to migrate the
repository. You need to complete the installation steps in the
installation guide under post installation steps. It's not that you've
done something wrong, it's simply that you haven't finished the job.




Vishal Dalsania said:
Hi,

It still gives me same error for connection and same entry in Event Log.

Am i missing anything?

Thank You
Vishal Dalsania

Vishal Dalsania said:
Hi

Thanks for the reply.

My Scenario is as below

2 Win2k3 R2 Machines, one has SQL 2000 + Analysis Service
2nd one with MS Project Server + IIS + Sharepoint Service

Both are in same domain and OLAP user is a domain user and added in OLAP
Administrator in both machines.

No i have not migrated the repository. It is a fresh installation. Now i
am reinstalling Analysis Service and service pack 3 on my Win 2k3 R2
machine and then i will again run COM+ Settings tool.

Lets see if it helps. I will reply whatever the result is.

Regards
Vishal Dalsania

"Gary L. Chefetz [MVP]" <gary AT chefetz DOT org> wrote in message
Vishal:

Did you migrate your repository? If not, follow the post installation
steps in the Installation Guide for guidance.




Hi All,

I ahve installed Project Server 2003 in a machine and SQL Server 2000
as well as analysis server 2000 in another machine.

Now when i try to create OLAP Cube i get error that iot can not
connect to OLAP Server specified.

But i can connect it via Analysis Manager with same username.

The error i found in event log is as below

Error #1 :-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect failed with
error message 'Cannot connect to the repository.
Analysis server: RIGSERVE-2
Error:
Could not use ''; file already in use.' Error Number :
'-2147221453]]></Description>


Error #2:-

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>


Can anyone help me.

Thank You
Vishal Dalsania
Click to expand...
Click to expand...
Click to expand...
 

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

Similar Threads

OLAP Error / Cube continuously builds 2
Cube build fails, security check failure 11
2003 Cube Refresh Error 0
Cannot build OLAP Cubes MSPS 2003 SP3 SQL Server 2005 SP2 1
OLAP Problem 2
Cannot Connect to OLAP 1
Project Server errors (Microsoft Project Server Tracing Eventlog Provider_2_E) 3
SQL server 2005 Analysis Services? 6

Top