Business Analytics Configurator permissions

Maci

I think you can help me, thanks in advance.

Scenario:
Server W2K3 + SP1
SQL 2000 Server + SP4, Analisis Services and Business Analitics
BD Navision 4.00 on this SQL

If I execute BAconfigurator from a navision client, installed on this server, everything works fine.

When I try to execute this from another computer on the domain, it fails. In this another computer is navision client installed, and the directory where is configurator on the server, is shared. I try whith the route \\srv\dir... and with a letter I:\dir .... and dont work.

In this installation we have a problem with the security: is huge! I install a remote desktop to the server, to start navision client and run configurator, but it only work if the domain user is Local Administrator in the server That is the problem. The IT customer´s department don´t want this user Local Administrator :evil: ... and I finish my ideas to try... ](*,) ](*,) ](*,)

Is this posible? I supose is not the unique installation from BA where the configurator is running from a computer different than the server.

Thanks

kine

1) BA Basic must be run on the server, where Analysis Services are installed (where the cube will be created).

2) a) Open "My Computer" - "Properties" (or hotkey Win+Break)
b) tab "Remote" - "Select remote users" button
c) Add group or users you want to have access through remote desktop to this PC (of course, there are just 2 sessions)

Maci

Hi

1) Yes, but our customer was bought the BA Advanced. Is there the same restriction in advanced?

2) I try this, and this only works when remote user is "Local Administrator" from the server, because in a moment, when the configurator runs, is an "installation" (.msi) file, and with just "Power user" permission don´t work. My question now is, is there a posibility with another permisions lower than "Local Administrator"? :-k

Thanks

kine

1) BA Basic (generator of the cubes from Navision) MUST be run on the same machine, because whole process depend on it (the configurator is assuming that and is creating the cubes on local machine, if DB server is another PC, than it can work, but if it is MS SQL server, you need some change in C/AL code running the configurator (there is one parameter passed to the configurator, and this parameter is based on Session table, but this is wrong, because in session table is your PC, not server PC...). After generating the cube, you can connect BA Advance (ANT server) to this cube through BA Adv. Configurator (Configurator runned from install cd), or through BA Enterprise manager through changing connect string. But you need to run BA Adv. configurator once to be able to select Navision client folder and from there BA Adv. conf. will take your Navision license file (fin.flf) and wil change from demo to correct license... uff... believe me, it is not so easy to describe it, but it is easy to do it...

2) Configurator itself does not run some .msi! If yes, there is something missing...BA Advance configurator can be run as "BAConfigurator40.exe; -lw1 -mAdvanced" (w1 can be another language, e.g. cs is Czech). This will run BAConfigurator advance and will setup the ANT Server for you (you need to run it each time you change the cube through BA Basic). Of course, because it is working with SQL database and SQL AS cubes, you need to set appropriate permissions for the user in SQL and Analysis services...