总结: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