Avatar of thomaszhwang
thomaszhwangFlag for United States of America asked on

Failed to Apply Usage Based Optimization for Aggregation Design

When I try to use the Usage Based Optimization to apply Aggregation Design to my measure group, it shows me the following error message.

The connection string cannot be found. Open Microsoft SQL Server Management Studio and, in the Analysis Server Properties page, check the value of the Log\QueryLog\QueryLogConnectionString property.

I encountered this error like two weeks ago.  At that time I just reset the connection string and every things seem to be fine.  A week ago, I successfully applied the Usage Based Optimization for one of my cubes.  However when I tried to apply UBO for my other cubes today, I encountered the same issue again!  I believe no one has changed the property of the connection string.

Also if I query the Query Log table, I can see those latest queries made by the users.  I'm sure the queries are still logging into this table.

This is really strange.  Anyone else has encountered the same issue?  Thanks.
Microsoft SQL Server 2008Microsoft SQL Server 2005Microsoft SQL ServerSSAS

Avatar of undefined
Last Comment
TempDBA

8/22/2022 - Mon
SOLUTION
TempDBA

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
thomaszhwang

I checked already.  The Connection String to the Query Log table is somehow encrypted.  I'm sure no one did that.  It must be something else trigger the encryption.  Any idea?
SOLUTION
TempDBA

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
thomaszhwang

I know, but somehow it's just encrypted...

I can reset it, but a few days later.  It gets encrypted again...
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
thomaszhwang

You mean in the connection string?

I don't even know we have that option.  I used the dialog to set the server name and database - that's it.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
thomaszhwang

It turned out to be a permission issue.  Thanks anyway.
TempDBA

Thanks thomas for sharing the answer.