We just moved our database to a new server with a new name, got rid of the old server, and renamed the new server the same as the old one. I use the code below to display MDX statements on an asp page and since the switch over it displays the error

Microsoft® OLE DB Provider for Analysis Services error '80004005'
Database 'MyDatabaseName' does not exist.

Set cat = Server.CreateObject("ADOMD.Catalog"
Set cst = Server.CreateObject("ADOMD.CellSet"
cat.ActiveConnection = "Data Source=MyServerName;Initial Catalog=MyDatabaseName;Provider=msolap;

The database is there and SQLServer is set up for mixed mode authentication. Anybody have any other ideas? Thank you

I got the same message when I first tried connecting to an OLAP cube from
ASP, and was able to solve it by creating a role in the cube that gave the
appropriate people rights to view the cube. I hope this helps solve your
problem, if you haven't already solved it.

--Brian Foree


"Andrea Worley" <k_rage (AT) hotmail (DOT) com> wrote

code below to display MDX statements on an asp page and since the switch
over it displays the error: