Migrate repository to SQL database, and give user access to that database( Not sure what is the min. access user need to have to this DB). Or try giving OLAP...

Thanks, John & Andy. This sounds good and really helpful.

Now since you mentioned about service Pack and hot fixes before upgrade here is what I am thinking.

- Take backups.

-...

Sorry John, but I didn't really understand how your suggestion was different than Andy's except for the renaming Master, msdb.

First of all why do we need to even rename...

There is other forum for Analysis service, this is probabley not a right place.

GO on the machine where you installed Analysis service, and go in users and group management. Click...

Set your QA to display results in text. Then run following Query.

select 'grant execute on '|name|' to yourusername' from sysobjects where type='sp'

Take the Results of this query and copy in...

Not sure how I can monitor MDAC activity.

-I have 7.00.1063(SP4) on this machine.

-When I go in ODBC panel in this machine, I see named pipes, TCP/IP and multiprotocol library.

Thanks for...

Thanks, racosta.I was more leaning towards registry since this has lot to do with that but I finally found solution.

It's microsoft bug #12647. Came out last month.

This KB article describes...

I installed Same Analysis services on other server and I was able to connect to that server. Are there any registry settings that I need to change to connect with...

Check if owner of the job, that runs packages has changed or privileges to this owner has changed.

I have same problem. I couldn't find the solution but here is my post. May be you can use the suggestions made here and may be it will work for...

Allen,

Tried that too. Didn't work.

Thanks.

Thanks everyone for your response.

This is what I am at now.

I don't have builtin/admin account in SQl logins.

I added NT authority/system account in sql logins and gave sysadmin rights.

Microsoft...

I don't get this. I added

'Nt Authority\System' account and gave SA priv. to this account. Microsfot search service is up and running under local system account. Still no change....

Yes, I did remove builtin\admin account. I do have Microsoft search services and they are running.

If I add 'Nt Authority\System' account and give SA privileges to account, who exactly gets...

Has the sa password changed recently?