Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Red face Unanswered: Unable to archive Analysis Service database

    Hi

    For strange reasons, I am now unable to backup (archive) any of the databases in Analysis Service.

    When I try to archive, I get a dialog box with the following error:

    "[MicroSoft][ODBC Driver Manager] Data source name not found and no default driver specified"

    I am able to process my cubes and dimensions and am totally lost as to why I'm getting this problem

    Will appreciate your help.

    Thanks.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    is there a DataSource in your AS database that's messed up perhaps?

  3. #3
    Join Date
    Oct 2003
    Posts
    163
    That is exactly what I am trying to find out... I have checked all ODBC connections and also the data source definition for my databse in analysis service but everything is fine (at least everything appears to be fine since all "test connection" get passed)...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •