Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Unable to archive Analysis Service database

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2007-03-07 : 06:12:38
Hello.

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.

Thanks & Regards.

-J
   

- Advertisement -