String Error SQL 2005

#1

Does anyone have an idea what could be wrong with the configuration of the
Database?

Quote:

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" <BenHoward (AT) discussions (DOT) microsoft.com> wrote in message
news:329C3936-B769-4356-AB8B-C468108245E0 (AT) microsoft (DOT) com...
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;Int egrated
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" wrote:

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" <BenHoward (AT) discussions (DOT) microsoft.com> wrote in message
news:7416E741-35D9-45E2-8A2C-530B9A9BC372 (AT) microsoft (DOT) com...
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/

"Rob" wrote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

String Error SQL 2005

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

String Error SQL 2005 - 07-19-2007 , 06:01 AM