When the Discovery Center database has been detached then reattached to a SQL instance, or when the database has been restored from a backup; it can block the installation or usage of the library needed to communicate with SSAS.
Common Error Messages
An error similar to one of the following may be found in the application overview logs
The server may be running out of resources, or the assembly may not be
trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE
The database owner SID recorded in the master database differs from
the database owner SID recorded in database 'ActiveNav4'
While attempting to upgrade or install Discovery Center using an existing database, the installation fails and an error similar to the following can be found in the upgrade/installation log
An exception occurred while executing a Transact-SQL statement or batch. :
CREATE ASSEMBLY for assembly 'ActiveNavigation.SSASClient' failed
because assembly 'ActiveNavigation.SSASClient' is not authorized for
PERMISSION_SET = UNSAFE
Execution of user code in the .NET Framework is disabled.
Enable "clr enabled" configuration option
Resolution
To ensure CLR execution is enabled, run the following SQL command
sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO
To correct the security settings for the DLL used to interact with SSAS, run the following SQL query against the Active Navigation database.
Change the database name below so that it matches the name you are using in your system.
The example below uses the database name "ActiveNav4".
ALTER ASSEMBLY ANSSASClient WITH PERMISSION_SET = UNSAFE
ALTER AUTHORIZATION ON DATABASE::ActiveNav4 TO sa;
ALTER DATABASE ActiveNav4 SET TRUSTWORTHY ON;