Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Failed to Apply Usage Based Optimization for Aggregation Design

Posted on 2012-03-16
8
Medium Priority
?
1,027 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 25

Assisted Solution

by:TempDBA
TempDBA earned 2000 total points
ID: 37733452
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
ID: 37733460
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 2000 total points
ID: 37733478
Nope. Generally it should be visible in non-encrypted form.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:thomaszhwang
ID: 37733481
I know, but somehow it's just encrypted...

I can reset it, but a few days later.  It gets encrypted again...
0
 
LVL 25

Accepted Solution

by:
TempDBA earned 2000 total points
ID: 37733486
Are you by any chance using the "Encrypt=yes" property?
0
 

Author Comment

by:thomaszhwang
ID: 37733491
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
ID: 37738922
It turned out to be a permission issue.  Thanks anyway.
0
 
LVL 25

Expert Comment

by:TempDBA
ID: 37739236
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

636 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