OLAP building on 2007

Rob · Jul 16, 2007

The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

Any ideas if the problem is because both componets SQL 2005, Project Server 2007 are running from the same server. The cube has never built by the way. I had an Engineer over and he couldn't get it to run either....lol

ahelp · Jul 16, 2007

Try these links:
http://blogs.msdn.com/brismith/archive/2007/02/14/common-error-messages-when-building-cubes.asp
http://technet2.microsoft.com/Offic...-17ee-43a0-bdd9-b269f07f92471033.mspx?mfr=tru
http://blogs.msdn.com/chrisfie/arch...nfiguring-the-cubes-building-service-cbs.aspx

Ben Howard · Jul 16, 2007

If both AS adn PS are on the same machine, then you don't need to modify the
connection string.
If you cannot build a cube, then please supply the errors you get when you
initiate a build.

Rob · Jul 18, 2007

Here is what comes across. Thxs for your help guys...

===== Initiating cube build process =====
[7/18/2007 8:09 AM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/18/2007 8:09 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/18/2007 8:09 AM] Cube build initialization started
[7/18/2007 8:09 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/18/2007 8:09 AM] Cube build session started
[7/18/2007 8:09 AM] Analysis Services session started
[7/18/2007 8:09 AM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server jpss1. Error: The
connection string to repository needs to be specified in the 9.0 server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services 9.0).
===== Process Completed =====
[7/18/2007 8:09 AM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server jpss1. Error: The connection string to repository needs to
be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Ben Howard · Jul 18, 2007

Hi Rob,
I'm still surprised that you are getting this on a single server, however,
try the following On the computer that is running SQL Server 2005 Analysis
Services, follow steps:
â€¢ Open SQL Server Management studio and open the Database Engine object
â€¢ Restore a previous OLAP repository database into a new databaseâ€¦ (i.e.
OLAPRepository) - hopefully you have one!
â€¢ Navigate to the C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config\
and modify the msmdsrv.ini as follows:

Replace the DSO section with following, and change the SERVERNAME and
DATABASENAME to the name of the machine running the Analysis Services, and
the database created in step 2 (i.e. OLAPRepository)

<DSO>
<RemoteRepositoryConnectionString>Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Data Source=SERVERNAME;Initial
Catalog=DATABASENAME;</RemoteRepositoryConnectionString>
<RepositoryConnectionString>Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Data Source=SERVERNAME;Initial
Catalog= DATABASENAME;</RepositoryConnectionString>
<RemoteLocksDirectory></RemoteLocksDirectory>
<LocksDirectory>C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\DSO9</LocksDirectory>
</DSO>

--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Rob said:
Here is what comes across. Thxs for your help guys...

===== Initiating cube build process =====
[7/18/2007 8:09 AM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/18/2007 8:09 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/18/2007 8:09 AM] Cube build initialization started
[7/18/2007 8:09 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/18/2007 8:09 AM] Cube build session started
[7/18/2007 8:09 AM] Analysis Services session started
[7/18/2007 8:09 AM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server jpss1. Error: The
connection string to repository needs to be specified in the 9.0 server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services 9.0).
===== Process Completed =====
[7/18/2007 8:09 AM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server jpss1. Error: The connection string to repository needs to
be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Rob Jones · Jul 18, 2007

Thanks for the insight Ben, but the exact same error occured.
I changed the content of the file as instructed, but had no idea how to
restore a previous OLAP.
Not sure if one is installed at setup, but I have never had a cube build.
Under the Analysis Server listing for database I have:

JPSS1\Databases\OLAPC1\Cubes

I used JPSS1 as the server and OLAPC1 as the database.

Ben Howard said:
Hi Rob,
I'm still surprised that you are getting this on a single server, however,
try the following On the computer that is running SQL Server 2005
Analysis
Services, follow steps:
â€¢ Open SQL Server Management studio and open the Database Engine object
â€¢ Restore a previous OLAP repository database into a new databaseâ€¦ (i.e.
OLAPRepository) - hopefully you have one!
â€¢ Navigate to the C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Config\
and modify the msmdsrv.ini as follows:

Replace the DSO section with following, and change the SERVERNAME and
DATABASENAME to the name of the machine running the Analysis Services, and
the database created in step 2 (i.e. OLAPRepository)

<DSO>
<RemoteRepositoryConnectionString>Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Data Source=SERVERNAME;Initial
Catalog=DATABASENAME;</RemoteRepositoryConnectionString>
<RepositoryConnectionString>Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Data Source=SERVERNAME;Initial
Catalog= DATABASENAME;</RepositoryConnectionString>
<RemoteLocksDirectory></RemoteLocksDirectory>
<LocksDirectory>C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\DSO9</LocksDirectory>
</DSO>

--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Rob said:

Here is what comes across. Thxs for your help guys...

===== Initiating cube build process =====
[7/18/2007 8:09 AM] Cube build request message has been added to the
Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/18/2007 8:09 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/18/2007 8:09 AM] Cube build initialization started
[7/18/2007 8:09 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/18/2007 8:09 AM] Cube build session started
[7/18/2007 8:09 AM] Analysis Services session started
[7/18/2007 8:09 AM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server jpss1. Error:
The
connection string to repository needs to be specified in the 9.0 server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services 9.0).
===== Process Completed =====
[7/18/2007 8:09 AM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to connect to the
Analysis
Services server jpss1. Error: The connection string to repository needs
to
be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

Ben Howard said:

If both AS adn PS are on the same machine, then you don't need to
modify
the
connection string.
If you cannot build a cube, then please supply the errors you get when
you
initiate a build.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

:

The connection string to repository needs to be specified in the 9.0
server properties (see <DSO>...</DSO> section in msmdsrv.ini file from
Analysis Services 9.0).

Any ideas if the problem is because both componets SQL 2005, Project
Server 2007 are running from the same server. The cube has never built
by
the way. I had an Engineer over and he couldn't get it to run
either....lol

Click to expand...

Click to expand...

Ben Howard · Jul 19, 2007

Hi Rob,
I'm not sure I can help much further on this, the issues you are seeing are
not applicable to a single server so I think you have some other
configuration issues.
It might be time to get a consultant in to check it out.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Rob Jones said:
Thanks for the insight Ben, but the exact same error occured.
I changed the content of the file as instructed, but had no idea how to
restore a previous OLAP.
Not sure if one is installed at setup, but I have never had a cube build.
Under the Analysis Server listing for database I have:

JPSS1\Databases\OLAPC1\Cubes

I used JPSS1 as the server and OLAPC1 as the database.

Ben Howard said:

Hi Rob,
I'm still surprised that you are getting this on a single server, however,
try the following On the computer that is running SQL Server 2005
Analysis
Services, follow steps:
â€¢ Open SQL Server Management studio and open the Database Engine object
â€¢ Restore a previous OLAP repository database into a new databaseâ€¦ (i.e.
OLAPRepository) - hopefully you have one!
â€¢ Navigate to the C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Config\
and modify the msmdsrv.ini as follows:

Replace the DSO section with following, and change the SERVERNAME and
DATABASENAME to the name of the machine running the Analysis Services, and
the database created in step 2 (i.e. OLAPRepository)

<DSO>
<RemoteRepositoryConnectionString>Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Data Source=SERVERNAME;Initial
Catalog=DATABASENAME;</RemoteRepositoryConnectionString>
<RepositoryConnectionString>Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Data Source=SERVERNAME;Initial
Catalog= DATABASENAME;</RepositoryConnectionString>
<RemoteLocksDirectory></RemoteLocksDirectory>
<LocksDirectory>C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\DSO9</LocksDirectory>
</DSO>

--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Rob said:

Here is what comes across. Thxs for your help guys...

===== Initiating cube build process =====
[7/18/2007 8:09 AM] Cube build request message has been added to the
Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/18/2007 8:09 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/18/2007 8:09 AM] Cube build initialization started
[7/18/2007 8:09 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/18/2007 8:09 AM] Cube build session started
[7/18/2007 8:09 AM] Analysis Services session started
[7/18/2007 8:09 AM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server jpss1. Error:
The
connection string to repository needs to be specified in the 9.0 server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services 9.0).
===== Process Completed =====
[7/18/2007 8:09 AM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to connect to the
Analysis
Services server jpss1. Error: The connection string to repository needs
to
be specified in the 9.0 server properties (see <DSO>...</DSO> section in
msmdsrv.ini file from Analysis Services 9.0).

If both AS adn PS are on the same machine, then you don't need to
modify
the
connection string.
If you cannot build a cube, then please supply the errors you get when
you
initiate a build.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

:

The connection string to repository needs to be specified in the 9.0
server properties (see <DSO>...</DSO> section in msmdsrv.ini file from
Analysis Services 9.0).

Any ideas if the problem is because both componets SQL 2005, Project
Server 2007 are running from the same server. The cube has never built
by
the way. I had an Engineer over and he couldn't get it to run
either....lol

Click to expand...

Click to expand...

Rob Jones · Jul 21, 2007

Thanks for trying Ben, I'll have to get a DBA to look at this mystery....

Ben Howard said:
Hi Rob,
I'm not sure I can help much further on this, the issues you are seeing
are
not applicable to a single server so I think you have some other
configuration issues.
It might be time to get a consultant in to check it out.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Rob Jones said:

Thanks for the insight Ben, but the exact same error occured.
I changed the content of the file as instructed, but had no idea how to
restore a previous OLAP.
Not sure if one is installed at setup, but I have never had a cube build.
Under the Analysis Server listing for database I have:

JPSS1\Databases\OLAPC1\Cubes

I used JPSS1 as the server and OLAPC1 as the database.

Ben Howard said:

Hi Rob,
I'm still surprised that you are getting this on a single server,
however,
try the following On the computer that is running SQL Server 2005
Analysis
Services, follow steps:
â€¢ Open SQL Server Management studio and open the Database Engine object
â€¢ Restore a previous OLAP repository database into a new databaseâ€¦
(i.e.
OLAPRepository) - hopefully you have one!
â€¢ Navigate to the C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Config\
and modify the msmdsrv.ini as follows:

Replace the DSO section with following, and change the SERVERNAME and
DATABASENAME to the name of the machine running the Analysis Services,
and
the database created in step 2 (i.e. OLAPRepository)

<DSO>
<RemoteRepositoryConnectionString>Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Data
Source=SERVERNAME;Initial
Catalog=DATABASENAME;</RemoteRepositoryConnectionString>
<RepositoryConnectionString>Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Data
Source=SERVERNAME;Initial
Catalog= DATABASENAME;</RepositoryConnectionString>
<RemoteLocksDirectory></RemoteLocksDirectory>
<LocksDirectory>C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\DSO9</LocksDirectory>
</DSO>

--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

:

Here is what comes across. Thxs for your help guys...

===== Initiating cube build process =====
[7/18/2007 8:09 AM] Cube build request message has been added to the
Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/18/2007 8:09 AM] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[7/18/2007 8:09 AM] Cube build initialization started
[7/18/2007 8:09 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/18/2007 8:09 AM] Cube build session started
[7/18/2007 8:09 AM] Analysis Services session started
[7/18/2007 8:09 AM] Analysis Services session failed with the
following
error: Failed to connect to the Analysis Services server jpss1. Error:
The
connection string to repository needs to be specified in the 9.0
server
properties (see <DSO>...</DSO> section in msmdsrv.ini file from
Analysis
Services 9.0).
===== Process Completed =====
[7/18/2007 8:09 AM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to connect to the
Analysis
Services server jpss1. Error: The connection string to repository
needs
to
be specified in the 9.0 server properties (see <DSO>...</DSO> section
in
msmdsrv.ini file from Analysis Services 9.0).

If both AS adn PS are on the same machine, then you don't need to
modify
the
connection string.
If you cannot build a cube, then please supply the errors you get
when
you
initiate a build.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

:

The connection string to repository needs to be specified in the
9.0
server properties (see <DSO>...</DSO> section in msmdsrv.ini file
from
Analysis Services 9.0).

Any ideas if the problem is because both componets SQL 2005,
Project
Server 2007 are running from the same server. The cube has never
built
by
the way. I had an Engineer over and he couldn't get it to run
either....lol

Click to expand...

Click to expand...

OLAP building on 2007

Rob

ahelp

Ben Howard

Rob

Ben Howard

Rob Jones

Ben Howard

Rob Jones