Additional Business Analytics database/server

Arhontis

Hello everyone,

I have already installed BA and it works ok, but I want to create a second server that will work with another client navision database.

I have created the second analysis services database and the corresponding database in sql server.

I have used another computer to install the ba services (ANTserver) and to "look" at the other computer analysis services database, but it doesn't seem to connect. I get the error "The network connection was aborted by the local system" from the client application (BA) and in the server application event viewer the error: "Login faailed for user '(null)': Not associated with a trusted SQL Server connection."

The ANTServer uses a windows domain login that is also an administrator to the other computer (server).

Has anyone done something like this? I mean to use the ANTServer from another computer to access database of another computer?

Any help would be great appreciated...