http://www.sqlservercentral.com/blogs/samvangassql/2012/05/08/workspace-database-server-was-not-found/

Printed 2014/08/29 12:43PM

Workspace database server was not found

2012/05/08

You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It basically says, workspace database server ‘ServerName’ was not found.

image

You’ll have to change this setting from the model properties. The server should be an Analysis Services Server running in Tabular mode.

image

You’ll have to deal with this every time. It’s such a pain. Right? Fixing it for good is easy. Simply click on Tools, go to Options and expand Analysis Services. Change default workspace server and default deployment server to an Analysis Services server instance that’s running in tabular mode.

image

image

image

~Sam.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.