Creating a role in SSAS The Next CEO of Stack OverflowSSAS programmatically back up metadata onlyCreating SSAS partitions from an XML fileCreating ssas cube in xmla structureSSAS/AMO: How to get list of members of an attributeCan't recreate deleted SSAS databaseRefreshing SSAS Cube with XMLA scriptRunning SSAS XMLA queries in parallelRemote insert over DB2 linked-server results in Table / Eager Spool in the execution planImport XML into SQL server using OPENXML command with XMLNSSSAS creating cubes dynamically from XMLA
Why don't programming languages automatically manage the synchronous/asynchronous problem?
Proper way to express "He disappeared them"
What flight has the highest ratio of time difference to flight time?
Some questions about different axiomatic systems for neighbourhoods
Won the lottery - how do I keep the money?
Why does standard notation not preserve intervals (visually)
The past simple of "gaslight" – "gaslighted" or "gaslit"?
Chain wire methods together in Lightning Web Components
How to install OpenCV on Raspbian Stretch?
0 rank tensor vs 1D vector
Is the D&D universe the same as the Forgotten Realms universe?
"misplaced omit" error when >centering columns
Why do airplanes bank sharply to the right after air-to-air refueling?
Can you be charged for obstruction for refusing to answer questions?
Would a completely good Muggle be able to use a wand?
What connection does MS Office have to Netscape Navigator?
How to avoid supervisors with prejudiced views?
Why do remote US companies require working in the US?
How to invert MapIndexed on a ragged structure? How to construct a tree from rules?
Newlines in BSD sed vs gsed
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
When you upcast Blindness/Deafness, do all targets suffer the same effect?
Flying from Cape Town to England and return to another province
Bartok - Syncopation (1): Meaning of notes in between Grand Staff
Creating a role in SSAS
The Next CEO of Stack OverflowSSAS programmatically back up metadata onlyCreating SSAS partitions from an XML fileCreating ssas cube in xmla structureSSAS/AMO: How to get list of members of an attributeCan't recreate deleted SSAS databaseRefreshing SSAS Cube with XMLA scriptRunning SSAS XMLA queries in parallelRemote insert over DB2 linked-server results in Table / Eager Spool in the execution planImport XML into SQL server using OPENXML command with XMLNSSSAS creating cubes dynamically from XMLA
I have a role that has been working fine for a while. The only user added to that role was a local user set up on the server called Cube. However all of a sudden the membername for that user against the role is the SID not the value LocalServerCube. When i manually remove the broken user from the role and re-add LocalServerCube this fixes the problem. However right-click - alter to on the role and set the value in the script, to LocalServerCube, it doesn't fix the issue.
<Alter ObjectExpansion="ExpandFull" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<RoleID>Role 80</RoleID>
<DatabaseID>OLAPCubes</DatabaseID>
</Object>
<ObjectDefinition>
<Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
<ID>Role 80</ID>
<Name>Cube</Name>
<Members>
<Member>
<Name>LocalServerCube</Name>
<Sid>S-1-5-21-3067301217-1800892027-3952499395-1116</Sid>
</Member>
</Members>
</Role>
</ObjectDefinition>
Do you know why this might be? There are two issues here, what would cause it to change in the first place and can i create a script to change this again should it happen again.
sql ssas xmla
add a comment |
I have a role that has been working fine for a while. The only user added to that role was a local user set up on the server called Cube. However all of a sudden the membername for that user against the role is the SID not the value LocalServerCube. When i manually remove the broken user from the role and re-add LocalServerCube this fixes the problem. However right-click - alter to on the role and set the value in the script, to LocalServerCube, it doesn't fix the issue.
<Alter ObjectExpansion="ExpandFull" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<RoleID>Role 80</RoleID>
<DatabaseID>OLAPCubes</DatabaseID>
</Object>
<ObjectDefinition>
<Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
<ID>Role 80</ID>
<Name>Cube</Name>
<Members>
<Member>
<Name>LocalServerCube</Name>
<Sid>S-1-5-21-3067301217-1800892027-3952499395-1116</Sid>
</Member>
</Members>
</Role>
</ObjectDefinition>
Do you know why this might be? There are two issues here, what would cause it to change in the first place and can i create a script to change this again should it happen again.
sql ssas xmla
add a comment |
I have a role that has been working fine for a while. The only user added to that role was a local user set up on the server called Cube. However all of a sudden the membername for that user against the role is the SID not the value LocalServerCube. When i manually remove the broken user from the role and re-add LocalServerCube this fixes the problem. However right-click - alter to on the role and set the value in the script, to LocalServerCube, it doesn't fix the issue.
<Alter ObjectExpansion="ExpandFull" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<RoleID>Role 80</RoleID>
<DatabaseID>OLAPCubes</DatabaseID>
</Object>
<ObjectDefinition>
<Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
<ID>Role 80</ID>
<Name>Cube</Name>
<Members>
<Member>
<Name>LocalServerCube</Name>
<Sid>S-1-5-21-3067301217-1800892027-3952499395-1116</Sid>
</Member>
</Members>
</Role>
</ObjectDefinition>
Do you know why this might be? There are two issues here, what would cause it to change in the first place and can i create a script to change this again should it happen again.
sql ssas xmla
I have a role that has been working fine for a while. The only user added to that role was a local user set up on the server called Cube. However all of a sudden the membername for that user against the role is the SID not the value LocalServerCube. When i manually remove the broken user from the role and re-add LocalServerCube this fixes the problem. However right-click - alter to on the role and set the value in the script, to LocalServerCube, it doesn't fix the issue.
<Alter ObjectExpansion="ExpandFull" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<RoleID>Role 80</RoleID>
<DatabaseID>OLAPCubes</DatabaseID>
</Object>
<ObjectDefinition>
<Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
<ID>Role 80</ID>
<Name>Cube</Name>
<Members>
<Member>
<Name>LocalServerCube</Name>
<Sid>S-1-5-21-3067301217-1800892027-3952499395-1116</Sid>
</Member>
</Members>
</Role>
</ObjectDefinition>
Do you know why this might be? There are two issues here, what would cause it to change in the first place and can i create a script to change this again should it happen again.
sql ssas xmla
sql ssas xmla
asked Mar 8 at 15:46
Chris SparkesChris Sparkes
83
83
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I believe this is a problem with the SID not getting translated and not displaying the friendly name, most likely caused by a network issue because it's timing out when retrieving the friendly name for the SID from the Domain Controller .
Perhaps you can try to add them to "Allowed RODC Password Replication Group" if you have access .
Debugging this might require you to analyze the network trace .
Please check below link for more info :
https://blogs.technet.microsoft.com/askds/2011/07/28/troubleshooting-sid-translation-failures-from-the-obvious-to-the-not-so-obvious/
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55066601%2fcreating-a-role-in-ssas%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I believe this is a problem with the SID not getting translated and not displaying the friendly name, most likely caused by a network issue because it's timing out when retrieving the friendly name for the SID from the Domain Controller .
Perhaps you can try to add them to "Allowed RODC Password Replication Group" if you have access .
Debugging this might require you to analyze the network trace .
Please check below link for more info :
https://blogs.technet.microsoft.com/askds/2011/07/28/troubleshooting-sid-translation-failures-from-the-obvious-to-the-not-so-obvious/
add a comment |
I believe this is a problem with the SID not getting translated and not displaying the friendly name, most likely caused by a network issue because it's timing out when retrieving the friendly name for the SID from the Domain Controller .
Perhaps you can try to add them to "Allowed RODC Password Replication Group" if you have access .
Debugging this might require you to analyze the network trace .
Please check below link for more info :
https://blogs.technet.microsoft.com/askds/2011/07/28/troubleshooting-sid-translation-failures-from-the-obvious-to-the-not-so-obvious/
add a comment |
I believe this is a problem with the SID not getting translated and not displaying the friendly name, most likely caused by a network issue because it's timing out when retrieving the friendly name for the SID from the Domain Controller .
Perhaps you can try to add them to "Allowed RODC Password Replication Group" if you have access .
Debugging this might require you to analyze the network trace .
Please check below link for more info :
https://blogs.technet.microsoft.com/askds/2011/07/28/troubleshooting-sid-translation-failures-from-the-obvious-to-the-not-so-obvious/
I believe this is a problem with the SID not getting translated and not displaying the friendly name, most likely caused by a network issue because it's timing out when retrieving the friendly name for the SID from the Domain Controller .
Perhaps you can try to add them to "Allowed RODC Password Replication Group" if you have access .
Debugging this might require you to analyze the network trace .
Please check below link for more info :
https://blogs.technet.microsoft.com/askds/2011/07/28/troubleshooting-sid-translation-failures-from-the-obvious-to-the-not-so-obvious/
answered Mar 12 at 10:15
Catalin AndreiCatalin Andrei
465
465
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55066601%2fcreating-a-role-in-ssas%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown