View Complete Post
After implement role security based on dimension security we get connection issues at the initial log on to our ssas cube.
Our environment is:
Windows Server 2008 SP2, x64
MS SQL Server 2008 Enterprise SP1
Processor: AMD Opteron 8381 HE (QuadCode 2,5GHz)
Memory: 8 GB
Relation database: about 18 GB
Multidimensional database: about 8 GB / 39 Dimension / 68 measure groups (some were needed to implement m:n relations)
Security model: 4 fact tables get 4 additional column e.g. Security1 with values “yes” and “no”.
A Role1 e.g. is able to see Security1 only “yes” facts. A Role2 e.g. is able to see Security2 only “yes”
I have a development server running Windows Server 2008 R2 with a Analysis Services 2008 R2 service running on it. But before going forward with releasing to production, I have one final issue and it's security.
I have two Analysis db roles created: one which has full access (Role1) and another to read the (only) cube and read dimensions and so forth (Role2). When a user is in Role1, the user can see the Analysis database and cubes, etc, but if I remove the user
from Role1 and leaving them only in Role2 without full control, the user can no longer even see the Analysis database.
The user can connect to the SSAS instance whether member of either roles which makes me think there are no networking issues. Running a trace I see the user correctly being identified and when the user is in Role1, everything is fine so I don't think it's
a possible authentication issue. It's worth mentioning that I have Kerberos configured and working properly as I can tell. But for trying to fix this problem, I'm logged into the server and running SSMS.
The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.
Word Automation in sample ASP.NET(C#) application.
I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.
When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.
But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.
Data: System.Collections.ListDictionaryInternalMessage: Word has encountered a problem.Source: Microsoft Word
The code gets failed in the following line:
ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line
I cannot able to proceed further. Can anybody please help me in solving this issue?