Home > Archive > MS SQL Server OLAP > March 2006 > error '80004005' Database 'provincia' does not exist.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author error '80004005' Database 'provincia' does not exist.
jsbecker

2006-03-31, 8:26 pm

Hi,
have a web page on a web server that pulls data from a cube on another

server that has SQL Server Analysis Serivces installed. When I try to
establish the connection I get the following error:

Microsoft=AE OLE DB Provider for Analysis Services error '80004005'


Database 'Provincia' does not exist

When i try to establish the connection with Database FoodMart 2000 I
have no problem so I think that I have a problem with roles or
permissions.

Any Suggest ?

Thank you very much

Julio Sanchez Becker
BI Consulting.

Darren Gosbell

2006-03-31, 8:26 pm

You get symptoms like this when you try to access AS 2000 using the old=20
Olap Services 7.0 driver. (Foodmart seems to be accessible because it=20
was upgraded from this version)

Check that your connection string is using MSOLAP or MSOLAP.2 as the=20
provider (not MSOLAP.1).

The other thing you could do is to try installing the PTSLite.exe that=20
came with the Service Pack that you currently have on your AS server.=20
This file contains the latest OLEDB provider for Analysis Services.

--=20
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell


In article <1143835136.155220.251700@z34g2000cwc.googlegroups.com>,=20
eltopi@gmail.com says...
> Hi,
> have a web page on a web server that pulls data from a cube on another
>=20
> server that has SQL Server Analysis Serivces installed. When I try to
> establish the connection I get the following error:
>=20
> Microsoft=AE OLE DB Provider for Analysis Services error '80004005'
>=20
>=20
> Database 'Provincia' does not exist
>=20
> When i try to establish the connection with Database FoodMart 2000 I
> have no problem so I think that I have a problem with roles or
> permissions.
>=20
> Any Suggest ?
>=20
> Thank you very much
>=20
> Julio Sanchez Becker
> BI Consulting.
>=20
>=20

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com