THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Change default workspace and deployment server in #Tabular #SSAS #Denali #CTP3

When you install Analysis Services Denali, chances are that you create an instance for Tabular that is not the default instance for Analysis Services. When you try to create a Tabular project, you might get the following error:

You cannot open the BIM file. Reason: The workspace database server ‘localhost’ was not found. Verify that there is an Analysis Services server instance running on ‘localhost’ in VertiPaq mode.
To change the workspace database server for the selected BIM file ‘Model.bim’, in Solution Explorer, select the BIM file ‘Model.bim’ and then in the Properties window, change the workspace database server.

Every time you create a new Tabular project, you have two settings that, by default, point to the default localhost instance (which you might not have at all if, like me, you never install a default instance on your development machine):

  • The Deployment Server, which is defined in the project properties

SNAGHTMLdd9aba2

  • The Workspace Server, which is a property that is included in the BIM file

image

As you can see, in the previous screenshot I changed these settings to my SSAS Tabular instance (localhost\denali).

If you want to change the default settings for any new project, in order to avoid the error message I previously mentioned, you have to go in the Tools\Option dialog box and in the Analysis Services \ Data Modeling and Analysis Services \ Deployment settings you can set the corresponding default values for Workspace Server and Deployment Server.

SNAGHTMLddc1f2c

SNAGHTMLddbeff2

I have to learn that this is the first thing to do as soon as I will setup any new development workstation for BISM Tabular.

Published Wednesday, July 20, 2011 10:01 AM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Fabrizio Paravisi said:

Thank you very much!!

January 25, 2012 9:06 AM
 

namrata said:

Hi,

I would like to know what exactly the Build Action property and the copy to output directory property does?Is there a particular way you should set them?

November 13, 2013 6:27 AM
 

Marco Russo (SQLBI) said:

The Build action creates an .asdatabase file that you can use with Deployment Wizard to deploy the project on a server changing several parameters (like connection to data sources) without opening Visual Studio.

November 13, 2013 7:43 PM
 

namrata said:

Thanks Marco.That was very helpful. But what does the copy to output directory property do?? what exactly is the source file that it copies to the output directory??is it the same .asdatabase file that is the source file?? I am fairly new to SSAS Tabular Model.

November 13, 2013 11:42 PM
 

Marco Russo (SQLBI) said:

There are a few differences in XMLA - the output directory contains what you can deploy as XMLA script, whereas the local BIM file has probably a slightly different format - I never investigated too much in these differences.

November 14, 2013 2:43 AM
 

namrata said:

Thanks.

November 18, 2013 12:09 AM

Leave a Comment

(required) 
(required) 
Submit

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement