Monday, March 26, 2012

Reporting Services Roles not seeing presenting AD dialog box

Hi,
We have installed RS 2K5 & SQL 2K5 on Windows XP with SP2. SQL and RS have
all patches applied. When we try and set the permissions on a report that
has been uploaded or created we are not able to specify domain users. This
causes the report not to be viewable by the end user we are testing with.
What does happen when you right mouse click on:
Report Server
Home
ReportName
Is you get the window for "Resouce Properties - Home/Reportname. If we then
click on the Add Group or User... button we are prompted with a dialog box
that has a free form text field with the prompt of "type the name of a
security group or user to which you want to give permissions". In all the
examples that we see on line as well as the Microsoft Events (webinars) it
show the AD dialog box prompt so that you can choose someone or something
from AD. In this case we can't. This then leaves us stuck.
We would prefer to run this in Integrated Security mode with Kerberos. We
have the SPN set although we don't need it because IIS and SQL are running on
the same box. We do have the SPN set because future reports will not use the
local database but rather another SQL database as their source for data.
Again the real problem is because we can't set domain or local users
correctly. It is as if somewhere it thinks we have sql authorization set.
Any pointers would be appreciated.You know something, I have never gotten AD to work "quite right" when using
a Windows XP machine - something to do with the behavior of IIS 5.0...
Have you tried this on a Windows Server 2003 machine? (I know that works for
sure). :)
=-Chris
"Fred Lobmeyer" <Lobmeyer@.myalias.postalias> wrote in message
news:FB36D3F8-979B-4864-A064-CE301DB875B2@.microsoft.com...
> Hi,
> We have installed RS 2K5 & SQL 2K5 on Windows XP with SP2. SQL and RS
> have
> all patches applied. When we try and set the permissions on a report that
> has been uploaded or created we are not able to specify domain users.
> This
> causes the report not to be viewable by the end user we are testing with.
> What does happen when you right mouse click on:
> Report Server
> Home
> ReportName
> Is you get the window for "Resouce Properties - Home/Reportname. If we
> then
> click on the Add Group or User... button we are prompted with a dialog box
> that has a free form text field with the prompt of "type the name of a
> security group or user to which you want to give permissions". In all the
> examples that we see on line as well as the Microsoft Events (webinars) it
> show the AD dialog box prompt so that you can choose someone or something
> from AD. In this case we can't. This then leaves us stuck.
> We would prefer to run this in Integrated Security mode with Kerberos. We
> have the SPN set although we don't need it because IIS and SQL are running
> on
> the same box. We do have the SPN set because future reports will not use
> the
> local database but rather another SQL database as their source for data.
> Again the real problem is because we can't set domain or local users
> correctly. It is as if somewhere it thinks we have sql authorization set.
> Any pointers would be appreciated.
>

No comments:

Post a Comment