You cannot open the BIM file. Reason : The workspace database server ‘localhost’

After installing Analysis Services Denali you might run into a problem when trying to create an instance for Tabular that is not the default instance for Analysis Services.

You cannot open the BIM file. Reason : The workspace database server 'localhost'
is not a SQL server version Code-Named "Denali" or later.

Well, everytime you create a new Tabular project there are 2 settings that have their default values sat to localhost.

Deployment Server properties

And the Model File property called Workspace Server

In the screenshots I’ve changed to my named instance of Denali .

If you want to modify that for all projects you can do it in Tools –> Options –> Analysis Service –> Default workspace Server

Now you should be able to create the tabular project.

If you still cannot connect, please check the running mode of your instance of analysis services. It has to be Tabular and not Multidimensional.

See here for more infos.

Happy analyzing !

Advertisements

2 comments

  1. Thanks. It was very helpful. You saved my time.

  2. Thanks. It was very helpful. You saved my time.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: