Skip to Content
avatar image
Former Member

Failed to get connections for connection using session locale [English]

Hello I'm posting this because i havent been able to solve the problem, the context is, I'm trying to add a new connection for analysis services 2008 and then  this happens:

Enter User Name & Password to log on to the data source:

"Failed to get connections for connection using session locale [English]"

This is in the BusinessObjects Intelligence platform 4.0 SP04 FP03.

Operative Sytem: Windows Server 2008 R2, 64 bits
Database: SQL Server 2008 R2

Symptom

"Failed to get connections for connection using session locale
[English] is raised when creating an OLAP connection in CMC to be used
in Advanced Analysis

I Attach the picture that show the issue.


Hope you could help me,


Regards
Roberto,

   

Steps for Reconstruction - Reproducing the Issue

In the CMC create a new Microsoft Analysis Services OLAP connection
without specifying a cube and Authentication equal to Prompt
Enter User Name & Password to log on to the data source -> "Failed to
get connections for connection using session locale [English]" is
raised.


Note. The issue happens with one specific environment, other BW
environments patched at the same level do not raise this error. The
Adaptive Processing Server log file shows the error.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 07, 2012 at 10:05 AM

    Hi Roberto Bernal,

    Don't use SQL Authenticated user credentials.

    In Server Information:

    Enter IP/Server Name in SERVER field.

    Use the Windows server system credentials to login Server.

    Configuring BI4.0 Connection: Advanced Analysis to Microsoft Analysis Services 2008R2

    http://blog.davidg.com.au/2011/03/configuring-bi40-connection-advanced.html

    For Microsoft SQL Server 2008 R2 Native Client and

    Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2008 R2

    Refer the below link.

    http://www.microsoft.com/en-in/download/details.aspx?id=16978

    I hope this will helps you.

    Regard,

    Pardhu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Good morning all,

      I read this thread and I have the same problem. In case of Windows Authentication on IIS side, I receive the message "Failed to get connection ..". We have a BOBJ 4.0 SP4 installation. SQL server is SSAS2008. Both system runs on a Windows 2008 R2 operating system.

      Anyone solved this issue?

      Thanks for the support