In the link posted it gives 2 options, I choose option 2: Create the
repository by creating a SQL Server 2005 database.
In step # 5 what is the database name I'm entering? analysis Services
Repository?
...Select DSO\RepositoryConnectionString from the Name list.
1.Select the corresponding value for the string in the Value column, and
then click the box that appears to the right of the value to display the
Connection Manager page.
2.On the Connection Manager page, in the Provider list, select Native OLE
DB\SQL Native Client.
3.In the Server Name list, select the server on which the repository
database is located.
4.In the Logon to the server field, enter the account information to log
onto the server.
5.In the Connect to database section, select Select or enter a database name
and enter the name of the repository file.
6.Click OK.
Project Server Slave said:
Here it is:
<DSO>
<RemoteRepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\demahlit-w1\MSOLAPRepository$\msmdrep.mdb;Persist
Security Info=False</RemoteRepositoryConnectionString>
<RepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP
\DSO9\msmdrep.mdb;Persist Security Info=False</
RepositoryConnectionString>
<RemoteLocksDirectory>\\demahlit-w1\MSOLAPRepository$</
RemoteLocksDirectory>
<LocksDirectory>C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP
\DSO9</LocksDirectory>
</DSO>
:
I had an entry in my Msmdsrv.ini file but content was encrypted. I replaced
with what you had given but i still get the same error, when I opened the
file after trying to build the text is again encrypted. So I'm not sure what
is going on
:
i receive the following error when trying to build the cubes. Any ideas?
[5/31/2007 12:56 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to the
Analysis Services server DEMAHLIT-W1. 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).
I've followed all in this document -http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02...
I scanned the document and didn't see the part where you edit the
Msmdsrv.ini file file. Add the following into the <DSO> section of
this file:
<DSO>
<RemoteRepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.
4.0;Data Source=\\ComputerName\MSOLAPRepository$\msmdrep.mdb;Persist
Security Info=False</RemoteRepositoryConnectionString>
<RepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Program Files\Microsoft SQL Server\MSSQL.Number\OLAP
\DSO9\msmdrep.mdb;Persist Security Info=False</
RepositoryConnectionString>
<RemoteLocksDirectory>\\ComputerName\MSOLAPRepository$</
RemoteLocksDirectory>
<LocksDirectory>C:\Program Files\Microsoft SQL Server\MSSQL.Number\OLAP
\DSO9</LocksDirectory>
</DSO>
Be sure to update the network and local paths or it wont work. This
is usually the part that causes the error you are seeing for me. Let
me know if it worked. Good luck.
Derek,
It auto encrypts the file after you close it. You did update the DSO
text with the correct network and local paths didn't you? Can you
paste what you put in for your DSO section here?
Where did you get your msmdrep.mdb from?
