Solved

Failed to Apply Usage Based Optimization for Aggregation Design

Posted on 2012-03-16
8
924 Views
Last Modified: 2016-02-15
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.
0
Comment
Question by:thomaszhwang
  • 4
  • 4
8 Comments
 
LVL 25

Assisted Solution

by:TempDBA
TempDBA earned 500 total points
Comment Utility
Would you mind just reviewing your connectionstring while applying the aggregation design to the measure group. May be something fishy is going on there.
0
 

Author Comment

by:thomaszhwang
Comment Utility
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?
0
 
LVL 25

Assisted Solution

by:TempDBA
TempDBA earned 500 total points
Comment Utility
Nope. Generally it should be visible in non-encrypted form.
0
 

Author Comment

by:thomaszhwang
Comment Utility
I know, but somehow it's just encrypted...

I can reset it, but a few days later.  It gets encrypted again...
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 25

Accepted Solution

by:
TempDBA earned 500 total points
Comment Utility
Are you by any chance using the "Encrypt=yes" property?
0
 

Author Comment

by:thomaszhwang
Comment Utility
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.
0
 

Author Closing Comment

by:thomaszhwang
Comment Utility
It turned out to be a permission issue.  Thanks anyway.
0
 
LVL 25

Expert Comment

by:TempDBA
Comment Utility
Thanks thomas for sharing the answer.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now