Other user unable to access web site.User able to connect to sql 2k when
there trying to access analysis server,it is throwing olap doesn't exists
error.We using windows authentication on IIS and my connection string for
olap is PROVIDER=MSOLAP.2;DATA SOURCE=WS-Server;INITIAL
CATALOG=TMOLAP4;ConnectTo=8.0.

olap is sitting on win 2003 server and msxml 4.0 is installed.


Thanks,
Arun

PROVIDER=MSOLAP.2; in your connection string means that you are using
version 2000 of Analysis Services OLEDB provider and you can use it only to
connect to Analysis Services 2000 and not 2005.

If you need to establish connection to Analysis Server 2005 you should use
PROVIDER=MSOLAP - this will force using latest installed OLEDB version on
your machine or you can specify PROVIDER=MSOLAP.3 - in this case you are
guaranteed to use version 2005.

Edward Melomed
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"arun_rote" <u16842@uwe> wrote