总结：Errors and Soluctions when redeploying cube

1.     The 'Proactive Caching' feature is not included in the 'Standard Edition'

 

The SQL Server 2008 R2 Standard Editon does NOT contain the “Proactive Caching” feature.

 

Help link,

a. http://msdn.microsoft.com/en-us/library/ms143761.aspx

b. http://support.microsoft.com/kb/941153

 

 

2.     Enabled CLR Stored procedures

 

Error

 

solution

 

EXEC sp_configure 'show advanced options' , '1';

reconfigure; EXEC sp_configure 'clr enabled' , '1' ;

reconfigure; EXEC sp_configure 'show advanced options' , '0';

reconfigure;

 

3.     EXTERNAL_ACCESS

 

Error

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.

 

Solution

 

--alter database "Master" set trustworthy on

4.     SID differs

 

Error

The database owner SID recorded in the master database differs from the database owner SID recorded in database 

 

Soluction

USE <DatabaseName>

GO

EXEC dbo.sp_changedbowner ‘sa’

 

Example

 

use FSD_ODS

go

 

--To get owner SID recorded in the master database for the current database

SELECT owner_sid FROM sys.databases WHERE database_id=DB_ID()

 

--To get the owner SID recorded for the current database owner

SELECT sid FROM sys.database_principals WHERE name=N'dbo'

 

 

SELECT * FROM sys.database_principals

 

Help link

 

http://blog.strictly-software.com/2009/09/database-owner-sid-recorded-in-master.html

 

 

5.     Find SQL Server Version

 

 

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

 

6.     Alter assembly visibility

 

Error

 

Solution

         -- ALTER ASSEMBLY [DataBase Name] WITH PERMISSION_SET = EXTERNAL_ACCESS

         ALTER ASSEMBLY [DataBase Name] WITH VISIBILITY = ON

 

Help link

 

 http://msdn.microsoft.com/en-us/library/ms186711.aspx