Hello

I've written a program that uses DSO to connect to a MS-OLAP database.
Everything works fine on our development server, but it doesn't on our test
server.

When running the following test code:

DSO.Server oServer = new DSO.Server();
oServer.Connect("fooserver");
System.Diagnostics.Debug.WriteLine(oServer.Version );
oServer.CloseServer();

caught in a try/catch block, i get the following exception:

System.Runtime.InteropServices.COMException (0x80040033): Cannot connect to
the repository.

Analysis server: fooserver

Error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
at DSO.ServerClass.Connect(String ServerName)
at WindowsApplication1.Form2.button1_Click(Object sender, EventArgs e) in
d:\foo\windowsapplication1\form2.cs:line 109


The user that is trying to connect is part of the OLAP administrators group
on the server and has dbo rights on the msdbrep database(which is referenced
in the analysis server repository connection string). Using ADOMD i can
connect, but i need to do it with DSO.

I've also tried to register the test server, from analysis manager on the
dev server. When doing this i get: "cannot connect to analysis server , error
in data[possible data corruption]". I've read a lot of troubleshooting but
haven't found a solution for this either. (the dll versions match, sp3 is
installed, a local account exists on the analysis server, ..)

Mine is just one of many project running on this test server so
reinstallation is not an option.

I would greatly appreciate any help or advice.

Thanks

You may have other ACLs in-place which is stopping DSO from connecting. Try
using a domain user which is a machine administrator on both client and
server..
Also make sure that you have SP4 (or at least SP3) installed on *both* where
you are running the DSO application and on the Analysis server.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Steven Jonckheere" <Steven Jonckheere (AT) discussions (DOT) microsoft.com> wrote in
message news:6CD959DD-7FE0-497C-8667-63FF44A67F83 (AT) microsoft (DOT) com...