Dear Friends,
I am working on configurating Microsoft Business Analytics.
I am not able to integrate Microsoft SQL Server 2005 with MS Dynamics Navision through BA Configurator. When I tried to Start the Configurator, the process is getting stopped at "Create Analysis Services Database" and an error message "Configurator has encountered a problem and needs to close" is getting displayed.
I would request you to help me in solving the above said problem.
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
The BA.log file executed during the process of start BA Configurator is as follows:
Language: w1
Database: BA-Demo
Dynamics NAV version: 5
5:12:45 PM: Initialize
Read XML
5:12:45 PM: Check for SQL Server 2005
5:12:46 PM: Check for Analysis Services 2005
5:12:48 PM: Installation started
5:12:48 PM: Build Internal Representation
Companies
Enumerations
Shared Dimensions
Cubes
Reference Dimensions
Virtual Cubes
Transfer
Period Table Tasks
5:12:49 PM: Install Custom SSIS Tasks
Uninstalling
Installing
5:12:54 PM: Create SQL Server Database
Drop database "BA for MBS Navision"
Create database "BA for MBS Navision"
Create table "eEntryType"
Create table "eDocumentType"
Create table "wADArea"
Create table "wADCustomerGroup"
Create table "nCustomer"
Create table "nCurrency"
Create table "nSourceCode"
Create table "nDimensionValue"
Create table "nLedgerEntryDimension"
Create table "nSalesLine"
Create table "nDetailedCust_Ledg_Entry"
Create table "wLedgerEntryDimensionDetailed Cust_ Ledg_ Entry"
5:13:04 PM: Create SSIS Package (Part 1)
Create sequence "Initialize"
Create Data Flow "Transfer" (Demo DB Company)
Create pump Customer
Create pump Currency
Create pump Source Code
Create pump Dimension Value
Create pump Ledger Entry Dimension
Create pump Sales Line
Create pump Detailed Cust_ Ledg_ Entry
Create sequence "Post Process"
5:13:09 PM: Execute SSIS Package
Execute package "BA for MBS Navision"
5:15:49 PM: Create SSIS Package (Part 2)
Create sequence "Process Cubes"
5:15:49 PM: Create SQL Server Agent Job
Create job "BA for MBS Navision"
5:15:50 PM: Create Analysis Services Database
Drop database "BA for MBS Navision"
Create database "BA for MBS Navision"
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I want to know whether Business Analytics Advance works only when BA Basic runs successfully.
When I installed BA Basic, the BA Configurator runned successfully but a "Role" has not been created in the Analysis Services. Same time I installed BA Advance with all the necessary setups given in the Microsoft Business Analytics Technical White Paper and when i opened the BA Configurator and gave my server name in the Log on to field, an error message "Cannot connect to the Server "my server name". The Server is either not started or too busy" is displayed. I restarted the Analysis Server again and tried but the problem has not been rectified.
I would like anyone of you to tell me what the problem is.
Thanks