Guys want to share a few points about the Voyager Connection(assuming this is a remote connection). You can assume this as the checklist before creating the connection.
Do the proper BO XI3 installation.
Add the License keys in CMC.
check the rights on MDAS server.
Check your(user) voyager connection rights.
Please make sure that the necessary services of the SQL server are running and test them by pinging from your system on which voyager is installed.
Check the cube is created in the MSAS and there are no Access rights on it.
Please make sure that you have the OLE DB provider service properly installed on the machine where MDAS server exists.
Make sure that you add the voyager user in MDAS>database>roles.
PLEASE PLEASE make sure that both the BO server and the MSAS 200x server are on the SAME domain. Else you CANNOT create the connection.
when you pass the server as cubefile then make sure that the cube is on the same system. If its elsewhere use Server as Server or URL. And when BO asks for credentials then please provide the credentials that you’ve used to login to the MSAS200x server machine.
I hope this is all required to check just before clicking the connect button on voyager connections page
If i’m missing out anything please add it its a request. As i know how it feels when you need the info and you crave get it in time.
Anyone who feels that this needs some amendments/corrections please do so.
A request to all of you who know how to make a topic sticky please make this sticky … as i can see many people are facing issues in voyager and not much help is available as people are still experimenting…
