thomaszhwang
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\QueryLogConne ctionStrin g 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.
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\QueryLogConne
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I know, but somehow it's just encrypted...
I can reset it, but a few days later. It gets encrypted again...
I can reset it, but a few days later. It gets encrypted again...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
I don't even know we have that option. I used the dialog to set the server name and database - that's it.
ASKER
It turned out to be a permission issue. Thanks anyway.
Thanks thomas for sharing the answer.
ASKER