Can't create new datasource

I installed analysis services this last week and now when I try to add a new
data source in reporting services I get an error that says The OLE DB
provider SQLOLEDB has not been installed or is not valid. Do you wan tto
reset the connect string? It has a cancel and an OK button but no matter
which one you push it does nothing. It was working before I did the install
and when I did the install I just took the defaults and loaded up the latest
service pack. Any suggestions?
Thanks,
MelissaMy guess is that MDAC is messed up. One thing you might try is re-installing
the service pack for SQL Server. Either that or try re-installing the
appropriate version of MDAC.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Melissa" <Melissa@.discussions.microsoft.com> wrote in message
news:70F08879-5220-4681-9E31-852F7D542D4D@.microsoft.com...
> I installed analysis services this last week and now when I try to add a
new
> data source in reporting services I get an error that says The OLE DB
> provider SQLOLEDB has not been installed or is not valid. Do you wan tto
> reset the connect string? It has a cancel and an OK button but no matter
> which one you push it does nothing. It was working before I did the
install
> and when I did the install I just took the defaults and loaded up the
latest
> service pack. Any suggestions?
> Thanks,
> Melissa