thanks for the response.

I have not done any operation on the DB and don't know which application process caused this thats why I am trying to find the cause.

Thanks for your reply Brian!

I think I could not put the question correctly.

My requirement is like this:

Currently, I have one node (TS1SQL01) and there is default SQL instance installed...

Thank you so much for the correct information. 

Do I need to do the registry changes on 32-bit server?

And also do you have any link for the fix in microsoft...

Drillthrough is enabled on the cube but still there is access denied on the cube

-SN

Thanks for your response Steve!

I have enabled the drillthrough on the Cube Role and I don't know if there is any other place where I can enable this. Sorry if I...

Hi,

Can you please send me the scripts and are you following BOL methods for role reversal ?

Thanks for the help.

--snt

Hi ken,

Not in the source only on the destination database.

--Snt

the jobs takes 5-10 mintutes but simultaneoulsy it should run daily at particular time. Any suggestions will be appreciated.

--sntiwary

Can someone confirm that. Is login distributor_admin  is mandatory for remote distribution in windows Authentication. since if distribution is local distributor_admin is not required.

thanks a lot so, what I got from your statement that sql login distributor_admin is mandatory for both windows and mixed authentication. pls confirm.

I have little doubt as you have mentioned distributor_Admin passqword is not necesary, So what i understood from your reply that distributor_Admin sql login is required  even in windows authentication?

thanks a lot.

Can you please tell how to  configure the publisher to connect to the distributor if we have windows authentication. since while setup replication even I am using windows...

thanks a lot for the infiormation

--sntiwary

Thanks to stacenic & racosta for the help and your clarification!!

From your message what I understood is that if I am replicating both the tables related to Foreign key...

thank for reply. So you mean we cannot replicate the tables with foreign key or subscribers cannot have referential integrity. I Checked a KB article which tells:

When applying the snapshot, the...