What is SSAS error "An unexpected exception occurred" or 0xC1000016

When working with SQL Server Analysis Services, it is not uncommon to see this error message “An unexpected exception occurred”. This is the most misunderstood message in SSAS. If you try to search this particular error message, you can get quite a lot of hits in the search engine. An Internet results can come back…

1

Timeout expired while publishing to SQL Database via SSDT

We recently saw some cases where customer migrated their SQL Database to Basic edition. After the migration they get the following error while attempting to publish their database via SQL Server Data Tools (SSDT) in Visual Studio 2013 Failed to import target model …Unable to reconnect to database Timeout Expired. The timeout period expired prior…