locked
Cannot create a connection to data source RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Hi,

     

    When I view a report, I get the error message:

    An error has occureed during report processing.

    Cannot create a connection to data source "data source name"

    Cannot open database "database name" requested by the login, The login failed, Login failed for user "username".

     

    The data source will connnect to my OLAP server and I believe I have right to access the OLAP server.

     

    Why the error occurred? Somebody can help me? Thanks very much!

    Tuesday, January 22, 2008 3:36 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have fixed this issue. Thanks for Vidhya's reply.
    Tuesday, January 22, 2008 7:27 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    Can you check the login used for OLAP connection, is the login have necessary privilege on the database you are trying to connect. 

    Check the default database for the login whether it has been set to the right database, if not change it to respective db. use the below query
    Code Block

    select name,dbname from syslogins where name='yourloginname'


    Check the OLAP database is Online. use the below query.
    Code Block

    select databasepropertyex('yourdbname','status')


    Tuesday, January 22, 2008 4:17 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Vidhya,

     

    Thanks for your reply.

    Actually the report is available before. Yeaterday, I changed my user's password and then the error is displayed.

    The OLAP server is OK because I can get the result if I execute the MDX which is used by my report on Analysis services,

     

    Tuesday, January 22, 2008 4:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I have fixed this issue. Thanks for Vidhya's reply.
    Tuesday, January 22, 2008 7:27 AM