It worked yesterday but it's not working today.. No changes were made to the system.
But when I click on "NEW QUERY" button, it does not connect to the Database Engine.
When I click on "Connect" button, Server type is greyed out and is fixed on Analysis Services.
The only place where I am able to modify is Server Name, but it wouldn't help at all because the Server Type is fixed onto Analysis Services.
I am able to connect to the server though, I can see the tables from the object explorer. But I can't query anything.
I'm extremely frustrated and have no idea why this is behaving tihs way..
Also, a metadata started to show up whenver I open up a new query window...
Can anyone help?