SSRS 2008 R2 domain user assigned for role but cannot accessHow do I give access to SQL Server 2005 Reports for users outside domain without using FBADomain User Access to SQL Server Reporting Services 2005 on IIS7SSRS Security SchemeTFS 2010 - Project Creation FailsAdding, removing or editing permissions of a user in SSRS 2008 is throwing error “”Response is not well-formed XMLSSRS2008R2 report times out, but the underlying query executes in the Management StudioDeploying reports to report serverIssue with Reporting Services - rsreportserver.config is deniedSQL Reporting Services Report Manager cannot be accessed by IP on the local computerCan't connect to SSRS Report Manager: Insufficient access
Have I damaged my car by attempting to reverse with hand/park brake up?
Using column size much larger than necessary
Why do people keep telling me that I am a bad photographer?
Shantae Dance Matching
Randomness of Python's random
How should I tell my manager I'm not paying for an optional after work event I'm not going to?
Position of past participle and extent of the Verbklammer
How do I overfit?
What does this colon mean? It is not labeling, it is not ternary operator
What property of a BJT transistor makes it an amplifier?
Upside-Down Pyramid Addition...REVERSED!
How important is people skills in academic career and applications?
Are there any Final Fantasy Spirits in Super Smash Bros Ultimate?
Why is Arya visibly scared in the library in S8E3?
Pressure inside an infinite ocean?
What is the most remote airport from the center of the city it supposedly serves?
Would the Disguise Self spell be able to reveal hidden birthmarks/tattoos (of the person they're disguised as) to a character?
I need a disease
How to model the curly cable part of the phone
Why isn't nylon as strong as kevlar?
In Avengers 1, why does Thanos need Loki?
Why Isn’t SQL More Refactorable?
How was the quadratic formula created?
Why doesn't WotC use established keywords on all new cards?
SSRS 2008 R2 domain user assigned for role but cannot access
How do I give access to SQL Server 2005 Reports for users outside domain without using FBADomain User Access to SQL Server Reporting Services 2005 on IIS7SSRS Security SchemeTFS 2010 - Project Creation FailsAdding, removing or editing permissions of a user in SSRS 2008 is throwing error “”Response is not well-formed XMLSSRS2008R2 report times out, but the underlying query executes in the Management StudioDeploying reports to report serverIssue with Reporting Services - rsreportserver.config is deniedSQL Reporting Services Report Manager cannot be accessed by IP on the local computerCan't connect to SSRS Report Manager: Insufficient access
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have SSRS 2008 R2 installed on my server and need to deploy report from Business Intelligence Studio at another computer which is in the same domain and under domain user (non-administrator).
First I get the error "Unsufficient permissions". Then I started Report Manager at the server (http://localhost/Reports/) and under Site Settings / Security added my domain user to both System Administrator and System Users roles, restarted the service, but still got the same error.
Then I created a folder in Report Manager and added domain user to all available roles for that (Browser, Publisher, etc.). After that it doesn't show that error in BIS but instead shows the login dialog (though I already logged as domain user in Windows). I enter login and password but it just asking it again and doing nothing. Tried to enter administrator login details but it also just shown again.
Could you advice me how to enable access to the service or at least to some folder for non-administrator domain user?
ssrs ssrs-2008-r2
asked Dec 4 '12 at 8:09
Aleksey ShubinAleksey Shubin
131113
add a comment |
I have SSRS 2008 R2 installed on my server and need to deploy report from Business Intelligence Studio at another computer which is in the same domain and under domain user (non-administrator).
First I get the error "Unsufficient permissions". Then I started Report Manager at the server (http://localhost/Reports/) and under Site Settings / Security added my domain user to both System Administrator and System Users roles, restarted the service, but still got the same error.
Then I created a folder in Report Manager and added domain user to all available roles for that (Browser, Publisher, etc.). After that it doesn't show that error in BIS but instead shows the login dialog (though I already logged as domain user in Windows). I enter login and password but it just asking it again and doing nothing. Tried to enter administrator login details but it also just shown again.
Could you advice me how to enable access to the service or at least to some folder for non-administrator domain user?
ssrs ssrs-2008-r2
asked Dec 4 '12 at 8:09
Aleksey ShubinAleksey Shubin
131113
What browser is being used when the prompt for credentials occurs? I'd recommend using IE as a test to rule out any authentication problem from other browsers.
– Mike
May 21 '16 at 14:52
It is important to add the user in the form <domain><user> when assigning permissions.
– hot2use
Apr 4 '17 at 17:56
add a comment |
I have SSRS 2008 R2 installed on my server and need to deploy report from Business Intelligence Studio at another computer which is in the same domain and under domain user (non-administrator).
First I get the error "Unsufficient permissions". Then I started Report Manager at the server (http://localhost/Reports/) and under Site Settings / Security added my domain user to both System Administrator and System Users roles, restarted the service, but still got the same error.
Then I created a folder in Report Manager and added domain user to all available roles for that (Browser, Publisher, etc.). After that it doesn't show that error in BIS but instead shows the login dialog (though I already logged as domain user in Windows). I enter login and password but it just asking it again and doing nothing. Tried to enter administrator login details but it also just shown again.
Could you advice me how to enable access to the service or at least to some folder for non-administrator domain user?
ssrs ssrs-2008-r2
asked Dec 4 '12 at 8:09
Aleksey ShubinAleksey Shubin
131113
I have SSRS 2008 R2 installed on my server and need to deploy report from Business Intelligence Studio at another computer which is in the same domain and under domain user (non-administrator).
First I get the error "Unsufficient permissions". Then I started Report Manager at the server (http://localhost/Reports/) and under Site Settings / Security added my domain user to both System Administrator and System Users roles, restarted the service, but still got the same error.
Then I created a folder in Report Manager and added domain user to all available roles for that (Browser, Publisher, etc.). After that it doesn't show that error in BIS but instead shows the login dialog (though I already logged as domain user in Windows). I enter login and password but it just asking it again and doing nothing. Tried to enter administrator login details but it also just shown again.
Could you advice me how to enable access to the service or at least to some folder for non-administrator domain user?
ssrs ssrs-2008-r2
ssrs ssrs-2008-r2
asked Dec 4 '12 at 8:09
Aleksey ShubinAleksey Shubin
131113
asked Dec 4 '12 at 8:09
Aleksey ShubinAleksey Shubin
131113
asked Dec 4 '12 at 8:09
Aleksey ShubinAleksey Shubin
131113
asked Dec 4 '12 at 8:09
Aleksey ShubinAleksey Shubin
131113
asked Dec 4 '12 at 8:09
Aleksey ShubinAleksey Shubin
131113
131113
What browser is being used when the prompt for credentials occurs? I'd recommend using IE as a test to rule out any authentication problem from other browsers.
– Mike
May 21 '16 at 14:52
It is important to add the user in the form <domain><user> when assigning permissions.
– hot2use
Apr 4 '17 at 17:56
add a comment |
What browser is being used when the prompt for credentials occurs? I'd recommend using IE as a test to rule out any authentication problem from other browsers.
– Mike
May 21 '16 at 14:52
It is important to add the user in the form <domain><user> when assigning permissions.
– hot2use
Apr 4 '17 at 17:56
What browser is being used when the prompt for credentials occurs? I'd recommend using IE as a test to rule out any authentication problem from other browsers.
– Mike
May 21 '16 at 14:52
What browser is being used when the prompt for credentials occurs? I'd recommend using IE as a test to rule out any authentication problem from other browsers.
– Mike
May 21 '16 at 14:52
It is important to add the user in the form <domain><user> when assigning permissions.
– hot2use
Apr 4 '17 at 17:56
It is important to add the user in the form <domain><user> when assigning permissions.
– hot2use
Apr 4 '17 at 17:56
add a comment |
1 Answer
1
active
oldest
votes
Try changing the following setting in the RSeportServer.config file: AuthenticationType to RSWindowsNTLM
see more info here:
http://msdn.microsoft.com/en-us/library/cc281253.aspx
answered Jan 13 '13 at 0:06
Jason HornerJason Horner
4922411
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
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%2fserverfault.com%2fquestions%2f454832%2fssrs-2008-r2-domain-user-assigned-for-role-but-cannot-access%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
Try changing the following setting in the RSeportServer.config file: AuthenticationType to RSWindowsNTLM
see more info here:
http://msdn.microsoft.com/en-us/library/cc281253.aspx
answered Jan 13 '13 at 0:06
Jason HornerJason Horner
4922411
add a comment |
Try changing the following setting in the RSeportServer.config file: AuthenticationType to RSWindowsNTLM
see more info here:
http://msdn.microsoft.com/en-us/library/cc281253.aspx
answered Jan 13 '13 at 0:06
Jason HornerJason Horner
4922411
add a comment |
Try changing the following setting in the RSeportServer.config file: AuthenticationType to RSWindowsNTLM
see more info here:
http://msdn.microsoft.com/en-us/library/cc281253.aspx
answered Jan 13 '13 at 0:06
Jason HornerJason Horner
4922411
Try changing the following setting in the RSeportServer.config file: AuthenticationType to RSWindowsNTLM
see more info here:
http://msdn.microsoft.com/en-us/library/cc281253.aspx
answered Jan 13 '13 at 0:06
Jason HornerJason Horner
4922411
answered Jan 13 '13 at 0:06
Jason HornerJason Horner
4922411
answered Jan 13 '13 at 0:06
Jason HornerJason Horner
4922411
answered Jan 13 '13 at 0:06
Jason HornerJason Horner
4922411
4922411
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- 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%2fserverfault.com%2fquestions%2f454832%2fssrs-2008-r2-domain-user-assigned-for-role-but-cannot-access%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
What browser is being used when the prompt for credentials occurs? I'd recommend using IE as a test to rule out any authentication problem from other browsers.
– Mike
May 21 '16 at 14:52
It is important to add the user in the form <domain><user> when assigning permissions.
– hot2use
Apr 4 '17 at 17:56