Can’t open a database using VBA

[Daniel]

Hello,

I am trying to read into the Published project database but I am not able to
open it
My connection string looks like that:
Conn.Open "Provider=sqloledb;Data Source=MyServer;Initial
Catalog=MyPublishedDB;Integrated Security=SSPI"

And I got the message: Runtime error ‘-12147217843 (80040e4d)’: Automation
error

On the other hand I have no problem when opening the OLAP database:

Conn.Open "Provider=MSOLAP;Data Source= MyServer;Initial Catalog=MyOlapDB;"

So what’s wrong?

PS: it’s project 2007 and I have administrator rights for project and PWA
(not on the server)

 

[Lars Hammarberg]

By default, all communication between your client and the project databses
goes through PWA using PSI calls. PWA is then accessing the databases - you
most probably do not have access to the sql server databses using your NT
account.
This has nothing to do with your security rights within the PWA application.

When accessing OLAP data, on the other hand, you have to have access to the
cubes via your NT account. When creating the cubes, PWA automatically creates
an access role on the analysis database into which PWA users with the
appropriate access are entered.
The reason for this is that Analysis Services requires NT authentication
from the client directly and not through an impersonation proxy.